Opened 17 years ago

Closed 17 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 Nicklas Nordborg, 17 years ago

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.

comment:2 by Johan Vallon-Christersson, 17 years ago

Will changing the limitation involve code changes or is it something that is configurable per installation?

comment:4 by Nicklas Nordborg, 17 years ago

Milestone: BASE 2.6.2
Owner: changed from everyone to Nicklas Nordborg
Status: newassigned
Type: enhancementdefect

comment:5 by Nicklas Nordborg, 17 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 Nicklas Nordborg, 17 years ago

Resolution: fixed
Status: assignedclosed

(In [4226]) Fixes #961: Expand the maximum number of characters accepted by filter input box

Note: See TracTickets for help on using tickets.