Hi,

Does anybody know how I can access - in HQL - the index of a map containing a many-to-many relatonship?

If the map contains normal elements I can use the index function

FROM Country country, c.translations as countryTranslation
WHERE index(countryTranslation) = 'en'

but this doesn't seem to work when the map contains many-to-many elments.

FROM Certificate c, c.businesses as x
WHERE index(x) = 'roleX'

I get a message saying that the contained object (Business in this case) does not support the index property (Could not resolve property: index of: Business )

As an alternative, can I use the index in a HQL join (inner join ...)?

PS: where c.businesses( 'roleX' ) = x works fine, but I'd like to access the actual index to optimise the query