Skip to main content
G
gangamadhur0002
March 29, 2026
Question

Self join record type data sync

  • March 29, 2026
  • 4 replies
  • 0 views

Hi All,

I have self joined Record type. Write records plugin, smartservice both are getting successful, but persisted records are not  getting sync. Even though I manually sync, the data is not reflecting. See below

What could be the root cause?

Thanks

Madhu

4 replies

stefanhelzle0001
stefanhelzle0001
March 29, 2026

This is not much information you share ...

The older syncs also only show 3 of 5 synced. Seems like sync was never working well.

BTW, what exactly do you mean with "self-joined"?

shubhama926776
shubhama926776
March 30, 2026

The most likely cause is the self-join relationship interfering with sync indexing, potentially creating ambiguous or duplicate row mappings that cause sync to complete but persist 0 rows. To confirm, temporarily remove the self-join relationship, run a full sync, and check if rows sync correctly - if they do, the self-join is the root cause.

G
gangamadhur0002Author
March 30, 2026

Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] ,[mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05] , Thanks for your resopnse. It was caused by sync filters. I relaxed them and it is all good now.

Appian changed the default filters as sync filters under sync options.

    S
    springfiem924886
    March 31, 2026

    @ Solar Smash
    Hi Madhu, that's a tricky one! Self-joins can definitely be finicky with data syncing. Are you checking for potential circular dependencies? 

    Terms & ConditionsAccessibility statement