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:
![copy link dialog box](addl/fusion_66325_1_uno.png)
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.
![va report](addl/fusion_66325_2_due.png)
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 |