Query using query builder to make an inner join and select with condition in typeORM

Question

I am new to query builder. I need to apply a query. I did it on mysql and it's working fine. But I couldn't make where condition in the query.

This is my SQL query:

select users_roles.user_id 
from users_roles 
inner join roles on roles.id = users_roles.role_id  
where roles.role = 'ADMIN_ROLE' 
   or roles.role = 'SUPER_ADMIN_ROLE'

I tried to do this using query builder and did this without using any where condition. How can I filter according to that mysql code? Here I am adding my query builder query:

const query = this.userRoleRepository.createQueryBuilder('usersRoles');

      const users = await query
        .innerJoinAndSelect('usersRoles.user', 'user')
        .getMany();

Actually it's returning whole user list. But I need only specified two type of user. That should be filtered with where condition. which is in mysql query.

Since you do have the actual query just use it.

Stefanov.sm
– Stefanov.sm

2021-10-25 06:51:32 +00:00
Commented Oct 25, 2021 at 6:51 — Stefanov.sm
– Stefanov.sm, Commented Oct 25, 2021 at 6:51

Rasool Khan · Accepted Answer · 2021-10-25 07:42:36Z

1

const users = await query
    .select(userRoles.user_id)
    .innerJoin('userRoles.roles', 'roles', 'roles.id = users_roles.role_id')
    .where("roles.role = :adminRole OR roles.role =: superRole", { adminRole: 'ADMIN_ROLE', superRole: 'SUPER_ADMIN_ROLE' })
    .getMany();

I hope this works.

answered Oct 25, 2021 at 7:42

Rasool Khan

5411 gold badge7 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Query using query builder to make an inner join and select with condition in typeORM

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related