TypeORM AND Find Option

Question

I have products with a price, I want to find products whose price will be less than 10 but more than 5. So that SQL query looks like this:

SELECT * FROM products WHERE products.price < 10 AND products.price > 5

Is it possible to do this without using Query Builder?

I don't find the And operator in the documentation

user_6365089 · Answer

You just need to use where operator.

userRepository.find({ where: { firstName: "Timber", lastName: "Saw" } });

This code executes this query:

SELECT * FROM "user" WHERE "firstName" = 'Timber' AND "lastName" = 'Saw'

And if you want to use OR, you use an array of conditions:

userRepository.find({
    where: [
        { firstName: "Timber", lastName: "Saw" },
        { firstName: "Stan", lastName: "Lee" },
    ],
});

This code will executes this query:

SELECT * FROM "user" WHERE ("firstName" = 'Timber' AND "lastName" = 'Saw') OR ("firstName" = 'Stan' AND "lastName" = 'Lee')

user_3044126 · Answer

These docs clarify how to use find like SQL https://orkhan.gitbook.io/typeorm/docs/find-options

Note that for conditional where and other statements, you need QueryBuilder.