144871 - no subject - Hi Team,\n\nWe know 10,000 is the max we

madhankumarb over 9 years ago

Hi Team,

We know 10,000 is the max we can set as max row return in execute process report smart service. For one of requirement we need to update a process variable in 44,000 process instances. We wrote a process model to query the report for 10,000 records and update the process variable. So if only 10,000 instance can be updated what about remaining 34,000 instances?
Is this an open issue in Appian?. Any idea how people will query if report has more 10,000 records.
Team Please advise.

Regards,
Madhankumar. B

Discussion posts and replies are publicly visible

0 Conor Cahill
Certified Lead Developer
over 9 years ago

Could you put the PV that you need to update in the report, and then filter on it so only processes that haven't been updated would show up? Then you would just have to repeatedly run the report after updating the PV until there are no rows left in the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@madhankumarb Please find attached the document which describes how to query more than 10000 records using expression rules. The same approach was implemented in our project and we were able to extract 127000+ records with out any issues. Also this approach can be useful for the same kind of scenarios down the line. This approach even supports if there are 10000 instances per day, typically a worst case scenario.

An optional way is to speak to your server admin about increasing the value of resources.appian.analytics.application.maxreportrows= which controls the volume of records that can be queried from process analytics.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel