SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66325: URL parameters that are based on values that contain a comma are not passed correctly in SAS® Visual Analytics

DetailsHotfixAboutRate It

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.

  1. Create a parameter called COMMA based on a data item that contains a comma. For example: CATEGORY1=”AB, CD”.
  2. Create a new report with a drop-down list as a report control and a list table and add CATEGORY1 to both objects.
  3. Add the COMMA parameter in the drop-down list, and then the drop-down list filters the list table correctly when you select values.
  4. Create a URL parameter by using the Copy Link option, clicking Add Parameter, and adding COMMA = AB, CD:

copy link dialog box

A URL similar to the following one is generated:

http://host/SASVisualAnalytics/?reportUri=%2Freports%2Freports%2F8b46528b-c9a7-4ecf-9c18-b21dc551b612&sectionIndex=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.

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

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual AnalyticsCloud Foundry8.52020.1Viya
Linux for x648.52020.1Viya
Microsoft® Windows® for x648.52020.1Viya
* 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.