EntityQuery many to many question

[valbosoft]

Hello,

I'm trying to use an entityquery with restrictions on a many to many relationship. Is there some recommended way to do?

Example: Class Person and favourite colors, Person having a many to many relationship to class Color. On the search screen for persons I'd have a list of favourite colours; the ones that are chosen should be a restriction for the entity query.

How could I implement this in an easy way? Or should I abandon entity queries for these cases?

Regards, Bo

[yacho]

Seems that you should Mark the relation as Bi Directional and then :

1. get the desired Color entity instance
2 Having Color entity instance fetch users entities.

[valbosoft]

Hello,

What I try to do is to use the standard way the EntityQuery class in Seam provides to filter data in the query.

Any suggestions in that direction? Or simply not possible/recommendable?

Regards, Bo

[pmuir]

person.colours in #{colours}

should work AFAICS.