Typeorm and operator without using querybuilder

Question

In NestJS / Typeform I want to make a query that sues to conditions as an AND condition.

I tried something like this

 async getByUniqueConstraints(user: User){
        const {email, phoneNumber} = user
        const foundUser = await this.userRepository.findOne({where: [email, phoneNumber], });

    }

The problem with this is that it uses an OR condition. Is there a way to use this with an AND operator instead without using a querybuilder or any more advanced concepts?

Karla Hernandez · Accepted Answer · 2025-06-25 11:24:08Z

4

where with fields in curly braces uses AND operator. You can see it in docs here: https://github.com/typeorm/typeorm/blob/master/docs/docs/working-with-entity-manager/3-find-options.md

edited Jun 25 at 11:24

Karla Hernandez

3815 silver badges14 bronze badges

answered Sep 18, 2021 at 14:17

ruciu

7728 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Typeorm and operator without using querybuilder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related