[ome-devel] Query the data stored in tables attached in images

[Dominik Lindner (Staff)]

Dear Keng,

I don't think you can do that, when there's a separate table for each image. You could have one shared table, for example attached to the
project or screen, then you could perform queries like that on this table.

I don't know your specific use case, but it sounds a bit like you could rather use MapAnnotations instead. See "Create a map annotation" in
https://docs.openmicroscopy.org/omero/5.4.4/developers/Java.html#write-data . If you have a MapAnnotation (or key-value-pairs how it's
called in the GUI clients) on each image, you could use HQL to query OMERO or even simply use the search functionality ( see
http://help.openmicroscopy.org/search.html#keyvalue , but is also available via the Java API in the 'SearchFaciilty').

Kind Regards,
Dominik


On 9 Mar 2018, at 00:50, Xu, Keng <K.Xu.1 at warwick.ac.uk<mailto:K.Xu.1 at warwick.ac.uk>> wrote:

Dear OMERO developers,

I'm currently using JAVA api to build a client accessing the OMERO database. Every image stored will be attached by several tables (followed by the guidehttps://docs.openmicroscopy.org/omero/5.4.0/developers/Java.html#how-to-use-omero-tables)with the same attributes (A1, A2 as example).

I want to ask that is there anyway I can query the data (like return all imge id where A1 = 1 in its attached table) without reading them to local memory?

Kind Regards,

Keng
_______________________________________________
ome-devel mailing list
ome-devel at lists.openmicroscopy.org.uk<mailto:ome-devel at lists.openmicroscopy.org.uk>
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel


The University of Dundee is a registered Scottish Charity, No: SC015096
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-devel/attachments/20180309/60e9c1e9/attachment.html>