Skip to main content
Solved

Issue with Business Reporter Filters

K
Do Gooder (Partner)
Forum|alt.badge.img+3

Hello,

I hope this message finds you well.

I am currently facing an issue with Business Reporter and would appreciate your assistance. I am trying to filter accounts that start with ‘6’ and ‘7’. As shown in the attached screenshot, I added a "LIKE" condition in the filter criteria. However, I received an error message indicating that the syntax is incorrect.

Additionally, it seems I cannot add multiple rows to define separate filters for each condition.

If there is an alternative solution to achieve this filtering, I would be grateful if you could share it with me.

Thank you in advance for your help!

Best regards,
Karim

 

Best answer by Furkan Zengin

Hi again,

I think better option is to use advanced parameter with the code I shared. Because when you enter parameter BETWEEN ‘6%’ AND ‘7%’, it will return you anything start with 6 until anything start with 7. But it will not show you result any account starting with say 71 etc.

Either change parameter to BETWEEN ‘6%’ AND ‘8%’ so it will cover range of 7 accounts. Or use the advanced filtering.

Hope this helps

View original

Furkan Zengin
Superhero (Partner)
Forum|alt.badge.img+21
  • Furkan Zengin
  • Superhero (Partner)
  • 696 replies
  • January 7, 2025

Hi,

You cannot use asteriks (*). You must use percentage (%).

Try entering BETWEEN ‘6%’ AND ‘7%’

Or go to advanced filtering and use the following 

(DIM_ACCOUNT.CODE LIKE '6%' OR DIM_ACCOUNT.CODE LIKE '7%’) AND
DIM_CODE_D.CODE IS NOT NULL AND
DIM_COMPANY.CODE = &Company

 

Hope this helps

https://superp.solutions/
Marcel.Ausan
1 person likes this
  • Marcel.Ausan
    Marcel.Ausan
K
Do Gooder (Partner)
Forum|alt.badge.img+3
  • Karim.katif5
  • Do Gooder (Partner)
  • January 7, 2025

Hi ,

Thank you for your suggestion. I’ve tried using BETWEEN '6%' AND '7%', but unfortunately, it doesn’t seem to return the expected results any ‘6%’.

Additionally, when I use LIKE, it results in an error message. Could you please clarify if there are any additional settings or steps I might need to adjust?

Looking forward to your guidance.

Best regards,
Karim

 

Furkan Zengin
Superhero (Partner)
Forum|alt.badge.img+21
  • Furkan Zengin
  • Superhero (Partner)
  • 696 replies
  • Answer
  • January 7, 2025

Hi again,

I think better option is to use advanced parameter with the code I shared. Because when you enter parameter BETWEEN ‘6%’ AND ‘7%’, it will return you anything start with 6 until anything start with 7. But it will not show you result any account starting with say 71 etc.

Either change parameter to BETWEEN ‘6%’ AND ‘8%’ so it will cover range of 7 accounts. Or use the advanced filtering.

Hope this helps

https://superp.solutions/
K
1 person likes this
  • K
    Karim.katif5

Reply


Terms & ConditionsCookie settings

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