How to query first row from a datasubset
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)
- field"caseId"(Text)
-
SortInfo
- 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))
- caseId322(Number (Integer))
-
Dictionary
- caseId21326(Number (Integer))
- caseStatus"On-Hold/Request for Info"(Text)
- clientName"user1520872"(Text)
- folderId154459(Number (Integer))
- caseId21326(Number (Integer))
-
Dictionary
- caseId21327(Number (Integer))
- caseStatus"Ready For Underwriting"(Text)
- clientName"user1520872"(Text)
- folderId154458(Number (Integer))
- caseId21327(Number (Integer))
-
Dictionary
- caseId52046(Number (Integer))
- caseStatus"Ready For Underwriting"(Text)
- clientName"user1520872"(Text)
- folderId154458(Number (Integer))
- caseId52046(Number (Integer))
-
Dictionary
- caseId59106(Number (Integer))
- caseStatus"On-Hold/Request for Info"(Text)
- clientName"user1520872"(Text)
- folderId154459(Number (Integer))
- caseId59106(Number (Integer))
-
Dictionary
-
identifiersList of Number (Integer) - 5 items
- 322(Number (Integer))
- 21326(Number (Integer))
- 21327(Number (Integer))
- 52046(Number (Integer))
- 59106(Number (Integer))
- 322(Number (Integer))
