Where clauses across multiple tables in relational queries - Drizzle Team

Drizzle Team•3y ago

Where clauses across multiple tables in relational queries

Is is possible to specify a where condition in a relational query that includes conditions from the primary table and one or more relations?

e.g.

{
  ...
  where: or(like(purchaseOrder.po,'%xxx%'), like(product.name, '%xxx%')),
}

{
  ...
  where: or(like(purchaseOrder.po,'%xxx%'), like(product.name, '%xxx%')),
}