Skip to main content
V
vasiliss8823
May 15, 2023
Question

Record type related to Database View

  • May 15, 2023
  • 5 replies
  • 1 view

The main question is about how Appian cache the data when you relate a record type to database tables. 

Also does this cache mechanism provided when you relate a record type to database views. 

5 replies

stefanhelzle0001
stefanhelzle0001
Brainy
May 15, 2023

Synced records do not work with DB views. The idea is to make views obsolete with Records.

Synced Record data is stored in the Appian data server which is a no-sql database.

V
vasiliss8823Author
May 15, 2023

So you mean that every time i refer to the view through the record type, i call directly the database? 

Ι know that synced record data do not work with db views but i thought that every individual table that called by the view, synced automatically.

stefanhelzle0001
stefanhelzle0001
Brainy
May 15, 2023

A non-synced Appian Record backed by a database view will query that view every time.

Within a evaluation context Appian tries to cache data in case you trigger the same query twice. But this has nothing to do with synced records.

I do not understand what your mean with "i thought that every individual table that called by the view, synced automatically.". Maybe you want to add some details about your use case.

Terms & ConditionsAccessibility statement