How to fetch data in sequence and run the process in a batch

Better way to achieve the same is querying the 100 records, do manipulation on them in an expression rule using a!foreach() and then pass the output of the rule in the write records node. 

Thank you Harsha Sharma  Could you please advise how to write this using a!foreach() function?

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. 

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

Thank you Harsha Sharma  Could you please advise how to write this using a!foreach() function?

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. 

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

HI. Try this inside a script task, and save the result in a map variable of type 'multiple'.

a!forEach(
  items: pv!data.data,
  /*adjust the logic based on your requirement*/
  expression: a!update(
    data: fv!item,
    index: "caseStatus",
    value: "ACTIVE"
  )
)

Thanks osanchea  In the expression part of a!forEach I don't want to perform any update, instead just fetch the first row of data and then in the next flow I will perform some actions. How do I fetch the first row of data? and then after lopping this same rule should fetch second row of data, third row of data....

In that case, you can follow these steps:
1. create a process variable "counter"  and set value 1(default)
2. To reference each iteration use this expressión: index(pv!data, pv!counter, null)
3. Configure XOR node --> pv!counter<100, if yes, go to "counter node +1", if no go to "end node"
4. Increment counter +1 and save value in pv!counter---> pv!counter + 1

Thank you so much osanchea  really appreciate it.