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 Eduardo Fuentes
Appian Employee
over 9 years ago

You could do it in batches based on the primary key or some other criteria.

In regards to the number of rows returned by the node, this is the setting in charge:

## The limit to the number of rows returned in the Database Access node
#resources.appian.process.application.arv.limit=10
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

You could do it in batches based on the primary key or some other criteria.

In regards to the number of rows returned by the node, this is the setting in charge:

## The limit to the number of rows returned in the Database Access node
#resources.appian.process.application.arv.limit=10
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data