Navigating back to Image

[johnjhufnagle]

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

[jmoore]

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