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

Introduce _like filter #112

Open
IanMayo opened this issue Jul 19, 2023 · 1 comment
Open

Introduce _like filter #112

IanMayo opened this issue Jul 19, 2023 · 1 comment

Comments

@IanMayo
Copy link
Collaborator

IanMayo commented Jul 19, 2023

Is your feature request related to a problem? Please describe.
No.

The original implementation of _filter was ambiguous. The spec reported that it did an equals match, but the code (and jsdoc) performed a like "%q%" match.

A previous PR (#102) resolved the issue, switching _filter to use equals. But @thevahidal recommended introducing an issue to restore the capability of text-based wildcard searches.

Describe the solution you'd like
Introduce a new _like filter that performs a ILIKE match (case independent wildcard search), to allow wildcard text-based searches.

The url will look like:

/api/tables/customers/rows?_like=FirstName:Franc

Note: the param should accept multiple specified matches, like the _filters query param does.

Describe alternatives you've considered
Did not identify any.

@thevahidal
Copy link
Owner

thevahidal commented Jul 20, 2023

As we talked earlier it's a good-to-have feature for Soul, and we can add it to our queue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants