Indexing an array of records

Question

Appian 25.3 
 
 I'm using a!queryRecords(.....).data to get an array of records from my record type in a process model. Next, I setup a loop and need to index each record in the array. However, this syntax does not work within the process model: 
 pv!myRecords[pv!recordIndex] 
 
 I receive this error: 
 An error occurred while evaluating expression: myRec:pv!myRecords[pv!recordIndex] (Expression evaluation error: PE My RecType must be indexed by its corresponding record type fields or relationships) (Data Outputs) 
 
 This exact, same syntax works if I move it into an expression rule and call that from the process model. 
 The process variable is of the exact same type as the rule input on the expression rule (i.e. array of my record type). Yet, I cannot index the array directly in a script task in the process model 
 
 Is there something I'm doing wrong here? 
 
 Thank you.

Mike Schmitt · Accepted Answer

What happens if you replace "pv!recordIndex" in your test code here with the literal value of "1"? e.g. index(pv!record, 1, null()) 
 Because I suspect this might be messing you up:

Shubham Aware · Answer

recordIndex is Text, not Integer. Record arrays must be indexed by an integer. Change recordIndex to Number (Integer), or use index(pv!performanceRecords, tointeger(pv!recordIndex), null).

Shubham Aware · Answer

Bracket notation on a record array is reserved for field/relationship indexing, not integer position.Bracket notation on a record array is reserved for field/relationship indexing, not integer position. Use index(pv!myRecords, pv!recordIndex, null) instead.

Stefan Helzle · Answer

pv!myRecords[pv!recordIndex] works, if the PV is a list.

Mike Schmitt · Answer

is the PV actually set to Array/Multiple type?

Mike Schmitt · Answer

e.g.

Indexing an array of records

Top Replies