Repeater Action Next Row Read

[former_member8532]

Hello All,

I have a requirement in repeater action block.

I have put a repeater action on an XML return by SQL query action block. I am reading the data for each iteration.

But i have to read the data for next row when it's reading current row.

Suppose below is the data. When repeater is reading 2nd row data(DEF) i want to read 3rd row data (GHI) in the same iteration .

1	ABC
2	DEF
3	GHI
4	XYZ

Regards.

Anshul

[former_member185280 · Accepted solution]

You can try using a dynamic link. Something like this:

sqlQuery.Results{/Rowsets/Rowset/Row[#Repeater.CurrentItem#+1]/VALUE}

[Former Member]

Hi Anshul,

You can use the dynamic path as suggested by Christian to achieve your desired result.

Just you have to restrict the number of iterations of your repeater, else it will give you a blank value for its last iteration. e.g. you have n rows in your xml, then (n+1)th value will not exist. and hence it gives a blank value.

Warm Regards,

Anuj