I have a Question written in SQL with two filter fields. DATETIME and EMAIL
The query is a relatively simple and is something like this:
select
10 different fields
from messages
JOIN
5 different tables
where {{EMAIL}
and {{DATETIME}}
and messages.type_id IN (9,43)
order by messages.id DESC
LIMIT 10000
On a dashboard with the filters connected I can select an EMAIL and DATETIME and get results, but if I "Explore results" I get the error shown above.
Is this a bug? The filters appear to be in the URL. Is there any way I can sort or filter the results from this query? I was expecting the Explore results to allow this, but it doesn't work.