Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
4 subscribers
Views
2109 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi, I am using "Execute Process Report " smart service for
sapnas
over 8 years ago
Hi,
I am using "Execute Process Report " smart service for one of my requirements.
The requirement is - I need to fetch subset of the records say., 100 records from the portal report that has about 10000 records and persist to a database. This way I would like to repeat the process until all records/data are fetched and moved to database.
As per the configuration of the aforementioned smart service, "Max Rows" field allows us to set the batch size as 100 but the problem I see is this smart service does not have the provision to fetch the next 100 rows once the first 100 rows are processed.
When I tested this in loop I observed that every time on execution the smart service returns only first 100 rows from the portal report but does not fetch the next set and so on.
Could you please let me know if the behavior of this smart service is limited to fetching only first 100 rows if the Max Rows field is set to 100 and does not help in fetching f...
OriginalPostID-164161
OriginalPostID-164161
Discussion posts and replies are publicly visible
Parents
0
Lakshmi Meyyappan
over 8 years ago
If you want to continue to use the Execute Process Report, you may be able to use a filter to fetch subsequent sets. You can filter on the data's unique ID. So the first time it will run all ID's >0, then you take the biggest ID in the returned data and set it to filter all ID's>biggest returned ID. But this is more of a work-around, using queryProcessAnalytics() would be the better option so that you can use paging info.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Lakshmi Meyyappan
over 8 years ago
If you want to continue to use the Execute Process Report, you may be able to use a filter to fetch subsequent sets. You can filter on the data's unique ID. So the first time it will run all ID's >0, then you take the biggest ID in the returned data and set it to filter all ID's>biggest returned ID. But this is more of a work-around, using queryProcessAnalytics() would be the better option so that you can use paging info.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data