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) to generate the equivalent sql select * from appointment where appointment.canceled, which works exactly how I expect. .where(() => appointment.canceled) or .where((a) => a.canceled) don't work either.
I can use
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?2 Replies