How to apply URL filtering with data that has special characters?

When working with URLs, it is essential to handle special characters correctly. Special characters, such as commas (,) and ampersands (&) within the data will be treated differently if its not escaped properly. Follow the below steps to avoid these issues

How to Escape Special Characters

To escape special characters in a URL, you can use the tilde (~) symbol. This symbol is used to differentiate special characters in the URL.

Example

Consider the following URL:

http://localhost:62754/bi/site/site2/dashboards/bf9ca592-6f33-4e35-8c8c-b980c703b80a/kumar/test?showmydashboards=1&CompanyName=Syncfusion&co

In this URL, the value Syncfusion&co contains a special character, the ampersand (&). To escape this character, you can use the tilde (~) symbol:

http://localhost:62754/bi/site/site2/dashboards/bf9ca592-6f33-4e35-8c8c-b980c703b80a/kumar/test?showmydashboards=1&CompanyName=Syncfusion~&~co

Now, the URL correctly differentiates the special character as data instead of treating it as an operator and will filter the dashboard to show the data of the Company Syncfusion&co
Also, you can check Escape Special Characters in the linking configuration. This setting will escape the special characters in the data before appending to the URL while navigating to the URL.