Typeorm - multiple where statements

Question

I'd like to achieve something like this:

WHERE ( statement1 OR statement2 ) AND statement3

How can I achieve this with query builder?

I have tried this before:

Entity.createQueryBuilder()
  .where(statement1)
  .orWhere(statement2)
  .andWhere(statement3);

But it produces following query:

WHERE statement1 OR statement2 AND statement3

sp Kruten · Accepted Answer · 2022-09-06 19:03:27Z

4

I have figured it out myself, basically you should use Brackets from typeorm:

Entity.createQueryBuilder()
  .where(
    new Brackets((qb1) => {
      qb1.where(statement1).orWhere(statement2);
    })
  )
  .andWhere(statement3);

answered Sep 6, 2022 at 19:03

sp Kruten

857 bronze badges

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

Comments

Lucas Dittrich · Accepted Answer · 2022-09-06 19:13:04Z

1

I believe that if @sp Kruten answer doesn't suit you, you'll find something here.

answered Sep 6, 2022 at 19:13

Lucas Dittrich

5910 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Typeorm - multiple where statements

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related