Filter functionality without selecting filter value


#1

When you select from another query which contains a filter and the second query doesn’t select the filter value, than the filter isn’t shown.

I have this Query:

SELECT “target_id”, “virtualdevice” AS “virtualdevice::multi-filter”
FROM “sensstats”.“viewers”, UNNEST(“values”) t(“vals”)
GROUP BY “target_id”, “virtualdevice”

And it works. Now the query I want is:

SELECT “target_id” FROM (
SELECT “target_id”, “virtualdevice” AS “virtualdevice::multi-filter”
FROM “sensstats”.“viewers”, UNNEST(“values”) t(“vals”)
GROUP BY “target_id”, “virtualdevice”)
GROUP BY “target_id”

But now in the redash gui the filter input field isn’t shown anymore.
Can you fix this?