For Each Issue

Question

Hi , 
 local!lastRowDetails: a!forEach( items: ri!testCdt, expression: segment: if(and(fv!item.aId=ri!tData_cdt.id , fv!item.tabId=ri!tData_cdt.tName,), fv!item,{}) ) 
 
 This is returning 7 matching rows, but i want only the data of last matched row. 
 
 Can you you help me in that.

JayaKrishna · Accepted Answer

HI 
 
Change according to your need 
you are collecting 7 rows,so max index is 7 
 local!lastRowDetails[7] 
for n rows try this 
load( 
 local!lastRowDetails: a!forEach( 
 items: ri!testCdt, 
 expression: if( 
 and( 
 fv!item.aId = ri!tData_cdt.id, 
 fv!item.tabId = ri!tData_cdt.tName 
 ), 
 fv!item, 
 {} 
 ) 
 ), 
 local!length: length( 
 local!lastRowDetails 
 ), 
 local!lastRowDetails[local!length] 
)

PhilB · Answer

You can do it without using a loop using something like the below; it's a bit difficult to know if this works as you've not given a structure for your CDTs or any sample data, but this should point you in the right direction. 
 index(
 ri!testCdt,
 max(
 intersection(
 wherecontains(
 ri!testCdt.aId,
 ri!tData_cdt.id
 ),
 wherecontains(
 ri!testCdt.tabId,
 ri!tData_cdt.tName
 )
 )
 ),
 null
)