Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
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"

User Story #1358 (closed)

Opened 15 years ago

Closed 14 years ago

Add support for countBy, min/maxBy, and avgByQuery()

Reported by: jamoore Owned by: jamoore
Priority: minor Milestone: OMERO-Beta4.2
Component: API Keywords: n.a.
Cc: atarkowska, bernhard.hollaender@… Story Points: n.a.
Sprint: 2010-03-19 (5) Importance: n.a.
Total Remaining Time: n.a. Estimated Remaining Time: n.a.

Description

Requested both by Ola for IShare/ITimeline & Bernhard for counting various screen features.

  • Not certain to be in 4.1
  • May could use a special return type:
      class Stats {
        long count;
        long min;
        long max;
        long avg;
      };
    

Change History (2)

comment:1 Changed 15 years ago by jmoore

From Bernhard:

What particular counts are you trying to perform?

E.g. getting a plate geometry. Which could be done similar to this
query I guess:

select count(distinct w.row), count(distinct w.column) from Well w
where w.plate.id=plateId

In addition since our view of plate measurements starts at plates and
not at wellsamples that define a screen acquisition, it might be
useful to have counts of how many samples have been taken in one well.

Or how many measurements have been performed in one screen for one

particular plate.

comment:2 Changed 14 years ago by jmoore

  • Milestone changed from Unscheduled to OMERO-Beta4.2
  • Resolution set to fixed
  • Sprint set to 2010-03-19 (5)
  • Status changed from new to closed

Implemented in r6432 as IQuery.projection() - still needs some shaking out.

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.65943 sec.)

We're Hiring!