7 replies

Optional filter param, coalesce to true?

Is there a way to achieve this coalescing technique, but in valid drizzle sql?

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

const filterByBool: boolean | undefined | null = undefined

await db
  .select()
  .from(test)
  .where(test.bool == filterByBool ?? true)

Optional filter param, coalesce to true? - Drizzle Team