Gwildor commented on issue #36676:
URL: https://github.com/apache/superset/issues/36676#issuecomment-3661377904
Interesting, I didn't know about the Autocomplete query predicate setting on
datasets. I've set it to `event_date_cet >= date_add(current_date(), interval
-3 month)` and the filter box works again, great! It produces this query now:
```sql
SELECT DISTINCT `readable_brand_name` AS `column_values`
FROM (SELECT * FROM `clicks`
) AS `virtual_table`
WHERE event_date_cet >= date_add(current_date(), interval -3 month)
LIMIT 10000
```
On the dashboards it doesn't use this predicate, which is good, because
there I prefer it to use the filter it is dependent on. If you don't have this
dependency, it still gives that network error, so it doesn't use the dataset
predicate.
I think I will close this, as I don't have a real bug anymore. The user
experience (and perhaps documentation, as I couldn't find this solution before)
could be better, but that's not vital.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]