Open Microscopy Environment

Hi Manics,

is this HQL magic or is this OMERO specific magic? Any documentation for this?

I'm still in the dark as how to join two tables.

The documentation here
https://docs.openmicroscopy.org/omero/5.4.0/developers/GettingStarted.html
suggests that the OMERO model from here
https://docs.openmicroscopy.org/omero/5.4.0/developers/Model/EveryObject.html
is enough to get started - but I'm finding this quite a leap.

How does one navigate around around the HQL entity mappings when building stringy queries in python?

I made an ERD of the psql database with DbVisualizer but it wasn't very useful. Is there some hibernate tool that maps the relationships?

Thanks,

Chris

Dear Chris,

You may find the join example at viewtopic.php?t=8596&p=20032 usefully illustrative. It seems that you already found the page that links to https://docs.jboss.org/hibernate/orm/3. ... yhql-joins and the other page from which you can click from https://docs.openmicroscopy.org/omero/5 ... html#image to details.owner to see firstName but depending on what you are doing you may also find that some of the administrative CLI plugins as at https://docs.openmicroscopy.org/omero/5 ... index.html can do pieces of what you want.

Cheers,
Mark

Dear Chris,

I should add, the OME model does not (yet!) perfectly correspond to the OMERO model you are working with in HQL but nonetheless you may still find https://docs.openmicroscopy.org/latest/ ... rview.html to be a helpful overview.

Cheers,
Mark