Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am passing Id's as pipe seperated params in URL and want to pass the params to salesforce reports e.g String param_ID_url = '701K00000002MtxIAE|701K00000002Mz9IAE';

when I try to pass to the button using Action global variable the url gets encoded and shows up as : 701K00000002MtxIAE%7C701K00000002Mz9IAE

Is there any way to stop this and let the | be as | symbol in the URL. I tried using substitute in the button code to substitute '%7c' with '|' still no lucj :(

Please guide me on how to make the | pass as pipe than encoding to %7c

button code:
&ReportId=00OK0000000FaWF?**pv0={!substitute(String param_ID_url,'%7c','|') }**
share|improve this question
I don't think you can change the URL encoding to use your pipe, as that's done on server side. Adjust your code on the other side to split the Id's based on the encoded delimiter (%7C) – Boris Bachovski Nov 16 '12 at 2:27
I am passing the ID to the report :( so i cannot seperate it :( – Rao Nov 16 '12 at 2:28
Are you sure you can pass multiple ID's in a single query? – Boris Bachovski Nov 16 '12 at 2:35
I think they need to be comma separated rather than pipe as per this example :… – Boris Bachovski Nov 16 '12 at 2:40
You can't pass pipes in a URL as it will be encoded before passing it through. For multiple params to a report , use ?pv0=value1&pv1=value2 – techtrekker Nov 16 '12 at 2:45

As shown on this tutorial:

your Id's should be comma separated as oppose to pipe.

share|improve this answer
comma seperated on pv0 params will break the reports as 2 reports and still will not pass the second id to the report. I teste this the only place where i am struck is the urlencode:( on pipe – Rao Nov 16 '12 at 2:46
Well I don't think you can do much there unfortunately – Boris Bachovski Nov 16 '12 at 2:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.