Hi,
I have a question regarding parent attributes within a NXQL query.
e.g. document structure:
|- ( FOO ) {name=test1; color=red}
|--- ( BAR ) {code=31}
|--- ( BAR ) {code=33}
|- ( FOO ) {name=test2; color=blue}
|--- ( BAR ) {code=32}
|--- ( BAR ) {code=34}
I need to retrieve BAR documents where code < 32 and parent FOO has color red.
I'm thinking of using nested SELECTs but that will be as a last option.
I was wondering if there is a way to directly reference a parent object's
attributes within my NXQL query.
e.g.
SELECT * FROM document WHERE ecm:primaryType = BAR and BAR.parent.color=red
Can anyone help?
--
Posted by "michael_lam" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread:
<http://www.nuxeo.org/discussions/thread.jspa?threadID=2894#8446>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
