Question

Advanced filter with brackets does not work in Business Reporter

  • 10 October 2020
  • 1 reply
  • 223 views
D
Rank
Badge +5

Hi All,

 

I created a BR report with advanced filter including brackets (as shown in below ).  But when I executed it I did not get the desired output.

 

when looked at the Data set info from Debug Information I noticed the advanced filter was not executed correctly.

 

BR version I used:

I tried changing the below BR execution parameter values from TRUE to FALSE, but it did not help to resolve the issue.

 

 

Can someone please help me to resolve this issue?

 

Thank you!

Disna M.

 

 

1 reply

A
Rank
Badge +4

I agree that the executed WHERE statement does not look as it should given your input, but on the other hand, your WHERE could be boiled down to “POSTING_TYPE IN (‘M273’, ‘M274’)”.

Reply


Terms & ConditionsCookie settings