DT
Drizzle Team•12mo ago
Nickolaki

Query where clause with array.

How can I get something like this to work? 
    const products = ["subscription", "insurance"]

    const productsToLink = await tx.query.products.findMany({
      where: (products, { eq }) => eq(products.name, products),
    });
    const products = ["subscription", "insurance"]

    const productsToLink = await tx.query.products.findMany({
      where: (products, { eq }) => eq(products.name, products),
    });
I want the where clause to match any product that has a name thats inside the products array.
2 Replies
Ahmed
Ahmed•12mo ago
Use inArray 
   const products = ["subscription", "insurance"]

    const productsToLink = await tx.query.products.findMany({
 where:inArray(products.name, 
products),
    });
   const products = ["subscription", "insurance"]

    const productsToLink = await tx.query.products.findMany({
 where:inArray(products.name, 
products),
    });
Nickolaki
Nickolaki•12mo ago
Perfect thank you, just seen all the possible operators on the docs. ❤️
Want results from more Discord servers?
Add your server
More Posts
What's the best way to deploy migrations on production database?I'm confused as to what is the best way to deploy migration on the production database. Locally whenDefault values not working for insert```ts await db .insert(Drizzle.User) .values({ email, password: Utils.getHash(paHow to define types for jsonbHow do you provide custom type interfaces for jsonb columns returned via queries. for instance if iwhy is "<ref *1> SQLiteTable { ..." printed to consoleThe following code is all it takes to get the entire Table schema to be printed to the console. I hDoes Drizzle ORM support CommonJS (CJS)?I'm trying to use Drizzle ORM for the first time in a brand new project and I am getting this error:What exactly is the `check` command doing?would the screenshot not constitute a failed "check"? when i run `drizzle-kit check:pg` i get the foSQLite: timestamp vs timestamp_ms modesThe SQLite column types docs mention there's multiple modes for integers. What's the difference betIs there a way to simply check if the current schema file matches the DBI want to perform a check to the effect of "is my `schema.ts` file exactly the same as what is in my