Open Microscopy Environment

Hi,

What would be the code snippet for a piece of OMERO server-side code (custom bridge helper) to retrieve the set of Images that have been annotated by a given CommentAnnotation.

So for example if my custom bridge helper's set() method has been called what is the code & 'hql' to retrieve the list of Images that are annotated by this CommentAnnotation?

Thanks
John

Hi John,

In 4.1, annotations are unidirectional and therefore it's not possibly to navigate from annotations to the annotated objects (Images, Datasets, ...). With a (significantly) more complicated bridge configuration, it would be possible to get access to the Hibernate session and perform a query of the form:

Code: Select all

select i from Image i join i.annotationLinks links join links.child annotation where annotation.id = 5


Working from images will keep your bridge simpler and more robust. There is the question of how to guarantee that annotated images are passed to the bridge in a timely manner. If you don't see in the logs the images being passed to the indexer along with the annotations, your options include:

* a cron job
* a database trigger
* modifying the objects in code (e.g. incrementing their version number)

A ticket exists for this problem with annotations. See http://trac.openmicroscopy.org.uk/omero/ticket/1390

Cheers,
~Josh