How to use Search Modifier “OR” in Sails.js using Waterline Adapter for Mongo

[insidesmart]

The below code is written to fetch records containing "sometext" in either "name" or "description". This seems to be not working.

Can someone provide a correct way to implement "OR" searches

Side Note: "AND" function works. "OR" function is not working. sailsjs & sails-mongo version 0.94 is used.

Model.find({
     where: {
      or: [
       {name: {contains: req.param('sometext')}},
       {description: {contains: req.param('sometext')}}
      ]
     }, limit: 15, skip: 0, sort: 'name ASC'
    }, callback)

[particlebanana]

Looks like there is an issue with or queries not expanding criteria recursively. I can confirm this issue exists in both Mongo and Disk and isn't tested in the waterline-adapter-tests.

[insidesmart]

Thanks for the confirmation of the bug.

[vpegado]

This works with sails-disk 0.9.1 but not with sails-mongo 0.9.5

[alphacentory]

is there any updates on this bug fix? I can write this using multiple finds for now to mimic the functionality, just am wondering where the bug fix is, and maybe if I can contribute in any way.

[jonathanwiesel]

Any updates about this? It's has been 2 months...

[jakeopie]

Yeah, any updates?

[vpegado]

The real issue is located here: https://github.com/balderdashy/sails-mongo/issues/59

[vpegado]

I worked it out last night and submitted the solution here: balderdashy/sails-mongo#70

[polastre]

This nasty OR bug exists in https://github.com/balderdashy/sails-postgresql in the 0.9.x branch (0.9.7 release). It isn't expanding the nested OR statement.