Method Community

when looping through a grid how do I get the bigger record, I have a grid where we keep the hours for the equipment, I only whant to get the record with the most hours, how can I achieve that?

Hi Marcelo,

What if there are multiple records matching this condition? For example, if the highest number of hours for any record is 10, but there are 3 records that have 10 hours. What would you like to do in that situation?

Let me know.

- Justin

That will never happen. it is a grid of work orders completed for the equipment, every work order will have more hours that the one before, the value i need will always be the last work order completed

Marcelo,

I would recommend using two Action Results, one to keep track of the largest number and another to keep track of the RecordID for its record.

Create the Action Result to keep track of the largest number and make it equal to 0 (create this before your Loop Through Grid action). In your Loop Through Grid, use a Conditional Statement to compare the value of hours (for the current record) with that Action Result. If it's larger than your Action Result, store that value of hours to that Action Result and store that record's RecordID to a second Action Result. By the end of the loop, your first AR should contain the highest number of hours from your grid, and your second AR should contain that record's RecordID.

Hope this helps.

- Justin