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 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi v-easonf-msft.

       

      Yes I already tried all the combinations, and I already created a ticket and I already spoke with one of the support members, and we tried all the combinations and probably it is a bug, because we tried a example that you have in microsoft documentation for example with @ (x0040) and it is not working too, when you use special character is not working. So I need to wait for their feedback. When I know I'll put the feedback in here. 

       

      Thanks and kind regards.