I can't find any explanation of the where attribute in the ref docs or HIA. I'd like to know the syntax available to me in a collection's where clause.

I have an entity (Installation) with a date range, containing a Meter and collection of that meter's Configurations, which also have date ranges. The Set of Configurations will be the Configurations of the Meter whose date ranges overlap with the Installation's date range. So in Installation's mapping I want something like

How do I get a reference to the parent entity (inst) and nested entity (config) into the where attribute?

subquery



If the set is a many-to-many, you'd probably need to move this where attribute to the <many-to-many/> element and tweak it to account for the association table.

Fair enough. It's a bit inefficient though, especially seeing as the generated SQL has those table aliases in it, so they could be accessible fairly easily.
Would adding support for aliases to that where clause be major work? Perhaps something like {parent} and {element}. There are quite a few attributes in various elements with simple SQL (order-by, where, subselect, etc.) which would be able to benefit from a few standard aliases like that. If it's a reasonable request I could add a JIRA issue about it.