How to query with ' OR ' Operation in where object using find-options API in TypeORM

In TypeORM, you can use the "OR" operation within the where object of the find method to construct queries that retrieve all records satisfying at least one of the specified conditions. This is typically achieved by using the FindOperator type and operators such as MoreThanOrEqual and LessThanOrEqual.

Here is an example using the find method of TypeORM with an OR query:

typescript
import { getRepository } from "typeorm";
import { User } from "./entity/User";

// Assuming we want to query all users whose first name is 'John' or age is greater than 25
getRepository(User)
  .find({
    where: [
      { firstName: "John" },
      { age: MoreThan(25) }
    ]
  })
  .then(users => {
    // Process the retrieved users
    console.log(users);
  })
  .catch(error => {
    // Handle potential errors
    console.error(error);
  });

In this example, the where clause is an array of objects, each representing a query condition. TypeORM combines these conditions with a logical "OR", so the query results will include all users whose first name is 'John' or age is greater than 25.

Additionally, if your query conditions are more complex and require nested OR and AND conditions, you can use the QueryBuilder to construct more advanced queries. Here is an example using QueryBuilder:

typescript
import { getRepository } from "typeorm";
import { User } from "./entity/User";

// Create a QueryBuilder
const userRepository = getRepository(User);
userRepository.createQueryBuilder("user")
  .where("user.firstName = :firstName", { firstName: "John" })
  .orWhere("user.age > :age", { age: 25 })
  .getMany()
  .then(users => {
    // Process the retrieved users
    console.log(users);
  })
  .catch(error => {
    // Handle potential errors
    console.error(error);
  });

In this example, .where() defines the first condition, and .orWhere() adds an OR condition, which are combined together.

Please note that depending on your specific requirements, you may need to replace getMany with getOne or use other API methods. Additionally, these code examples assume that you have already set up TypeORM and have a User entity.