How to make a common where for the records of the requested table and the records of the included include table?

Question

Database

I am using sequelize ORM. I make a query to the table of orders, include goods in it, how can I do this: "WHERE orders.number = 1 OR goods.vencode = 1; ?
I know how to use $or, but where related to the goods is written in include, and where for orders after include, but how to write a general where?

Answer 1

Handled the situation

$or:[
  '$goods.vencode$': {
    $like: '%searchstring%'
  },
  number: { 
    $like: '%searchstring%'
  }
]