vr7bd Comments - Answer Overflow

vr7bd

Posts Comments

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

👊

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

Hey I'm sorry! This is working! I had to restart language server. I'll stick to using and which is easier to read as you said

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

Me too I keep getting humbled by js. But honestly I'm find with and here since it's associative

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

Nope that didn't work too. I'm getting must have a Symbol.iterator

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

I'm guessing because it needs a function?

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

I'm getting typescript: expression expected

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

Ah got it! I tried putting it in an array which is what I intended to do. But it's not valid js ig (eslint: parsing error)

16 replies

DTDrizzle Team

•Created by vr7bd on 6/4/2024 in #help

Conditional query failing

I did this

// Below produces wrong output
await db.select().from(table).where(
  and(
    eq(table.userId, userId),
    selectAll
      ? and(or(...statusFilter), or(...nameFilter)) // added and condition here
      : inArray(table.userId, arr)
  )
);

// Below produces wrong output
await db.select().from(table).where(
  and(
    eq(table.userId, userId),
    selectAll
      ? and(or(...statusFilter), or(...nameFilter)) // added and condition here
      : inArray(table.userId, arr)
  )
);