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
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.
From Bernhard:
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.
particular plate.