Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add "not like" to the predefined filters #672

Closed
D-nov opened this issue Sep 18, 2023 · 3 comments
Closed

Add "not like" to the predefined filters #672

D-nov opened this issue Sep 18, 2023 · 3 comments
Assignees
Labels
enhancement 🚀 New feature or request

Comments

@D-nov
Copy link

D-nov commented Sep 18, 2023

Describe the solution you'd like
In the existing dropdown of filter options for the table add the option "not like".
so we can execute " select * from pandas where panda not like '%awesome panda%' ".

Additional context
Add any other context or screenshots about the feature request here.

@Fabio286 Fabio286 added the enhancement 🚀 New feature or request label Sep 18, 2023
@64knl
Copy link
Contributor

64knl commented Sep 18, 2023

It would be nice to also have a "contains" option that is short for "LIKE '%term%'.

@Fabio286 Fabio286 added the good first issue Good for newcomers label Sep 18, 2023
@Fabio286 Fabio286 moved this to 📌 To do in Work in Progress Board Sep 19, 2023
@D-nov
Copy link
Author

D-nov commented Sep 20, 2023

@64knl I think this how the current like filter works, does it not ?
But i think it would be good to manually add the condition.
e.g. %term instead of always having %term%

@Fabio286
Copy link
Member

@64knl I think this how the current like filter works, does it not ?

Exactly, the application does:

case 'LIKE':
   value = `${sw}%${filter.value}%${sw}`;
   break;

@Fabio286 Fabio286 moved this from 📌 To do to ✔ Done in Work in Progress Board Sep 25, 2023
@Fabio286 Fabio286 removed the good first issue Good for newcomers label Sep 25, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement 🚀 New feature or request
Projects
Status: Done
Development

No branches or pull requests

3 participants