AnsweredAssumed Answered

Looking for help with whereclause constraint

Question asked by cdtj Champion on Mar 2, 2016
Latest reply on Mar 4, 2016 by J_W

Hello community!

I'm trying to build query over BREL, i'm using custom tables, but for test purposes Requests table could be used.

For example: I want to show requests with activity log status change and description text equal "test".


Query will look:

alg.type = 'RE' AND alg.description like 'test'

everything works fine, now I want to restrict showing Requests with the same parametrs,


alg.type = 'RE' AND alg.description not like 'test'

works fine if there is Resolving activity exists but with another comment,


not(alg.type = 'RE' AND alg.description like 'test')

also working in vary situations.


My goal and question, is it possible to build query that will show: Requests with specified activity log and specified comment or Requests without that activity at all, in a single query?