jakob / Postico

Public issue tracking for Postico
https://eggerapps.at/postico/
475 stars 9 forks source link

Allow "AND", "OR", "IN" groupings in filters #836

Open illz opened 1 year ago

illz commented 1 year ago

Long time customer of Postico. Every month or two I'm in some situation where I'd really like to setup a bunch of filters with AND/OR groupings (OR groupings often as a workaround for not having "IN") - I end up searching Postico docs hoping there's some way to do it I didn't notice, but no luck.

no filtering ability to do some simple things like SELECT * WHERE ("a" = '123' OR "a" = '234') or SELECT * WHERE "b" = TRUE AND ("a" = TRUE OR "c" = TRUE)

I do get that there are variously complex UI and code ways you could implement these groups, but even the simplest start would be nice in the developer branch

Thanks -j

jakob commented 1 year ago

I've added IN to the filters in a recent development build (Build 9595).

It's called "is in list" in the popup.

jakob commented 1 year ago

See #144 IN as a filter option for details