| 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 • ... |
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
