Hello Experts,
I have an Interactive Report with a link-column that opens a dialog window. The dialog gets several parameters from the report - one being numeric in particular.
The problem I'm facing is that this number is formatted, so the number becomes a text with commas inside (thousands separator). When the URL is constructed by the "Link Builder - Target", these commas interfere with the item names and values being passed to the dialog.
Example:
I have columns in the report: GEO_ID = "DE024", Status_ID="L" and Quantity =760364 formatted as "760,364.000".
When building a link in "Link Builder - Target" I tried assigning #QUANTITY# to P24_QUANTITY. The link being built is:
javascript:apex.navigation.dialog('f?p=101:24:1199867329849::YES:RP:P24_CONSUME_GEO_ID,P24_STATUS_1,P24_QUANTITY:DE024,L,760,364.000\u0026...
instead of:
javascript:apex.navigation.dialog('f?p=101:24:1199867329849::YES:RP:P24_CONSUME_GEO_ID,P24_STATUS_1,P24_QUANTITY:DE024,L,760364\u0026...
(notice "760,364.000" instead of "760364").
I tried escaping filers in the substitution value by appending an exclamation mark (!) followed by a predefined filter name (HTML, ATTR, JS, RAW, STRIPHTML) when assigning to P24_QUANTITY (e.g. #QUANTITY!RAW#) - none worked.
I ended up with cloning the QUANTITY column and hiding the clone from users to avoid formatting, just for sake of passing its unformatted value to the dialog window.
Is this the only workaround?
I was thinking about manually creating the URL but it sounds repelling...
Maybe there's some smarter way of getting the unformatted report's column value to the dialog?