there are 10 rows in a table, and corresponding 10 records appear in records lis

bragadeeshp over 8 years ago

there are 10 rows in a table, and corresponding 10 records appear in records list. if a new 11th row gets inserted into the table, how does the 11th record appear in records list ? is it Appian that "pulls" or any wrapper around DB table that "push" the new row data into CDT ? Thanks

Discussion posts and replies are publicly visible

0 abhinavg over 8 years ago

If it's a query backed record and everytime the record is clicked/opened, the record expresson query will fetch the latest records from table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 8 years ago

Until the records are access next time (navigated), the values are not refreshed and the entity is not re-executed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bragadeeshp over 8 years ago

thanks for the response. what if the user would like to be notified that a 11th record is available so the user can go and view the latest data ?
I'm trying to understand if "push" mechanism is possible instead of "pull" (after user clicks on records tab) with entity backed ? thanks again
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

Normaly a process adds data to database so you can just send some king of notification to the user. A news feed can be used for that. But check news feed design best practices first. If data is written to DB by some external system, this system could trigger a process in Appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Bragadeeshp, As per my understanding until a new event is triggered, the records are not retrieved back.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bragadeeshp over 8 years ago

Yes, new rows into the tables are inserted by external systems. Now, if every new DB row has to be pushed into Appian as a record (even before users clicks on Records tab) does it have to be an Entity backed record or Service backed record ?
Thanks again
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

I think the understanding of "pushing" something is not correct. Records are live views on databases, processes or external systems. Data is fetched as the user navigates to the record list.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel