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
but when I tried for ex: ?filter=05._x0020_Country/Country eq 'Denmark' it is not working.
Can someone help me with this?
Kind regards.
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.
8 Replies
Hi, Anonymous
Have your tried to change the name of this table ?
In addition, I would suggest you to create a support ticket to let engineers look into the issue on your side.
Best Regards,
Community Support Team _ EasonHi v-easonf-msft unfortunately I can't change the name of table, because it is a company rule to have the name of the tables like that. I will check another options and try other ways.
Once again, thanks and kind regards.
Hi, Anonymous
If your problem is solved, please share the solution here, which will help more people who encounter similar problems.
By the way ,it seems that unicode of full stop ( . ) is 0x2E rather than 0020.
?filter=05_x002E_Country/Country eq 'Denmark'Best Regards,
Community Support Team _ Eason
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, 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
Hi , Anonymous
Special characters and spaces in table and column names require some additional formatting.
There may still be some kind of error in the format. It is best to standardize your original table name into a name that does not cause ambiguity.
For more details ,please refer to this document about how to Filter a report using query string parameters in the URL .
Best Regards,
Community Support Team _ EasonThanks for your reply v-easonf-msft
I've tried many options for example: ?filter=_x0030_x0035_x002e_x0020_Country/Country eq 'Denmark' , but I think it doesn't accept numbers (05) or ".", it may be that it only accepts text and only the special characters that exist in the microsoft documentation.
Kind regards.
