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?
Discussion posts and replies are publicly visible
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
Thanks Mathieu Drouin. 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
Interesting. Perhaps you could have had 2 synced record types but the relationship would have had to be done via queries rather than relationships?
Can you please elaborate on how we establish relationship using queries?
record relation is based on type of relation and you can pull corrsponding value from related record for the same key and still show all the rows from main record. It should give same output as left join. Isn't?