Hi All ,
I have a query regarding Expression rule .I have DB where isCompleted and IsMandatory fields are there with repect to particular requestID
Example:
here I want to return only those sites which have isCompleted=1 for all the isManatory=1
in the above example , i must get only requestid =2
Discussion posts and replies are publicly visible
community.appian.com/.../sending-a-message-in-a-google-chat-with-links
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.
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.