Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#1912 closed enhancement (fixed)

Add more filter rows in list pages

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 3.5
Component: web Version:
Keywords: Cc:

Description

The current filtering is always using AND logic between each column filter. It would be nice to be able search using OR as well, or with a combination.

This could be implemented by allowing extra filter rows on the list pages and using OR when combining the rows and AND when combining the columns.

New functionality is needed in both the core and web layer but most changes are probably required in the web layer.

Change History (15)

comment:1 Changed 6 years ago by Nicklas Nordborg

(In [6697]) References #1912: Add more filter rows in list pages

Added support for this in the core. Implemented by storing context filters in the database as <property>[index] where index is the row number for additional rows (1 to n). Properties without an index are on the first filter row (=0).

ItemContext has been extended with methods for accessing filter on other filter rows. The ItemContext.configureQuery() method has been updated to use OR logic between filters on different rows (so far only the EntityQuery variant).

On the web client side, taglibs Table, ColumnDef and PropertyFilter has been extended with support for generating more than one filter row (the notification about hidden columns with filters is not yet always correct).

To bridge it all together the Base utility class has been extended with support for managing the filter rows, shich includes adding and removing rows.

So far, only the raw bioassays list page has been updated with support for multiple filter rows.

comment:2 Changed 6 years ago by Nicklas Nordborg

(In [6698]) References #1912: Add more filter rows in list pages

Implemented in list pages on the lower half of 'View' menu (physical bioassays, derived bioassays, experiments, formulas, reporters and reporter lists).

comment:3 Changed 6 years ago by Nicklas Nordborg

(In [6699]) References #1912: Add more filter rows in list pages

Fixes a problem with using non-unique id for the 'Add filter row' icon when used on pages that has multiple lists. This caused the icon to not work or add rows to the incorrect list.

The add/remove icons are now based on class names instead which means we can target each icon within the table context it is defined in.

comment:4 Changed 6 years ago by Nicklas Nordborg

(In [6700]) References #1912: Add more filter rows in list pages

Added support for dynamic queries and implemented filter rows on bioassay sets and other list pages inside an experiment (including experiment explorer).

comment:5 Changed 6 years ago by Nicklas Nordborg

(In [6701]) References #1912: Add more filter rows in list pages

Implemented on the biomaterial list pages.

comment:6 Changed 6 years ago by Nicklas Nordborg

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:7 Changed 6 years ago by Nicklas Nordborg

(In [6702]) References #1912: Add more filter rows in list pages

Implemented on the array lims list pages.

comment:8 Changed 6 years ago by Nicklas Nordborg

(In [6703]) References #1912: Add more filter rows in list pages

Implemented on files, file servers, permission templates, projects, messages, jobs and session list pages.

comment:9 Changed 6 years ago by Nicklas Nordborg

(In [6704]) References #1912: Add more filter rows in list pages

Implemented in Administrate menu: Users, groups, roles and plug-in and extensions.

comment:10 Changed 6 years ago by Nicklas Nordborg

(In [6705]) References #1912: Add more filter rows in list pages

Implemented in Administrate menu: Quota, software, hardware, protocols, clients, news, reporter clone templates.

comment:11 Changed 6 years ago by Nicklas Nordborg

(In [6706]) References #1912: Add more filter rows in list pages

Implemented in Administrate->Platforms and Administrate->Types menus.

comment:12 Changed 6 years ago by Nicklas Nordborg

(In [6707]) References #1912: Add more filter rows in list pages

Implemented in disk usage and change history lists.

comment:13 Changed 6 years ago by Nicklas Nordborg

(In [6708]) References #1912: Add more filter rows in list pages

Adding a short note about this feature in the documentation.

comment:14 Changed 6 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

comment:15 Changed 6 years ago by Nicklas Nordborg

(In [6833]) References #1912: Add more filter rows in list pages

Fixes a NPE in experiment explorer when there is no reporter filter.

Note: See TracTickets for help on using tickets.