a!queryRecordType: Expression evaluation error at function fn!error [line 28]: An invalid value for "batchSize" was used. The batch size when querying record data must be between 0 and 5,000.

Want To fetch the data more than 5000 . let me know how to fetch

rule!PPO_qrtName(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 7000)
).data,

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Senior Developer
    in reply to Klaus34

    a!localVariables(
      local!batchSize: 5000,
      local!totalCount: index(
        a!queryRecordType(
          recordType: /*Put your record here*/,
          pagingInfo: a!pagingInfo(1, 1)
        ),
        "totalCount",
        {}
      ),
      local!maxNumberBatch: ceiling(local!totalCount / local!batchSize),
      local!enumeratedIndex: enumerate(local!maxNumberBatch) + 1,
      a!flatten(
        a!forEach(
          items: local!enumeratedIndex,
          expression: a!flatten(
            a!queryRecordType(
              recordType:/*Put your record here*/,
              pagingInfo: a!pagingInfo(
                1 + ((fv!index - 1) * local!batchSize),
                local!batchSize
              )
            ).data
          )
        )
      )
    )

Children
No Data