Hi,
To get a value from a memory CDT list (not a table) on a single field condition, I use Index(CDT, whereContains(value, CDT.field2)).
In SQL : SELECT * FROM table WHERE field2 = value
Is there any way to do the same thing with Appian fonctions when we need to make a lookup with an AND condition ?
Ex : SELECT field1 FROM table WHERE field2 = value AND field3 = value
Otherwise, I would do it with a simple foreach().
(PS : My question, is "not" about how to query a table with multiple logical conditions of queryEntity )
Discussion posts and replies are publicly visible
I'm not sure that "filter" function could make the job....