Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #10034 (accepted)

Opened 7 years ago

Last modified 4 years ago

Allow querying and selecting of array-columns

Reported by: spli Owned by: spli
Priority: major Milestone: Unscheduled
Component: API Version: n.a.
Keywords: n.a. Cc: analysis@…
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

Current limitations of array columns (#5632):

  • Can't be used as part of a select query.
  • The whole array is returned, it isn't possible to select specific elements within the array.

Change History (9)

comment:1 Changed 7 years ago by spli

Use case (from CRS4):

In terms of tables, we would like to be able to retrieve array data on arbitrary indexes, which may or may not be contiguous.
Assume I'm storing arrays in the seventh column of table t: currently I can get the first element of the array in the first row by doing something like:

t.slice([7], [1]).columns[0].values[0][0]

but this loads the entire array. Perhaps adding an optional argument to methods like slice could allow to perform further selections into arrays.

comment:2 Changed 7 years ago by spli

  • Priority changed from minor to major
  • Sprint set to 2013-02-12 (5)
  • Status changed from new to accepted

comment:3 Changed 7 years ago by jburel

  • Sprint changed from 2013-02-12 (5) to 2013-03-12 (6))

Moved from sprint 2013-02-12 (5)

comment:4 Changed 7 years ago by jburel

  • Sprint changed from 2013-03-12 (6)) to 2013-04-09 (7))

Moved from sprint 2013-03-12 (6))

comment:5 Changed 7 years ago by jburel

  • Sprint changed from 2013-04-09 (7)) to 2013-05-07 (8)

Moved from sprint 2013-04-09 (7))

comment:6 Changed 7 years ago by jburel

  • Milestone changed from OMERO-4.4.x to OMERO-4.4.9
  • Sprint changed from 2013-05-07 (8) to Blocker 4.4.9 (1)

Moved from sprint 2013-05-07 (8)

comment:7 Changed 4 years ago by jamoore

  • Milestone changed from 5.x to Unscheduled

comment:8 Changed 4 years ago by jburel

Referencing ticket #9944 has changed sprint.

comment:9 Changed 4 years ago by jburel

Referencing ticket #9944 has changed sprint.

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.148544 sec.)

We're Hiring!