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/08/16 18:26:26 UTC

[GitHub] [superset] junlincc opened a new issue #16277: [Explore] wrap %s around selected value to implicitly indicate LIKE clause

junlincc opened a new issue #16277:
URL: https://github.com/apache/superset/issues/16277


   As a Superset user, when I use the LIKE filter, it would be helpful the ad hoc filter can automatically apply % % on each end of the value input to implicitly indicate the LIKE clause. 
   
   Cursor can be placed in between %%, please make sure the query is not being affected after adding them. 
   <img width="347" alt="Screen Shot 2021-08-16 at 11 16 25 AM" src="https://user-images.githubusercontent.com/67837651/129611774-982d3283-cc6d-4106-a5b6-b1d8e98f5590.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


[GitHub] [superset] zhaoyongjie edited a comment on issue #16277: [Explore] wrap %s around selected value to implicitly indicate LIKE clause

Posted by GitBox <gi...@apache.org>.
zhaoyongjie edited a comment on issue #16277:
URL: https://github.com/apache/superset/issues/16277#issuecomment-899971706


   Currently, `like` or `ilike` operator in filter, there are some flaws. 
   
   The query does not contain `%` in where clause. For this query, it is basically equivalent to `=` operator.
   ![image](https://user-images.githubusercontent.com/2016594/129660277-992a22bb-f329-47a4-a53f-da7628e2b744.png)
   
   In addition to show `%` in the UI, I suggest putting `%` in the query.
   
   
   


-- 
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] junlincc commented on issue #16277: [Explore] wrap %s around selected value to implicitly indicate LIKE clause

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #16277:
URL: https://github.com/apache/superset/issues/16277#issuecomment-900357924


   > In addition to show `%` in the UI, I suggest putting `%` in the query.
   
   definitely!


-- 
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 #16277: [Explore] wrap %s around selected value to implicitly indicate LIKE clause

Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #16277:
URL: https://github.com/apache/superset/issues/16277#issuecomment-899971706


   Currently, `like` or `ilike` operator in filter, I think there are some flaws. 
   
   The query does not contain `%` in where clause. For this query, it is basically equivalent to `=` operator.
   ![image](https://user-images.githubusercontent.com/2016594/129660277-992a22bb-f329-47a4-a53f-da7628e2b744.png)
   
   In addition to show `%` in the UI, I suggest putting `%` in the query.
   
   
   


-- 
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] junlincc commented on issue #16277: [Explore] wrap %s around selected value to implicitly indicate LIKE clause

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #16277:
URL: https://github.com/apache/superset/issues/16277#issuecomment-902347913


   @zhaoyongjie to eliminate confusion to business users, let's only add %% to the query, and not do anything on UI.  


-- 
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