Deep Linking with Filters -- Special Characters?

Ritwik
Ritwik Atlanta 🟡

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

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔵

    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.

  • GrantSmith
    GrantSmith Indiana 🔵

    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

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!