The use case in this example is aimed to provide a smooth transition between dashboard1 that contains a query results widget (regular table) when one of the results columns has values that link to dashboard2 that uses the value name as a filter.
Let's say you have a query that shows a metric for all the clients you're working with and you want to see an in-depth analysis dashboard for that specific client when you see their name in your query results (their metrics are higher/lower than expected or any other reason that feels right for you).
What you'll need for this to work is:
https://app.redash.io/yourcompany/dashboard/client-in-depth-info?client::filter=JJincIn order to get that URL string, enter this in your query: For a clickable full url:
SELECT 'https://app.redash.io/yourcompany/dashboard/client-in-depth-info?client::filter=' || client || ' AS client ...
For a clickable client's name: `SELECT ' || client || '' as client ...``
Enjoy your filtered dashboards links!