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?

Regards,

Timur

Outcomes