Knex JS "OR" Inside .where()?

Question

Does anyone have any ideea how to write an OR logic like the ' || ' operator in JS I tried inside my knex to do it like that ->

knex('something')
  .where({ state: BOOKING_STATE.ACCEPTED } || { state: BOOKING_STATE.WAITING_LIST})

however it fails and i can't find anything about it in the docs

Answer 1

If you check the documentation for where clauses with Knex, you'll see a grouped chain where, if you're trying to have multiple where clauses, but only want to or the two you listed, then something like this would work.

knex('something')
.where(function() {
  this.where('state', BOOKING_STATE.ACCEPTED ).orWhere('state', BOOKING_STATE.WAITING_LIST)
})
.andWhere('something', something_else)
...;

Answer 2

You should be able to use a combination of where() and orWhere():

knex('something')
  .where({ state: BOOKING_STATE.ACCEPTED })
  .orWhere({state: BOOKING_STATE.WAITING_LIST })

Answer 3

As you can see on the Knex.js Documentation, it has functions for where, andWhere and orWhere. So you can easily chain your WHERE queries by calling

knex('something')
    .where({ state: BOOKING_STATE.ACCEPTED })
    .orWhere({ state: BOOKING_STATE.WAITING_LIST })

---

You can also use:

knex.select('some_field').from('some_table')
.where({ state: BOOKING_STATE.ACCEPTED })
.orWhere({ state: BOOKING_STATE.WAITING_LIST })