| Hi,
I spent hours searching on the list and google for this, without finding real answers for this issue.
Say an entity MyEntity, having a many-to-many relationship with a Tag entity, the purpose of that is tagging MyEntity with one or more keywords (tags)
Now I want to get all MyEntity having "tag1" AND "tag2" as tags. An EOAndQualifier is nonsense in the result sql since if queries "tag1" = "tag1" AND "tag1" = "tag2", EOOrQualifier is not better since I need to match entries having *both* tags
So it seems WO qualifiers does not handle that out of the box, so what can I do ?
- Should I fetch all entities having tag1, then all having tag2, and in the java code trash all entities not having both tags ? (I potentialy have thousands of MyEntity in the database) - Make some kind of view in the database to join tags in a single column separated by "," and do a LIKE, I don't even know if that is possible... - Scratch my head until I find the perfect query and make it by hand, is that possible to get an array of MyEntity using a hand-made query ?
By advance the WOBeginner I am thank you for the hand, I'm a bit lost right now since this is the key feature of my app ! Yann Bizeul • yann at tynsoe.org Cocoa Developer
Tynsoe Projects BuddyPop • GeekTool • SSH Tunnel Manager • ...
|