<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Dear Keng,
<div class=""><br class="">
</div>
<div class="">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 </div>
<div class="">project or screen, then you could perform queries like that on this table. </div>
<div class=""><br class="">
</div>
<div class="">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 </div>
<div class=""><a href="https://docs.openmicroscopy.org/omero/5.4.4/developers/Java.html#write-data" class="">https://docs.openmicroscopy.org/omero/5.4.4/developers/Java.html#write-data</a> . If you have a MapAnnotation (or key-value-pairs how it's </div>
<div class="">called in the GUI clients) on each image, you could use HQL to query OMERO or even simply use the search functionality ( see </div>
<div class=""><a href="http://help.openmicroscopy.org/search.html#keyvalue" class="">http://help.openmicroscopy.org/search.html#keyvalue</a> , but is also available via the Java API in the 'SearchFaciilty').</div>
<div class=""><br class="">
</div>
<div class="">Kind Regards,</div>
<div class="">Dominik</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On 9 Mar 2018, at 00:50, Xu, Keng <<a href="mailto:K.Xu.1@warwick.ac.uk" class="">K.Xu.1@warwick.ac.uk</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div id="divtagdefaultwrapper" dir="ltr" style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; font-family: Calibri, Helvetica, sans-serif;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Dear OMERO developers,</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">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 guide<a href="https://docs.openmicroscopy.org/omero/5.4.0/developers/Java.html#how-to-use-omero-tables" class="OWAAutoLink" id="LPlnk991685" previewremoved="true" tabindex="-1" disabled="true">https://docs.openmicroscopy.org/omero/5.4.0/developers/Java.html#how-to-use-omero-tables</a>)with
the same attributes (A1, A2 as example).</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">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?</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Kind Regards,</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class="">
</div>
<div style="margin-top: 0px; margin-bottom: 0px;" class="">Keng</div>
</div>
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">ome-devel
mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="mailto:ome-devel@lists.openmicroscopy.org.uk" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">ome-devel@lists.openmicroscopy.org.uk</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel</a></div>
</blockquote>
</div>
<br class="">
</div>
<br>
<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</body>
</html>