Start a new topic
Answered

Searching for part of the word without using Business Logic

Hello!


Is there a way to make a filter on a column searching for part of the word without using Business Logic? Something like SQL Server queries.

Example: Select from kinveycollection1 Where columnartist LIKE "Elvis%".

Then got the following results: "Elvis Costello"

"Elvis Presley"

I wonder if exists something like:

"/appdata/kid_ads1fdf2lEx/classic-rock/?query={"artist" : "Elvis%"}"


Best Regards,


Marco


Best Answer

Marco,


The query above would work as you intend it to, but we do not support case insensitive or full string search.  All regex must be anchored to the start of the string in question.  Thus if your field was:


"Elvis Costello"


You could search for:


"Elvis"


But not:


"elvis" or "cos"  as those would be filtered on our end.


Thanks,


Thank you very much!

Answer

Marco,


The query above would work as you intend it to, but we do not support case insensitive or full string search.  All regex must be anchored to the start of the string in question.  Thus if your field was:


"Elvis Costello"


You could search for:


"Elvis"


But not:


"elvis" or "cos"  as those would be filtered on our end.


Thanks,


1 person likes this
Login or Signup to post a comment