Opened 16 years ago
Closed 16 years ago
#961 closed defect (fixed)
Expand the maximum number of characters accepted by filter input box
| Reported by: | Johan Vallon-Christersson | Owned by: | Nicklas Nordborg |
|---|---|---|---|
| Priority: | major | Milestone: | BASE 2.6.2 |
| Component: | web | Version: | |
| Keywords: | Cc: |
Description
If an item list contains many items you may need to use a filter to be able to find the item you are looking for. The input boxes on the line below the column headers are used for filtering. Often you want to view a selection of items and filter on several values at the same time. This can conveniently be done by entering a pipe (”|”) separated list of values in the filter input box, for example, a filter text like ”sampleA|sampleB|sampleC” to view samples A-C. However, the maximum length of values accepted by filter input box is limited (255 characters) and this limits the possibilities to enter a long list of values. Would it be possible to extend the maximum number of characters accepted by filter input box and what limitations/effects would a long input string evoke? For example, would a limit of tens of thousand characters cause problems? If not, such an extension of the maximum character number would be useful.
Change History (6)
comment:1 by , 16 years ago
comment:2 by , 16 years ago
Will changing the limitation involve code changes or is it something that is configurable per installation?
comment:3 by , 16 years ago
The current limit is hardcoded in the code: http://base.thep.lu.se/browser/trunk/src/clients/web/net/sf/basedb/clients/web/taglib/table/ColumnDef.java#L640
comment:4 by , 16 years ago
| Milestone: | → BASE 2.6.2 |
|---|---|
| Owner: | changed from to |
| Status: | new → assigned |
| Type: | enhancement → defect |
comment:5 by , 16 years ago
| Summary: | Filtering view item list – expand the maximum number of characters accepted by filter input box. → Expand the maximum number of characters accepted by filter input box |
|---|
The value should be taken from the max length allowed in the database for a filter.
comment:6 by , 16 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
The more complex a query is the longer time it will take to execute it. But I have no estimate on how much performace will suffer from adding more values to look for. Each value will add an
OR column = ?to the SQL statement. I have searched the net for any information regarding the number of parameters to a query but couldn't find anything. I guess this means that if there is a limit, it is high enough to have no practical effect.The database itself has a limitation of 65536 characters per filter. The only way to know how much this affects performance is to try it.