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 2021/01/07 21:12:52 UTC
[GitHub] [superset] junlincc removed a comment on issue #12293: [explore] When switching from Simple to Custom SQL for a filter, it translates INT to string
junlincc removed a comment on issue #12293:
URL: https://github.com/apache/superset/issues/12293#issuecomment-756387363
> There are few other issues(old or regression) around this area that we would like to address together. Tagging this issue `Hold!` and removing original assignee @michael-s-molina, thanks for all the investigation and testing!
>
> Problem 1
> Select a simple text filter like City
> Switch to Custom SQL and change the value
> It will present an error because the generated WHERE clause is invalid
> To fix the user has to enter the quotes and double quotes manually
> <img alt="Screen Shot 2021-01-07 at 4 08 31 PM" width="1789" src="https://user-images.githubusercontent.com/67837651/103944048-f4d1f500-50e7-11eb-9920-0c57d5393dcc.png">
> <img alt="Screen Shot 2021-01-07 at 4 09 17 PM" width="1784" src="https://user-images.githubusercontent.com/67837651/103944080-fbf90300-50e7-11eb-8528-6fde02cc6822.png">
> <img alt="Screen Shot 2021-01-07 at 4 10 18 PM" width="1778" src="https://user-images.githubusercontent.com/67837651/103944099-02877a80-50e8-11eb-9b5d-d3e1d35d6b42.png">
>
> Problem 2:
> Create a new Custom SQL filter like “City” = ‘Las Vegas’
> Switch to Simple and fill a different filter like Month = 10
> Switch back to Custom SQL and you will see that the value showing is “City” = ‘Las Vegas’ but if you select the text area the value will change to Month = 10
> <img alt="Screen Shot 2021-01-07 at 4 21 38 PM" width="1777" src="https://user-images.githubusercontent.com/67837651/103944165-18953b00-50e8-11eb-9845-0be484e9c8da.png">
> <img alt="Screen Shot 2021-01-07 at 4 22 30 PM" width="1775" src="https://user-images.githubusercontent.com/67837651/103944171-1af79500-50e8-11eb-9381-c276ef864945.png">
>
> Problem 3:
> Enable filter suggestions in dataset configuration
> Select a date as a filter
> All the suggestions are in a format not accepted by the database which will result in an error
> <img alt="Screen Shot 2021-01-07 at 4 05 37 PM" width="1779" src="https://user-images.githubusercontent.com/67837651/103943917-c3592980-50e7-11eb-85a2-4c0622826269.png">
>
> cc @villebro @kgabryje
> FYI @eugeniamz
----------------------------------------------------------------
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