We have to loop through a database table and get all the attachments from the db

phanibabuk over 9 years ago

We have to loop through a database table and get all the attachments from the db to Appian KC/Folder.
We have used query database and it returns very few rows.
What is the best way to loop through a table containing 1 lac rows.

Your inputs are highly appreciated!!!

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 9 years ago

@phanibabuk As said by Eduardo, retrieving in batches is the only solution. I would like to recommend the usage of a!queryEntity() incase if your implementation involves Appian's OOTB query rules other than Query Database node (Reference: https://forum.appian.com/suite/help/7.10/Querying_Data_From_an_RDBMS.html).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@phanibabuk As said by Eduardo, retrieving in batches is the only solution. I would like to recommend the usage of a!queryEntity() incase if your implementation involves Appian's OOTB query rules other than Query Database node (Reference: https://forum.appian.com/suite/help/7.10/Querying_Data_From_an_RDBMS.html).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data