Where filter, case insensitive search

[Nicole Chung]

Is there a way to use the "where" filter so that the search is case-insensitive?

I can make my query lowercase, but really what I want to do is be able to search for say, "USA", "usa", "Usa"... so all versions will show up in my search results.

Post.find(
{ where: {title: { like: ''.*'+query.toLowerCase()+'.*''} } }, 
  function (err, posts) { ... }
);

[Raymond Feng]

What databases do you want to have this support? We’re considering to add an regexp operator.

Thanks,

---

Raymond Feng

Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

--
You received this message because you are subscribed to the Google Groups "LoopbackJS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loopbackjs+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Nicole Chung]

MongoDB for now. Thanks!

[Raymond Feng]

On the node side, the like operator can take a RegExp object for mongodb. Please give a try.

Thanks,

---

Raymond Feng

Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

[Nicole Chung]

This works, thanks.

var pattern = new RegExp('.*'+query+'.*', "i"); /* case-insensitive RegExp search */ 

Post.find(

{ where: {title: { like: pattern} } }, 

  function (err, posts) { ... }

);

[Partap Davis]

Is there a way to do this from REST?

I've got something like this (using angular):

filter.include = ['author']

if (scope.search) {

  filter.where = {

   'or': [

     {title:          {like : scope.search}}

     {'author.name':  {like : scope.search}}

     {descr:          {like : scope.search}}

   ]  

  }

}
Video.find({filter:filter})

The 'author.name' bit doesn't work either, but that's a different issue...

It would be nice if I could pass literal regex in... or maybe use an operator (regex or just re)

{title: {like: re: {'/' + scope.search + '/i'}}

But that would probably have to be built into the core of loopback...

Is there a way I could implement something like this by intercepting the REST call with a hook?  I'm still a little fuzzy on what you can do with hooks...

Maybe just rewrite any "like" query to use a case-insensitive regex?

[Raymond Feng]

You can plug in a beforeRemote hook to transform the filter object.

Thanks,

---

Raymond Feng

Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

[Partap Davis]

On Monday, August 25, 2014 5:08:54 PM UTC-6, Raymond Feng wrote:

You can plug in a beforeRemote hook to transform the filter object.

Thanks!

I've got a hook set up now...I'm trying to figure out where to find the parsed filter object that I need to transform.

The closest I've come so far is ctx.args, which has parsed the URL params into the object:

{

  filter: "json string here..."

}

But since I need to convert the "like" clauses from strings to regexp objects, the json string doesn't help me.

There doesn't seem to be much documentation for the ctx object...

[Raymond Feng]

Is the filter still a json string? I thought it’s already a json object. Ritchie, can you confirm?

Thanks,

---

Raymond Feng

Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

[Partap Davis]

Yeah, it's a string.  

I tried parsing it and sticking it back into ctx.args, but no luck...it needs to be a string.

Probably a simple fix to skip the parse step later down the line, but I don't know where to look...

[Leo B]

A solution at https://github.com/strongloop/loopback-connector-mongodb/pull/109 .