¿ªÔÆÌåÓý

Re: Filters in databases #database


 

On Tue, Nov 5, 2024 at 09:56 AM, Winnie wrote:
Currently there are no options to filter in databases, one can only search, as far as I know.?
It would be nice if this feature would be added, so you could filter for instance on one of the columns.?
?
Filters only work on fields that are restricted to a fixed number of constant, unchangeable values. In computer-speak, these are .
?
As an example, in the Member List, a filter works fine on a status badge or the message delivery setting because these are pre-defined. Email address, Display Name and Join Date are not, thus there is no way to filter on those.
?
Having said that:
- It should be possible to create a plain-text column of type enum and provide all the acceptable values at the time of definition.
- Whenever a row is created, a pick-list of those values would be displayed for that field and you'd be forced to choose from that.
- Thus populated, a corresponding filter could be displayed at the top of the database.
?
It would be especially nice to do something similar with Extra Member Data. I don't know how complicated the implementation would be, but that's Mark's problem.
?
If someone were to suggest this in beta, I'd support it.
?
Regards,
Bruce

Join [email protected] to automatically receive all group messages.