I have a chart which pulls data from an SQL query. I have the chart set to redirect to a "link" when a value is selected. It is set to redirect to it's same page, but also set the value of an item before redirecting. The value for the item I am trying to set, is set as "&DEFECT." which references one of the selected values from the query. It works on all of my different data points, but as soon as one contains a comma, it will only send part of the value of DEFECT until it reaches the comma, and will not send anything else. I have tested and verified this many times with using the "Session State" tool. Is there any way to send a value ignoring the commas using this same "Set Items" function? I've included screenshots below to help explain:
This is my "Link Builder"...
DEFECTS is the parameter that I want to send, so I type it as &DEFECTS. in order to send the value
This is what the chart looks like. It redirects to the link and sends the corresponding values based off of which horizontal column you choose.
For this example, I chose the one with the DEFECT value of "spindle drive-function nok" (notice how it does not consist of any commas)...
Here is a screenshot of the Session-State after clicking on the column.
As you can see, the item value is set to the exact same DEFECT value: "spindle drive-function nok".
This is how the link is expected to work.
This is a screenshot of the same chart, but this time, I will click on a value that contains a comma.
For this example, I click: "Side panel, tail lamp, complete-touching" (notice the location of the comma).
Now, when I run a session state after selecting THAT column, the item value sent is: "Side panel".
As you can see, it cuts off the rest of the value directly before it reads a comma.
I have also noticed that the second value after the first comma ("tail lamp"), is populated into the second field (the switch in the below screenshot). This should be populating with "On" if you look at my "Link Builder" above.
I believe the Link Builder is reading in the comma as code to move to the next available item in the "Set Items" tab.
To me, this seems like it is behaving unexpectedly and I'm not sure what to do. Any help would be appreciated!
Thank you,
- Zach