Skip to Content
avatar image
Former Member

URL Encoding in Dashboard passing "&" as part of of a value for Query String

I'm working on a summary report in Dashboard version 6.0.5.0, and have URL button that links to detail report in Webi. One of the parameter value we are passing contains "&".

The issue I have is that when we click on the URL link, the passed value gets truncated at the "&" sign in Webi.

As an example, the if value was "Bob&Mary", in the webi prompt, we only see "Bob". URL will show up

/....../BOE/OpenDocument/opendoc/openDocument.jsp?xxx....&lsMpmPrompt1%3A=Bob&Mary...

If I manually change the value from "Bob&Mary" to  "Bob%26Mary”, the  URL encoder changes it to %2226 as per ASCII Encoding Reference (% value is %25).

So my question is that why doesn't the encoder change & to %26 on its own?


Note, I've tested enabling/disabling  "Encode URL" option in the URL button property.


Encode URL For a URL Button, select this checkbox to encode special characters in the URL.

This option ensures that there are no invalid characters.




Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 14, 2015 at 08:43 PM

    Hi Wes,

    "&" is a reserved keyword. Make use of the Ascii character instead and you should be able to pass the values.

    Hope this helps.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2016 at 09:38 AM

    Hi Amit & Wes Desta!

    We have a similar problem, can you share few more details on how you resolved the issue please?

    my scenario:

    we have "/" in between customer name.

    eg:-   A/S.bobmary

    early revert highly appreciable..

    Thanks

    Rajeesh

    Add comment
    10|10000 characters needed characters exceeded