Opened 8 years ago

Closed 8 years ago

#2004 closed enhancement (fixed)

Raw data query for multiple raw bioassays

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 3.9
Component: core Version:
Keywords: Cc:

Description

We need a way to query for raw data from multiple raw bioassays in a single query. The reason is that we need to make a matrix with exported data. Each column is from a raw bioassay and each row is for a single reporter. The current API only allow us to query data from a single raw bioassay which makes it difficult to produce the desired output due to a very large amount of data (the exported file is expected to be several gigabytes in size).

Basically, the DynamicRawDataQuery class already have the functionality that we need.

Change History (3)

comment:1 by Nicklas Nordborg, 8 years ago

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:2 by Nicklas Nordborg, 8 years ago

(In [7151]) References #2004: Raw data query for multiple raw bioassays

Added DynamicRawDataQuery.getQuery() methods to enable support for queries on multiple raw bioassays.

Added support for joining to the RawBioAssays table and selecting columns from it.

Added support for auto-joining reporters, reporter lists and raw bioassays depending on selected columns.

The TestRawBioAssay class has been extended with a test that lists raw data + reporter + raw bioassay using the new functionality.

comment:3 by Nicklas Nordborg, 8 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.