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]

Reply via email to