Menu

SKIP: Allow ranges on text field searches

+1 vote

It seems that currently only Numeric and Date fields allow for searching by range. It would be nice if this option was available for Text fields as well.

https://dbfront.com/searching#advanced

in Features (Skip) by (2.3k points)
retagged by
Understood, but could I ask for examples of what you might want to look for.   Sometimes a wild card search might cover your needs.
I have to double-check, it was requested by a user for the purposes of listing product codes that start with a certain set of characters. I think the regular string search was including other codes with the same characters in the middle of the string. I didn't know wildcards were supported, that might be all we need.
For details on using wildcards see: https://dbfront.com/searching#defaultwildcard
Thanks! I'll pass that along. Feel free to delete this feature request; I think wildcards will suffice instead of ranged searches for our needs.

1 Answer

0 votes
 
Best answer

Although a range search might make sense for some text columns, the nature of text fields is that their content can be extremely varied with patterns that don't always follow a simple sequence.

The existing ability to use wildcards, and if needed, full-text search, is still a good and flexible solution.

For more details on searching text columns see: Custom Text Search

For this reason I am going to skip this feature request. Please comment below if you think of reasons to pursue this further.

by (1.1k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...