CODEWITHSUNDEEP
node.jssequelize.js
Manimaran
Manimaran

Reputation: 405

How to properly use sub query in sequelize?

......
.....

return myDb.myTable.rollgroup.findAll({

                attributes : ['ID','GROUPNAME'],
                where : {
                    id : {
                      $notIn: ? //// how to use subQuery here
                    }
                }


              }).then((getResult) => {

                  return getResult;

              })
.......
.......

My raw Query Like this:

select mg.ID,mg.GROUPNAME from mygroup mg where mg.ID not in (select egr.GROUPID from employeegrouprelation egr where egr.PID = ? )

Upvotes: 1

Views: 5217

Answers (1)

Faz
Faz

Reputation: 379

You can make use of sequelize.literal to wrap the subquery:

    ...

    id:{
        $notIn: sequelize.literal('(select egr.GROUPID from employeegrouprelation egr where egr.PID = ?)')
       }

    ...

Upvotes: 1

Related Questions