Deep Linking with Filters -- Special Characters?

Ritwik
Ritwik Contributor

I have a beast mode that I am using to pass along page filters as a hyperlink. It looks like deep linking does not properly work with special characters like a "+" sign.


Beast Mode:

case when `Designation` != 'Subject' then 

CONCAT('<a href=''https://woodpartners.domo.com/page/2101023617?pfilters=['

,'{"column":"Name and Comp For","dataType":"string","operand":"IN","values":["'

,CONCAT(`Name`, ' ', `Comp For`)

,'"]}'

,']'' target="_blank" title="Open in Domo">',`Name`,'</a>'    

   )

    else `Name` end


Example:

Field value is: 'L+O The Weddington'

The Filter that shows up on the linked page is: 'L O The Weddington'


The cards on the linked page are then invalid/"no data in filtered range".


Question:

Is there a workaround or some trick possible within the beast mode that could help recognize these special characters? Perhaps add some conditions where the field contains a '+', and rename it accordingly? Is there anything a bit simpler/more elegant?


Appreciate any insights and help, thank you!

Answers

  • you are constructing a URL.

    I'm not sure this is the solution, but you know how spaces in URLs get converted into %20. I imagine + is a reserved character, so you have to find the equivalent for the symobl. Or google 'escape character url' i don't know if that's a thing.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • You'll need to URL encode your special characters. There's several websites which can do this for you if you're not certain how to do this on your own. Try this: https://url-decode.com

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**