How to Filter data from Rule input with is of type cdt ? for example ri!Questions is of type cdt where i want the only data with active =1 , ri! questions contiains active 0 and 1 data both.
Discussion posts and replies are publicly visible
I can do with the query rule but want to filter from ri
Hi there,
Have you tried index?
index(ri!Questions, wherecontains(true(),ri!Questions.active),null),
Hope that helps
Acacio B.
/*For single Condition*/a!forEach( items: ri!Questions, expression: if(fv!item.active, fv!item, {})),/*For multiple Conditions*/
a!forEach( items: ri!Questions, expression: if(and(fv!item.active,fv!item.id>1),fv!item, {}))
index( ri!Questions, tointeger( wherecontains( 1, tointeger(index(ri!Questions,"isActive", "")) ) ), {} )
Even i have similar question. for example i have ri!applimitcdt and want to display selected rows. selected rows values are in ri!selected_id. how can i display only these selected values