¿ªÔÆÌåÓý

Filters in databases #database


 

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.?
Is this something others would be interested in as well? If so, would the developers be open to that?
I have no experience in how this would normally work so excuse me if this is not an appropriate question.?
Best, Winnie?
?
?


 

On Tue, Nov 5, 2024 at 08:56 AM, Winnie wrote:
so you could filter for instance on one of the columns
You can sort by column, so that should accomplish at least part of what you're looking for.? The only way to know if the developer (Mark) would be open to something is to make a #suggestion on the beta group where he'll see it.
?
Duane
--
Lots of detailed information can be found in the Owners Manual and Members Manual.


 

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


 

On Tue, Nov 5, 2024 at 10:19 AM, I wrote:
It should be possible to create a plain-text column of type enum and provide all the acceptable values at the time of definition.
?
Hm. Looks like this field type already exists (Single select, multiple choice). That's more than half the battle.
?
Would anyone be offended if I made the suggestion?
?
Bruce


 

It took me a while to get back to you, but thank you for the suggestions. Indeed it's already possible to make columns with various options to choose from, like with checkboxes or radio buttons. However, the possibility to actually filter them when you're on the searching end is not there.?
So if that is something that could be developed, that would be fantastic.?
?
Thanks again to those who responded,?
Winnie?


 

On Thu, Nov 7, 2024 at 07:38 AM, Winnie wrote:
So if that is something that could be developed, that would be fantastic.
?
Bruce took the time to make such a where the developers will see it.? Whether it might be implemented or not is up to Mark.
?
Duane
--
Lots of detailed information can be found in the Owners Manual and Members Manual.