Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

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 _ Eason

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks 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.