2 replies

What's the recommended way to do a basic filter by a boolean column's value?

I can't figure out how to use a non-filter expression for filtering.

e.g., I would expect

db.select().from(appointment).where(appointment.canceled)

db.select().from(appointment).where(appointment.canceled)

to generate the equivalent sql

select * from appointment where appointment.canceled

select * from appointment where appointment.canceled

, which works exactly how I expect.

.where(() => appointment.canceled)

.where(() => appointment.canceled)

.where((a) => a.canceled)

.where((a) => a.canceled)

don't work either.

I can use

.where(sql`${appointment.canceled}`)

.where(sql`${appointment.canceled}`)

but surely there must be a simpler way?

I can provide this column as an argument to a filter, so why can't I use this column itself as a filter?