Getting All active Instance using queryProcessAnalytics function

Hi All ,
We have Created one portal report which are all active process in environment , After getting these data we are calling portal report by using a!queryProcessAnalytics() in expression rule.
Here we have 98177 records and am getting data based on query filter and if we pass batch size as -1 it return's empty portalDataSubset,So how can we get all the data?
Thanks In Advance.

  Discussion posts and replies are publicly visible

Parents Reply
  • Thanks for the response,
    May be i am wrong but I have done another Approach :
    In main expression rule am getting records this time batch size is 1000 ,based on totalCount am generating startIndex like
    1+enumerate(int(local!portalDataSubset/1000))*1000 it will give 1,1001,2001,3001....etc.
    In sub expression rule am calling same portal report and same filter using a!queryProcessAnalytics() above startIndexs are looping.
    Example:
    apply(rule!subExpressionRule(_),{1,1001,2001,3001....etc}) , In this case up to 10000 am getting data but whenever we pass 10001 paginInfo startIndex it return's empty portalDataSubset.
Children
No Data