Opened 13 years ago

Closed 13 years ago

Last modified 13 years ago

#1129 closed enhancement (fixed)

Filtering of child/parent items in table listing

Reported by: Jari Häkkinen Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 2.9
Component: web Version: trunk
Keywords: Cc:

Description (last modified by Nicklas Nordborg)

In many cases it would be nice to be able to filter on child or parent items in table listings. In a labeled extracts listing one would like to be able to filter on hybridizations or extracts (called 'Parents' in the view).

Change History (7)

comment:1 Changed 13 years ago by Nicklas Nordborg

Description: modified (diff)

The root problem with this is the same as for #1128. The child items are not part of the main table that builds up the table, but are fetched by additional queries (one query per column and row in the table). However, I think this problem may be easier to solve than #1128, since we don't need to retrieve the information. Possible ways forward are:

  1. Joining the tables with the child item information. I think I tried this a long time ago, but there was a problem with getting duplicate rows since we are joining a one-to-many relation.
  2. Generating subqueries that returns the id of the parent item, which is then used in the filter. Something like this this:
select * from Parent p where ... 
p.id IN (
  select p.id from Child c join c.parents p where c.name = <filter>
)

comment:2 Changed 13 years ago by Nicklas Nordborg

Milestone: BASE 2.9
Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

I think I will go for the second alternative. But before this can be implemented we need the functionality in #1156.

comment:3 Changed 13 years ago by Nicklas Nordborg

(In [4607]) References #1129: Filtering of child/parent items in table listing

Added support in core and test case for experiments in raw bioassays list is done.

comment:4 Changed 13 years ago by Nicklas Nordborg

(In [4609]) References #1129: Filtering of child/parent items in table listing

Added collection filter support for all list pages in the Administrate menu

comment:5 Changed 13 years ago by Nicklas Nordborg

(In [4610]) References #1129: Filtering of child/parent items in table listing

Added collection filter support for all list pages in the Array LIMS menu

comment:6 Changed 13 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

(In [4613]) Fixes #1129: Filtering of child/parent items in table listing

Biomaterials and the rest of the View menu.

comment:7 Changed 13 years ago by Nicklas Nordborg

(In [4619]) References #1129: Filtering of child/parent items in table listing

Remove debug code belonging to #1145 (Raw data batch import) that was checked in by accident in [4613].

Note: See TracTickets for help on using tickets.