Skip to main content
jamesm4933
July 15, 2025
Solved

Record Sync Filter Fails when using Sync Records smart service for filter on relationship value

  • July 15, 2025
  • 4 replies
  • 0 views

We are updating an old application from CDT/DSE to Record Types.  In a certain process a parent record is written, then child records are generated with foreign key values for the parent and they are written.  This is all done with the existing CDTs and DSEs.  The data propagates to the new Record Types as desired.

However, we have a business critical sync filter on the Child record type that is intended to prevent certain statuses on the parent record from allowing anyone to find related children.  This filter is not being applied by the data propagation feature.  

Believing that perhaps it was a syncing issue, I tried using the Sync Records smart service in various combinations with both the Parent and Child records.  Syncing the Child records, then the Parent, then I tried the Parent first and then the Child.  Nothing worked.

It is my belief, that the Sync Records smart service is not sourcing the Related record when applying the sync filter.  

As a workaround, we have applied Record Level security for the affected records, and this appears to be working.

How can I ensure that the Sync Records smart service correctly applies the Sync Filter?

Best answer by laura.marin

It's on the backlog as an enhancement, but currently related record source filtering applies during a full sync. 

Doc Reference

4 replies

stefanhelzle0001
July 15, 2025
prevent certain statuses on the parent record from allowing anyone to find related children

This is clearly something I would want to use record level security for.

jamesm4933
July 15, 2025

Agreed.  However, one would think that the Sync Filter should be correctly applied when syncing.  Wouldn't you agree?

stefanhelzle0001
July 15, 2025

I would ;-) This might be an edge case. Open a support case to discuss this with Appian.