Nested for each

It's not clear to me what this table is (database? gridrowlayout? something else?) so I can't visualize what you are trying to do exactly.

However, generally speaking, a!forEach can be nested, but you'll need to figure out what the appropriate items value are. From the description, it could be something like this:

a!forEach(
items:{1,2,3} /* some value representing the rows */,
expression:
if(fv!item=1){ a!forEach(items: row_1_data, expression:...)}
if(fv!item=2){ a!forEach(items: row_2_data, expression:...)}
if(fv!item=3){ a!forEach(items: row_3_data, expression:...)}
)

forEach would return all resulting values as an array. If you can describe your use case in more detail, I might be able to provide a better suggestion.

Hi digantas  adding to  Justin Watts  comment, also if you want to hold the values of nested foreach , you can define a local variable on top load() and within foreach you can define an another load() where for each iteration you need to append fv!item to local variable.

But this approach will cause you performance issue. I recommend, if these data are coming from db, and If they have any relationship, then try to join them and then perform single level of foreach instead of nested.

Hope this will help you.

Hi digantas  adding to  Justin Watts  comment, also if you want to hold the values of nested foreach , you can define a local variable on top load() and within foreach you can define an another load() where for each iteration you need to append fv!item to local variable.

But this approach will cause you performance issue. I recommend, if these data are coming from db, and If they have any relationship, then try to join them and then perform single level of foreach instead of nested.

Hope this will help you.

 

I have rows like this.1st row is returning 3 items.I want to apply an expression rule,which returns the name of these IDs.I want to retain these 17 rows e.g 1st row returning {scott,shawn,alex} and so on.If there is one value in one field,it will return one name only.

when i am trying t

digantas as per understanding , you want to iterate on each value and perform the business operation on it, in that case for the above output snapshot use a!flatten function and apply for each.
Note : this function is available from 17.3 onwards
documentation : docs.appian.com/.../fnc_array_a_flatten.html

Regards,
Sachin