How to get a particular row of record from a list

How to get a particular row of record from a list

  

Hi All, 

I would like to fetch a particular row of records from a list by providing the row number in the input (instead of .Current.Entity.Attribute , something similar to ABC.[i].Entity.Attribute, where i is the row number).


Kindly let me know the syntax for such a search.


Thanks and Regards,

Priyadharshini S



Hey Priyadharshini,

Just replace the ".Current" by [index] that you want and it should do the trick.

Cheers

Henrique Batista wrote:

Hey Priyadharshini,

Just replace the ".Current" by [index] that you want and it should do the trick.

Cheers

Hi Henrique, 


Thank you. I'm getting an error saying unexpected [ in the expression. Kindly let me know if any specific syntax to be followed.


Thanks and Regards,

Priya


Solution

Hello Priya,

Be sure to remove the "." like Henrique mentioned ( "(...)replace the ".Current" by [index](...)") :)
So if you want the "Attribute" from a certain "Entity" from the second row from the aggregate "ABC" you would use something like:

ABC.List[1].Entity.Attribute

If "ABC" is a single entity list you should use something like:

ABC[1].Attribute



Kind regards

Solution