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 rajivr
Certified Associate Developer
over 9 years ago

When u have more no of rows in a table, other way around is:
you can configure the pagingInfo parameter(default parameter) of your query rule.
Say u have query rule rule!myQueryRule(pagingInfo). you can configure this within a with loop in a script task and do your batch processing within that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rajivr
Certified Associate Developer
over 9 years ago

When u have more no of rows in a table, other way around is:
you can configure the pagingInfo parameter(default parameter) of your query rule.
Say u have query rule rule!myQueryRule(pagingInfo). you can configure this within a with loop in a script task and do your batch processing within that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data