User Story #1358 (closed)
Opened 10 years ago
Closed 9 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 10 years ago by jmoore
comment:2 Changed 9 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.