Extending filter to work with parts of the string

[sebastiangaertner]

When filtering planter names first name or last name it would be great to

1. not be case sensitive
2. find anything with that string contained (eg. LIKE '%seba%' )

in order to find Names easier

[gwynndp]

Similar to: #151

[Mloweedgar]

@gwynndp would like to work on this. I will dive into the code-base to see what I can do, in case of questions I will reach out to you

[Mloweedgar]

@sebastiangaertner can you assign this one to me?

[gwynndp]

The api is built with Loopback, and I think we're on version 2: https://loopback.io/doc/en/lb2/Where-filter.html#regular-expressions

…

On Wed, Sep 22, 2021 at 1:16 PM Edgar Vitus Mlowe ***@***.***> wrote: @gwynndp <https://github.com/gwynndp> do we have api documentation that describes how to filter/search using regex. to fix the above issue, I have discovered that we can use regular expressions in constructing the filters(the where object) I have attempted the following approaches in using regex in the firstName field with no success: 1. { firstName: {"$regex": '/.*Assa.*/'}} 2. {firstName: '/.*Assa.*/'} Do you have any idea on this? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#162 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AANOAXVTMXT3GVJ4LYMCXSLUDI2TPANCNFSM5ELIUO3A> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[dadiorchen]

@sebastiangaertner does '%like%' require some setting up for the full-text search index on PostgreSQL

[nmcharlton]

@gwynndp @Mloweedgar For info, we're on version 4 of LoopBack