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...

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