Need to Filter Report on Multi Select Field via URL

Need to Filter Report on Multi Select Field via URL

Hello all,

I am trying to filter and embed a HTML Creator report in a Page and filter based on the selections in a multi select picklist. Here is what I am trying to accomplish but I cannot seem to get the syntax right for the "OR" portion of the URL.


I tried the above and neither "OR" or "||" work inbetween the two City parameters. Any help is appreciated.

  2. companyName = "";
  3. countyName = "";
  4. cityName = "";
  5. if(input.Company1 != null)
  6. {
  7. companyName = "Company1=" + Company[ID == input.Company1].Company_Name;
  8. }
  9. if(input.County != "")
  10. {
  11. countyName = "&&County=" + input.County;
  12. }
  13. if(input.City != "")
  14. {
  15. cityName = "&&City=" + input.City;
  16. }
  17. //companyName = Company[ID == input.Company1].Company_Name;
  18. NewSearchResultPublishUrl = zoho.appuri + "view-embed/All_Projects?";
  19. openUrl(NewSearchResultPublishUrl + companyName + countyName + cityName,"iframe","frame12");