find option where with many-to-many

[hezhongfeng]

Issue Description

how to use option where to find many-to-many Relations?

user and product is many-to-many relations,Now I want to find some users IN product [1, 2, 3]

    let [users, total] = await this.userService.findAll({
      relations: ['info', 'products', 'roles'],
      where: {
        products: {
          id: In([1, 2, 3]),
        },
      },
    });

[Edgar-P-yan]

For this you have to use createQueryBuilder as TypeORM by now dosn't support this kind of queries via high-level .find*() methods.

[hezhongfeng]

thanks for your resp，I will try it soon.

[hezhongfeng]

    if (option.productId) {
      return await this.userRepository
        .createQueryBuilder('user')
        .leftJoinAndSelect('user.info', 'info')
        .leftJoinAndSelect('user.products', 'product')
        .leftJoinAndSelect('user.roles', 'roles')
        .leftJoinAndSelect('user.organization', 'organization')
        .where('organization.id = :organizationId', { organizationId: option.organizationId })
        .andWhere('product.id = :productIds', { productId: option.productId })
        .andWhere('user.id NOT IN (:...managerIds)', { managerIds: option.managerIds })
        .orderBy('user.createdAt', 'DESC')
        .take(option.take)
        .skip(option.skip)
        .getManyAndCount();
    } else {
      return await this.userRepository
        .createQueryBuilder('user')
        .leftJoinAndSelect('user.info', 'info')
        .leftJoinAndSelect('user.products', 'product')
        .leftJoinAndSelect('user.roles', 'roles')
        .leftJoinAndSelect('user.organization', 'organization')
        .where('organization.id = :organizationId', { organizationId: option.organizationId })
        .andWhere('user.id NOT IN (:...managerIds)', { managerIds: option.managerIds })
        .orderBy('user.createdAt', 'DESC')
        .take(option.take)
        .skip(option.skip)
        .getManyAndCount();
    }