You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/09/26 09:56:57 UTC
[GitHub] [incubator-superset] lilila opened a new issue #11078: Problem with assert referenced columns are present in datasource
lilila opened a new issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078
@villebro , I have an issue with #10451
It breaks the following type of jinja-based filters:
```
{% set min_tracking = filter_values('min_sem_tracking', -9 )[0] %}
{% set max_tracking = filter_values('max_sem_tracking', 2 )[0] %}
SELECT
...
WHERE
sem_tracking > {min_tracking} AND sem_tracking < {max_tracking}
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #11078: Problem with assert referenced columns are present in datasource
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078#issuecomment-701207826
I was able to reproduce, thanks @lilila and @bkyryliuk for helping track this down. Working on a fix now.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #11078: Problem with assert referenced columns are present in datasource
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078#issuecomment-699688623
Thanks for posting this issue @lilila . Can you post some more details on how to reproduce the error?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] lilila commented on issue #11078: Problem with assert referenced columns are present in datasource
Posted by GitBox <gi...@apache.org>.
lilila commented on issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078#issuecomment-699765989
Hi Villebro,
If I want to add a min / max filter on a field (since the filter box does not allow this) I usually create a SQL Lab view as follows :
`SELECT
-5 as min_sem_tracking,
1 as max_sem_tracking
`
Then I create a filter box with the 2 fields created in this "fake" table :
<img width="1089" alt="Screenshot 2020-09-28 at 06 35 50" src="https://user-images.githubusercontent.com/607430/94391078-dbb6c100-0154-11eb-9ad5-7b17202a4bc8.png">
After adding the filter box in the dashboard I use the user input value for min and max value to create more "complex" filters on another table. As explain above I collect user inputs using `filter_values`
```
{% set min_tracking = filter_values('min_sem_tracking', -9 )[0] %}
{% set max_tracking = filter_values('max_sem_tracking', 2 )[0] %}
```
Then I use the collected values to create filters on another field in another table :
```
SELECT * FROM my_table
WHERE
sem_tracking > {min_tracking} AND sem_tracking < {max_tracking}
```
With the new restriction, I receive an error message saying `min_sem_tracking` and `max_sem_tracking` are not in the datasource.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar closed issue #11078: Problem with assert referenced columns are present in datasource
Posted by GitBox <gi...@apache.org>.
dpgaspar closed issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #11078: Problem with assert referenced columns are present in datasource
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #11078:
URL: https://github.com/apache/incubator-superset/issues/11078#issuecomment-699472807
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.96. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org