Skip to main content
Question

Advanced filter with brackets does not work in Business Reporter

  • October 9, 2020
  • 1 reply
  • 240 views

Forum|alt.badge.img+5
  • Do Gooder (Partner)
  • 10 replies

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

Forum|alt.badge.img+6
  • Do Gooder (Partner)
  • 10 replies
  • January 15, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings