topic Re: Dashboard filter with multi-select: filtering on multiple possible tags in DQL

Dashboard filter with multi-select: filtering on multiple possible tags

aled — Fri, 28 Jun 2024 08:19:31 GMT

I have a variable definition working fine, that spits out possible values for a specific tag on my AWS SQS queues:

and this variable is configured as multi-select

I now want to filter for any entity matching one of the selected tags, but I'm not sure how to go about that

I've tried using `| filter tags in` to no avail

Re: Dashboard filter with multi-select: filtering on multiple possible tags

GerardJ — Fri, 28 Jun 2024 09:57:20 GMT

Hi @aled
That's what I use when I want to filter using multi-select variable, like this :

| filter in(tags, Array($variable))

Hope this helps

Re: Dashboard filter with multi-select: filtering on multiple possible tags

aled — Fri, 28 Jun 2024 10:03:14 GMT

Not sure how I missed that, works well, cheers!

Re: Dashboard filter with multi-select: filtering on multiple possible tags

Kenny_Gillette — Mon, 24 Mar 2025 16:08:23 GMT

Wonder if I could get some help.

Trying to filter on Tag too. I have a variable that works to pulls part of tag

I pull the name of the business owner team through a variable named BOT.

When I used above as variable in dashboard tile:

fetch dt.entity.host
| filter in(tags, Array($BOT))

I get nothing. any help?

Re: Dashboard filter with multi-select: filtering on multiple possible tags

Kenny_Gillette — Wed, 26 Mar 2025 12:42:11 GMT

@GerardJ any help you could provide please

Re: Dashboard filter with multi-select: filtering on multiple possible tags

GerardJ — Thu, 27 Mar 2025 14:25:29 GMT

Hi @Kenny_Gillette
The 'in' function perform an exact match, so assuming that your variable is a multiselect, I would have this logic :

fetch dt.entity.host | expand tags | filter matchesValue(tags, "[AWS]business-owner-team*") | parse tags, "ld:'[AWS]business-owner-team' ':' ld:TagValue" | filter in(TagValue, $BOT)

Re: Dashboard filter with multi-select: filtering on multiple possible tags

Kenny_Gillette — Thu, 27 Mar 2025 14:16:02 GMT

Thanks so much. Got this working now.