Problem Note 66325: URL parameters that are based on values that contain a comma are not passed correctly in SAS® Visual Analytics
In SAS Visual Analytics, URL parameters that are based on values that contain a comma are not passed correctly.
For example, you encounter the issue if you perform steps similar to the following.
- Create a parameter called COMMA based on a data item that contains a comma. For example: CATEGORY1=”AB, CD”.
- Create a new report with a drop-down list as a report control and a list table and add CATEGORY1 to both objects.
- Add the COMMA parameter in the drop-down list, and then the drop-down list filters the list table correctly when you select values.
- Create a URL parameter by using the Copy Link option, clicking Add Parameter, and adding COMMA = AB, CD:
A URL similar to the following one is generated:
http://host/SASVisualAnalytics/?reportUri=%2Freports%2Freports%2F8b46528b-c9a7-4ecf-9c18-b21dc551b612§ionIndex=0&sas-welcome=false&pr29=AB%2C%20CD
The URL is correct. %2C refers to a comma and %20 refers to a space in the URL.
- However, when you use the URL to display the report in SAS Visual Analytics, the parameter is not applied to report objects. The following image shows that the drop-down list does not contain the parameter in the URL. It should contain “AB, DC” instead of the name of the category data item.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Visual Analytics | Cloud Foundry | 8.5 | 2020.1 | Viya | |
Linux for x64 | 8.5 | 2020.1 | Viya | |
Microsoft® Windows® for x64 | 8.5 | 2020.1 | Viya | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-08-13 08:01:05 |
Date Created: | 2020-07-15 04:47:25 |