Filter and organise data from database

Question

Hi! 
 I have a cdt that contains a list of cdts. My question is, is it possible to filter the data so that in a list it shows me only those that contain a special element in that list of cdt ?.

For example, I try to find the cdt that contains element 1 in your list. But my problem is that I don't know how to filter based on an if, that is, based on true or false.
Can anyone help me here? Thanks in advance!

Danny Verb · Answer

I recommend viewing our query recipes https://docs.appian.com/suite/help/20.1/Query_Recipes.html#overview 
 You can query and filter data from a list of CDTs, using the visual query editor will help with that https://docs.appian.com/suite/help/20.1/using-the-query-editor.html