Creating a Card Deep Link Beast Mode - Multiple Filters

swagner
swagner Contributor
in Charting

Have been searching the Dojo and KB this morning for info on this and I'm not finding the solution. Also, not seeing documentation on Card Deep Links (do see for pages) - is this still supported?

I have a card that shows inventory information and users are asking for a way to "see" who is buying the inventory most often. I have another card that shows this information and can be filtered to the branch and item to see which customers are buying.

I'd like to create a Deep Link to this card with the branch and item filters from the inventory card.

I can get the Deep Link to work for one or the other filter by using this format:

CONCAT('<ahref=''https://customer.domo.com/page/#########/kpis/details/##########?pfilters=','{"column":"branch","dataSourceId":"DatasetID","dataType":"string","operand":"Operand Type","values":["',`branch`,'"]}]','''target="_blank" title="Deep Link">','Link Display Name','</a>')

I've tried the beast mode below to add the item filter but when I click the link the card opens with no filters applied:

CONCAT('<ahref=''https://customer.domo.com/page/#########/kpis/details/##########?pfilters=','{"column":"branch","dataSourceId":"DatasetID","dataType":"string","operand":"Operand Type","values":["',`branch`,'"]}]',

,'{"column":"item","dataSourceId":"DatasetID","dataType":"string","operand":"Operand Type","values":["',`item`,'"]}]','''target="_blank" title="Deep Link">','Link Display Name','</a>')

Any help would be appreciated.

Thanks!

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @swagner are you able to make the filter work with JUST the item filter? make sure that works first. THEN try creating an array where you pass

    pfilters=[{branch dictionary}, {item dictionary}]


    notice pfilters is an array (square brackets) not a dictionary.

    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"
  • GrantSmith
    GrantSmith Coach

    Hi @swagner

    I've taken a stab at it to help simplify the code a bit and make sure your spaces are correct and closing brackets are aligned.

    CONCAT('<a href=''https://customer.domo.com/page/#########/kpis/details/##########?pfilters=[{"column":"branch","dataSourceId":"DatasetID","dataType":"string","operand":"Operand Type","values":["',`branch`,'"]},{"column":"item","dataSourceId":"DatasetID","dataType":"string","operand":"Operand Type","values":["',`item`,'"]}]''' target="_blank" title="Deep Link">','Link Display Name','</a>')
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories