Hello everybody,
I have for different Entities. Person, AbstractRelation, ConcreteRelation1, ConcreteRelation2.
ConcreteRelation1 and ConcreteRelation2 are Subentities from AbstractRelation.
AbstractRelation has the following form:
id_person1 | id_person2 | type
For the sub entities I create the following qualifiers:
ConcreteRelation1: type=concrete_type_1
ConcreteRelation2: type=concrete_type_2
With these concrete relation entities, I modeled two 1:n Relations between Persons, lets call it relation1 and relation2, and I flattended these Relations to get the persons in the code, lets call it persons1 and persons2.
Now the Problem.
I have three entries in my corresponding AbstractRelation table
id_person1 | id_person2 | type
1 | 2 | concrete_type_1
1 | 3 | concrete_type_1
1 | 4 | concrete_type_2
Accessing the relations from the person 1 works fine.
for example person.relation1() returns the two ConcreteRelation1 Objects. But if I want to get the corresponding persons to this relation, by calling person.persons1() returns every persons in this table.
I checked the generated SQL-Statements.
If I call person.relation1() the qualifier type = concrete_type_1 was used, but if I call person.persons1() the qualifier was not used. I tried to find a solution, with no success...
Anyone have an idea?
Thanks