[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: queries, joins and objects
Hi, We've discussed queries and returning objects quite a few times, and it's been mentioned several times that when you do a query with a JOIN, then you can't get objects returned. I'd like to stress that the above is true in general, but not always, far from it. Here's a common example of a JOIN that will return objects: SELECT doc.* FROM Document doc JOIN Relation rel ON ( rel.TargetId = doc.ObjectId ) WHERE rel.foo = 123 To me this shows that objects returned from queries, even with JOINs, should be treated mostly in the same way as objects returned from getChildren (which itself will be implemented as an internal query for many vendors). Florent -- Florent Guillaume, Head of R&D, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]