Multiple filters in Deep Linking with Filters

Hoping there is a syntax error here a fresh set of eyes can find.  Deep linking with filters from one story dashboard to another.

Using one column works perfectly.

adding a 2nd isn't working - error "a problem has occured while loading page filters. if the problem persists contact domo support" (which I did, but unsure if it's truely a domo problem, or a code error)

 

Following the documentation with %22, or using " code as has been recomended in other dojo posts has the same result.

 

THIS (WITH 2 FILTER COLUMNS) DOES NOT WORK

CONCAT('<a href="https://thebluebook.domo.com/page/xxxxxx'

,'?pfilters=[{%22column%22:%22Public/Private%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`Public/Private`

,'%22]}]'

,'?pfilters=[{%22column%22:%22State (Proj)%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`State (Proj)`

,'%22]}]" target=%22_blank%22>'

,'state, pub/pri'

,'</a>'

)

 

this WORKS:

CONCAT('<a href="https://thebluebook.domo.com/page/xxxxxx'

,'?pfilters=[{%22column%22:%22State (Proj)%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`State (Proj)`

,'%22]}]" target=%22_blank%22>'

,'state test'

,'</a>'

)

 

(Used this documentation https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Miscellaneous_Transforms)

Tagged:
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!