Hi,

I'm having trouble figuring out how to map the inverse of an <any> relationship. For example, here is part of the mapping for a Quota object:



These quotas can be applied to many different types of objects. Given the quota, I can getObject and to get the object that it is applied to. This works well.

However, I can't figure out how to get the set of quotas for a given object (e.g. User object). If it was not an <any> relationship, I would do something like:



But what do I put in the <key> to show that it refers to the "object_class" and "object_id" of my <any> relationship?

This looks like a really broken object model to me. However, have you tried to use:

This syntax seems to be ok, but it doesn't do what I want. Fetching the quotas for a User returns all of the quota objects that have that are associated with an object with the same id as the user, no matter the type. e.g. if my user's id is 1, I get the quotas associated with all objects that have an id of 1.

As for the object model being broken, that is possible. It shouldn't preclude the ability to navigate <any> relationships bidirectionally. It's not like the SQL is that difficult to figure out:



In fact, I have a workaround which is doing exactly this. But, this is really the responsibility of the mapping to handle. The fact that the SQL is so straightforward leads me to believe that probably supports this, even if I can't figure out how.

You could add an additional where="object_class=xxx" attribute for the set, where xxx is the discriminator value for your User class in the table.

That did the trick.

Thanks!