Applicable on query grid record operation ignored (SOLVED)

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Applicable on query grid record operation ignored (SOLVED)

Post by 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
Last edited by ddumas on Mon Dec 30, 2019 1:31 am, edited 1 time in total.
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Applicable condition on query grid record operation igno

Post by 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.
Aware IM Support Team
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: Applicable condition on query grid record operation igno

Post by ddumas »

Not a problem. I can add the filter as an additional WHERE clause condition to the underlying filter for the query.
Dave
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: Applicable condition on query grid record operation igno

Post by ddumas »

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