[Ricardo Rodriguez] Your EPEC Network ICT Team wrote: > But, please, why obj.name=doc.fullName is required? If I remove this > conditions, the query retrieve only a couple of documents with the > defined properties populated and a bunch of empty ones. >
As with any query language, "select from A, B" will not imply any relationship between A and B. In the query above, "select from XWikiDocument, BaseObject" means "select from any document, and any object", without the restrictions that the selected objects belong to the selected document. You do this by adding "where obj.name = doc.fullName", which changes the query into: "select from any document, and any object attached to the current document", where "current" means each document currently considered for inclusion in the result. I guess some SQL training would be better to comprehend how queries work, but I hope that this little explanation is good for the moment. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users