Forum Discussion
URL filter problem using with some special characters
Hello Community, I want to use URL filtering for my reports. But I have faced with some character problem. This is my scenario: I have a table with name 05. Country and a column name Country ...
Hi v-easonf-msft,
I already know the problem, so imagine that you have a table name 05. Country and field Country #, you need to put this:?filter=_x0030__x0035__x002E__x0020_Country/Country_x0020__x0023_ eq 'Denmark'so when you put special characters you need to put double __ between them. And be careful with ' symbol because I figured out that I was facing a problem with my keyboard when I used this ' symbol (because my keyboard is in Portuguese not in US International). So the best approach to not change the default language of your keyboard is use this format:?filter=_x0030__x0035__x002E__x0020_Country%2FCountry_x0020__x0023_%20eq%20%27Denmark%27When I use that format, it is working well in my side.
Kind regards,
Bruno Franco.
Hi v-easonf-msft,
I already know the problem, so imagine that you have a table name 05. Country and field Country #, you need to put this:
?filter=_x0030__x0035__x002E__x0020_Country/Country_x0020__x0023_ eq 'Denmark'
so when you put special characters you need to put double __ between them. And be careful with ' symbol because I figured out that I was facing a problem with my keyboard when I used this ' symbol (because my keyboard is in Portuguese not in US International). So the best approach to not change the default language of your keyboard is use this format:
?filter=_x0030__x0035__x002E__x0020_Country%2FCountry_x0020__x0023_%20eq%20%27Denmark%27
When I use that format, it is working well in my side.
Kind regards,
Bruno Franco.
Kind regards,
Bruno Franco.
Hi, Anonymous
Great, I'm glad your problem has been solved. Thank you for your sharing .
I think you can accept your reply as a solution, which will help more community members.
Best Regards,
Community Support Team _ Eason