How to query first row from a datasubset

Certified Associate Developer

Hi All,

I have my expression rule as below and I'm trying to get 100 records in 1 batch to pass to the process model. Now I need to fetch the 1st row from this rule output into a process model - perform some action and then loop back to fetch the second row - perform some action, loop back third record to fetch 3rd row and so on until I reach my 100th record. Please advise what expression do I need to write here to fetch the rows and loop back?

Rule:

a!localVariables(
local!getData: a!queryEntity_22r2(
entity: cons!SAC_ENTITY_CLIENTCASES,
fetchTotalCount: true,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {

),
a!queryFilter(
field: "docsSent",
operator: "is null"
)
}
),
selection: a!querySelection(
columns: {
a!queryColumn(field: "caseId"),
a!queryColumn(field: "caseStatus"),
a!queryColumn(field: "clientName"),
a!queryColumn(field: "folderId")
}
),
pagingInfo: if(
rule!APN_isBlank(
ri!pagingInfo
),
a!pagingInfo(
startIndex: 1,
batchSize: 5,
sort: a!sortInfo(
field: "caseId",
ascending: true
)
),
ri!pagingInfo
),
)

),
local!getData
)

Output of the Rule saved into PV of type data subset in process model:

  • startIndex1(Number (Integer))
      • batchSize10(Number (Integer))
          • sortList of SortInfo - 1 item
              • SortInfo
                  • field"caseId"(Text)
                      • ascendingtrue(Boolean)
                      • totalCount5(Number (Integer))
                          • dataList of Dictionary - 5 items
                              • Dictionary
                                  • caseId322(Number (Integer))
                                      • caseStatus"On-Hold/Request for Info"(Text)
                                            • clientName"user1520872"(Text)
                                                • folderId214625(Number (Integer))
                                                  • Dictionary
                                                      • caseId21326(Number (Integer))
                                                          • caseStatus"On-Hold/Request for Info"(Text)
                                                                • clientName"user1520872"(Text)
                                                                    • folderId154459(Number (Integer))
                                                                      • Dictionary
                                                                          • caseId21327(Number (Integer))
                                                                              • caseStatus"Ready For Underwriting"(Text)
                                                                                    • clientName"user1520872"(Text)
                                                                                        • folderId154458(Number (Integer))
                                                                                          • Dictionary
                                                                                              • caseId52046(Number (Integer))
                                                                                                  • caseStatus"Ready For Underwriting"(Text)
                                                                                                        • clientName"user1520872"(Text)
                                                                                                            • folderId154458(Number (Integer))
                                                                                                              • Dictionary
                                                                                                                  • caseId59106(Number (Integer))
                                                                                                                      • caseStatus"On-Hold/Request for Info"(Text)
                                                                                                                            • clientName"user1520872"(Text)
                                                                                                                                • folderId154459(Number (Integer))
                                                                                                                                • identifiersList of Number (Integer) - 5 items
                                                                                                                                    • 322(Number (Integer))
                                                                                                                                        • 21326(Number (Integer))
                                                                                                                                            • 21327(Number (Integer))
                                                                                                                                                • 52046(Number (Integer))
                                                                                                                                                    • 59106(Number (Integer))

                                                                                                                                                    Discussion posts and replies are publicly visible

                                                                                                                                                  Parents Reply Children
                                                                                                                                                  No Data