Skip to main content
E
edwardc8281
June 9, 2025
Question

Record type sync

  • June 9, 2025
  • 7 replies
  • 0 views

I noticed that if I use sql to update data, the data in record type need to sync manually. 

I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.

7 replies

tejak2639
tejak2639
June 9, 2025

Hi [mention:c175878b6d0741989dcd8272751de6f9:e9ed411860ed4f2ba0265705b8793d05] 
Is there any particular reason you are updating the data through database using SQL instead of using Appian related actions for it. AFAIK if the data is updated through SQL script from database then a manual sync is needed to sync the data. So, every time you use the SQL to change the data, come to that particular record and sync the data.

stefanhelzle0001
stefanhelzle0001
June 9, 2025

This is by design. Do you have a specific reason to not write the data through records?

    harshas2775
    harshas2775
    June 9, 2025

    For ad-hoc updates in database like you have in your case there is no other way. Syncs can be scheduled to run at specific time only. So, the best way is to update data using records itself or sync every time to make changes in db data manually. 

    konduruc733182
    konduruc733182
    June 9, 2025

    Hello [mention:c175878b6d0741989dcd8272751de6f9:e9ed411860ed4f2ba0265705b8793d05] 

    Not sure why the records are being updated from backend. Could you please elaborate why if there is any particular reason. Also you can create a Process model with Sync Records smart service and try scheduling it to run for particular intervals.

    E
    edwardc8281Author
    June 9, 2025

    In the current phase of our project, we only develop a read-only UI, so we must initialize the data from backend.

    venkatrea696188
    venkatrea696188
    June 9, 2025

    Instead of writing it to DB and trying to sync it , go for changing the source of the record . Go for service or salesforce based records

    davidj137213
    davidj137213
    June 10, 2025

    In the case of synced records, if you don’t update them using the Appian-recommended smart services and instead update the database directly, your record will not be synchronized and you’ll be working with an invalid version of the data.

    This is especially important for both reading and writing operations, in order to maintain the integrity of the system's data structure—particularly in systems with external data sources where multiple actors may be involved in reading and writing.

    Terms & ConditionsAccessibility statement