expression rule t return particular site

You can use this - docs.appian.com/.../fnc_system_a_querylogicalexpression.html

I am using the same . but not able to achieve can you help me with code

Can you paste the code you are using to achieve this?

Ok

I have some quick questions here.

1. Are you getting any errors with this code or you're getting the data unfiltered? 
2. What is the type of isCompleted and isMandatory fields in the DB and CDT ?

I am getting the the site if one of the requestId  isCompleted=0 but it is mandantory set by admin . 

in that case I want the requestedID where both isMandatory and Iscompleted are 1 . If any one of the isCompleted =0 but its isMandatory is set to 1 . then I don't want that requestID

type is Boolean

BY any chance, the DB typically stores a boolean as a tinyInt. In case that value is empty/null, checking for true/false will not work and you might have to include null.

Hi Stefan ,will you share the piece of code 

That depends on your user case, but in general you would do something like this:

operator: "in",
value: {false, null}

But before doing this, try to find out what the actual values in DB look like.

That depends on your user case, but in general you would do something like this:

operator: "in",
value: {false, null}

But before doing this, try to find out what the actual values in DB look like.