How can I query WHERE "NOT NULL" AND "NOT EQUAL TO [STRING]" Using Sequelize?

Question

I need to get data where property "type1", "type2", etc., etc., is "not equal to 'null'" AND "not equal to the string 'no_issue'". I've tried a few different ways with no luck and this is what I currently have that is not working:

  [Op.and]: [
        { type1: { [Op.not]: null }},
        { type1: { [Op.ne]: 'no_issue' }},
        { next_item: 'next' }
     ],
     [Op.and]: [
      { type2: { [Op.not]: null }},
      { type2: { [Op.ne]: 'no_issue' }},
      { next_item: 'next' }
   ],
      [Op.and]: [
        { type3: { [Op.not]: null }},
        { type3: { [Op.ne]: 'no_issue' }},
        { next_item: 'next' }
    ],
    [Op.and]: [
      { type4: { [Op.not]: null }},
      { type4: { [Op.ne]: 'no_issue' }},
      { next_item: 'next' }
    ],
    [Op.and]: [
      { type5: { [Op.not]: null }},
      { type5: { [Op.ne]: 'no_issue' }},
      { next_item: 'next' }
    ]
    }

This looks to be correct but I'm obviously missing something. Thanks in advance!

Martial · Accepted Answer · 2021-06-09 19:15:05Z

4

Op.and should be an array of objects

      [Op.and]: [
         { type1: { [Op.not]: null }},
         { type1: { [Op.ne]: 'no_issue' }}
      ],...

answered Jun 9, 2021 at 19:15

Martial

1,58215 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

wdc_dt Over a year ago

Thanks! I tried this but it didn't work. I've updated the code above so you can see the full block I'm trying to implement.

wdc_dt Over a year ago

It works (as it did before) if the items are not null so I was wondering if I need to do something like a "if not null, then check if type1 is not equal to 'no_issue'

Collectives™ on Stack Overflow

How can I query WHERE "NOT NULL" AND "NOT EQUAL TO [STRING]" Using Sequelize?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related