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?