waterline query with multiple 'or' clauses

[Jerry Dalum]

I am trying to write a sails waterline query with two 'or' clauses where both have to be true, but it seems to not work. This is the query that I have tried but it pulls only when one of the 'or' clauses meets its criteria, which I am trying to return only when both 'or' clauses' criteria are met, not one. Is this a bug or is there another way to do this?

 Employee.find()

.where({

  or: [

    {locationId: employee.currentLocation.id},

    {facilityId: employee.facilityId, userName:employee.userName,accountOwner: true}

]})

.where({

  or:[

    {employeeId: { startsWith: params.search.value }},

    {fullName: { startsWith: params.search.value }},

    {street: { startsWith: params.search.value }},                              

    {emailAddress: { startsWith: params.search.value }},

    {employeeType: { startsWith: params.search.value }},

    {status: { startsWith: params.search.value }}

]});

    

[Ambroise Dhenain]

If you want two "or" clauses to be true, why not use an "and" close then?

--

Cordialement,

M. Ambroise Dhenain.

[Jerry Dalum]

can you point me to the documentation on how to use the and clause with waterline?

[Ambroise Dhenain]

I guess the "and" clause is the default one, take a look at this.

http://stackoverflow.com/questions/23120258/using-mix-of-and-and-or-clause-in-sails-and-waterline

I don't use waterline myself, so I cannot help you out myself. 

[Jerry Dalum]

yeah, i saw that one. that is why i put the two or clauses in their own 'where' clause as my example shows, but still no dice.

[Andrew Lewman]

did you find how to do that???

суббота, 7 февраля 2015 г., 1:42:13 UTC+3 пользователь Jerry Dalum написал: