in loopback nodejs how can I use OR AND condition in where clause right now I'm using this but it shows mi data from the table

Question

   {
      or: [
        { and: [{ cash: 'NEW' }] },
        {editGoalStatus: 'PROCESSING'},
        {editGoalStatus: 'NEW'},
          a]
    }

I want record like editGoalStatus should be PROCESSING or NEW and cash must be NEW

Give more details about your code; what are you trying to achieve ? What are you using to create the query ? — Madhur Bhaiya, Sep 05 '18 at 06:12
I'm trying to achieve fetch record from table where editGoalStatus is PROCESSING or NEW and cash column value must NEW only those record I want but right now it selects all record — Akshay, Sep 05 '18 at 06:18

score 0 · Answer 1 · answered Sep 05 '18 at 06:41

0

Taking a look at the documentation the filter should be something like

{
    and: [
        { cash: 'NEW' },
        {editGoalStatus: 'PROCESSING'},
        {editGoalStatus: 'NEW'}
    ]
}

So assuming that you wrote the

answered Sep 05 '18 at 06:41

Óscar Andreu

score 0 · Answer 2 · answered Sep 11 '18 at 09:13

0

I want record like editGoalStatus should be PROCESSING or NEW and cash must be NEW

{
    and: [
        { cash: 'NEW' },
        { editGoalStatus: { inq: ['PROCESSING', 'NEW'] } }
    ]
}

Hope this might be a hint.

Cheers!

answered Sep 11 '18 at 09:13

SuperStar518

2 Answers2