How to index a row in a CDT with an AND condition

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 [emoticon:bfea11b94cc048458ee2c01f963db38d] )