How to pass WHERE clause to Sequelize generated subqueries?

Viewed 7

I have a Sequelize view that uses joins like this:

select * from tableA left join (select * from tableB where someKey={some input}) newTableB on tableA.someId = newTableB.someId

Now, when I create a view from this query, I can create a sequelize model for it. But, I want to execute the query in sequelize... like -

models.tableView.findAll({  some clause })

In the above where clause, I want to pass the value of someKey (referring to someKey={some input} in the sample view). How do I do that?

I don't want to fetch all data and then apply the tableB.someKey=something (as that will take far more time)

0 Answers
Related