Applicable on query grid record operation ignored (SOLVED)

ddumas

NOT(EXISTS MemberBlocks WHERE (MemberBlocks.BlockedMember=LoggedInMember AND MemberBlocks.Member=Member))

The above works great in a WHERE clause for a query, but in an "Applicable" condition on a query grid record operation, is ignored.

Member owns MemberBlocks (allow multiple) MemberBlocks.Member points back to the parent Member. MemberBlocks.BlockedMember points to a peer Member (who is being blocked).

So, the condition should not allow the (Email in this case) record operation to appear if the MemberBlocks.BlockedMember is the LoggedInMember, for the Member that has "blocked" them.

I use "Applicable" conditions on query grids record operations, and they work great. this one gives no error but is just ignored.

Dave

aware_support

Not all expressions are supported in applicability conditions. Check out Tomcat log which should have diagnostics on how this condition is evaluated. Most probably it's a limitation.

ddumas

Not a problem. I can add the filter as an additional WHERE clause condition to the underlying filter for the query.
Dave

ddumas

The workaround worked - adding the applicability condition as an additional WHERE condition to the underlying query .
Dave