How to query Filter multiple conditions on multiple columns?

Hi Anusha S,
AFAIK Appian does not support the filters on the fields of nested cdt in a query entity. But How ever you can load the data by filtering with the field in the parent cdt and then refine the data in appian side for the next filter that you want to apply on the field of nested cdt.

Appian does support filtering by fields of a nested CDT - but you might run into difficulties if the nested CDT is a multiple.

To answer the original question, you can just just dot notation within the field property of your query entity filter if the nested CDT is not multiple, but otherwise you'll have to run two separate queries to retrieve the data you require.

Appian does support filtering by fields of a nested CDT - but you might run into difficulties if the nested CDT is a multiple.

To answer the original question, you can just just dot notation within the field property of your query entity filter if the nested CDT is not multiple, but otherwise you'll have to run two separate queries to retrieve the data you require.