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 2022/01/24 06:22:14 UTC
[GitHub] [superset] zhaoyongjie opened a new issue #18147: [explore] I can't select `NULL` and `empty string` in filter
zhaoyongjie opened a new issue #18147:
URL: https://github.com/apache/superset/issues/18147
I can't select `NULL` and `empty string` in Filter
#### How to reproduce the bug
1. First of all, let we create a virtual dataset from SQLLab and open this in Explore page.
```
SELECT '' as name
UNION ALL
SELECT null as name
```
2. I can't get `NULL` and `empty string` in filter.
<img width="924" alt="image" src="https://user-images.githubusercontent.com/2016594/150731794-ccd0749a-a598-4a43-bb2e-ca2a42685db5.png">
3. I can manually input `<NULL>` and `<empty string>` to filter that.
<img width="1399" alt="image" src="https://user-images.githubusercontent.com/2016594/150732033-ea7975a8-4242-4c66-9f46-df1db69a089e.png">
### Expected results
I can select `<NULL>` and `<empty string>` in filter
### Environment
(please complete the following information):
- browser type and version:
- superset version: `superset version`
- python version: `python --version`
- node.js version: `node -v`
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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: notifications-unsubscribe@superset.apache.org
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] [superset] zhaoyongjie closed issue #18147: [explore] Filter unable to select `NULL` and `empty string`
Posted by GitBox <gi...@apache.org>.
zhaoyongjie closed issue #18147:
URL: https://github.com/apache/superset/issues/18147
--
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: notifications-unsubscribe@superset.apache.org
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] [superset] jinghua-qa commented on issue #18147: [explore] Filter unable to select `NULL` and `empty string`
Posted by GitBox <gi...@apache.org>.
jinghua-qa commented on issue #18147:
URL: https://github.com/apache/superset/issues/18147#issuecomment-1022432557
>
ok, i open this issue here https://github.com/apache/superset/issues/18178
--
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: notifications-unsubscribe@superset.apache.org
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] [superset] zhaoyongjie commented on issue #18147: [explore] Filter unable to select `NULL` and `empty string`
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #18147:
URL: https://github.com/apache/superset/issues/18147#issuecomment-1021807860
> I have tried using example dataset covid_vaccines, for the column with "null" value only, i did not see selection for IN filter, keep loading forever <img alt="Screen Shot 2022-01-24 at 8 32 24 PM" width="1790" src="https://user-images.githubusercontent.com/81597121/151092464-174f97ad-1dfd-4855-837f-052a69cc0007.png">
Thanks for you figure it out, but I think your finding is different with this issue. Feel free to open a new issue + ticket for can't load values in a filter.
--
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: notifications-unsubscribe@superset.apache.org
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] [superset] jinghua-qa commented on issue #18147: [explore] Filter unable to select `NULL` and `empty string`
Posted by GitBox <gi...@apache.org>.
jinghua-qa commented on issue #18147:
URL: https://github.com/apache/superset/issues/18147#issuecomment-1021795630
I have tried using example dataset covid_vaccines, for the column with "null" value only, i did not see selection for IN filter, keep loading forever
<img width="1790" alt="Screen Shot 2022-01-24 at 8 32 24 PM" src="https://user-images.githubusercontent.com/81597121/151092464-174f97ad-1dfd-4855-837f-052a69cc0007.png">
--
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: notifications-unsubscribe@superset.apache.org
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