How to pass multiple values of document property to on demand info link
An urgent help needed!
I have assigned successfully multi selected values from regular list box to document property and trying to pass the same to on demand info link but the format is not correct when looked at SQl.log. See examples below for different input format i tried,
Format 1) Selected values A, B, C.
Input parameter format: A, B, C
Output parameter format: On demand info link: under where's clause file IN ('A,B,C').
Note: Observe, single quotes are assigned by Spotfire itself.
Format 2) Selected values A, B, C.
Input parameter format: A', 'B', 'C
Output parameter format:On demand info link: under where's clause file IN ('A'',''B'',''C').
Note: From format 1, i learnt, Spotfire is assigned start and end single quotes so assigned remaining but this time, Spotfire assigned extra single quote in the middle when find single quote (added by me).
I think, i explained my problem well. Could someone please provide a solution. Please suggest only document property related solutions.
I am experiencing the same problem and have not yet found a way to correct the double quotes in the middle. I was thinking maybe there was an escape character or something like that.