Skip to main content
aswinkarn418986
aswinkarn418986
July 11, 2023
Question

Difference between un synced record type and query entity

  • July 11, 2023
  • 8 replies
  • 0 views

I have a record type which is not a synced type. It is referred using a CDT. I understood that synced records have better performance. I want to understand the difference between un synced record type and query entity, both are basically trying to fetch values from the Database.

Can we use query entity instead of unsynced records?

    8 replies

    A
    amiteshs3330
    July 11, 2023

    [mention:dafd1de8eb7a44fa9c2bd49ae2a31dc4:e9ed411860ed4f2ba0265705b8793d05] Records are new appian way of accessing the data from database as well as forming relations (view), whereas for achieving the same thing using cdt method you would need to create a seperate view and create a seperate cdt object for that view.

    Also records can have relation with other system objects like entity(tables) residing in Salesforce

    aswinkarn418986
    aswinkarn418986Author
    July 11, 2023

    Thanks [mention:1f165d0242ce4a039a8d16bc75ec929b:e9ed411860ed4f2ba0265705b8793d05]. In my use case i tried synced records and establised the realtionship instead of view, but it was not accepted. So I had to create a view and then i created a record type for that view.

    I just want to understand if my way of creating a record type for a view and then displaying it in a table is better or should I directly get the data from the view using queryEntity().

    Is there any performance difference between these two?

    mathieud0001
    mathieud0001
    Brainy
    July 11, 2023

    f you have a Record against a view, it will have to be unsynced so I don't think there should be much of a difference performance wise.

    mathieud0001
    mathieud0001
    Brainy
    July 11, 2023

    Yes you can use entities instead of records but you'd be missing out on one of the most powerful features: relations where you can bring in data from other sources and make relationships with the data stored in your application. Relations should also simplify the way you manage data within your application.

    docs.appian.com/.../Record_Type_Object.html

    aswinkarn418986
    aswinkarn418986Author
    July 11, 2023

    Thanks [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]. I dont have my data from multiple sources. My main concern was i need to establish "LEFT JOIN" between the tables. I was not able to perform the left join in records, so i opted for views

    mathieud0001
    mathieud0001
    Brainy
    July 11, 2023

    Interesting. Perhaps you could have had 2 synced record types but the relationship would have had to be done via queries rather than relationships?

    Terms & ConditionsAccessibility statement