Hi! I happily use comments to add somehow structured information to documents. The most frequent case is to add new "tagged" attributes to documents holding instances of the XWiki.XWikiUsers class. I'm sure there must be better ways of doing that, but I've had no time yet to go deeper into them, and I keep surviving that way.
What I'm not able to do is to select a set of documents not containing a given string in any of the instances of XWiki.XWikiComments. Doing this... select doc.fullName from Document as doc, doc.object(XWiki.XWikiComments) as note where doc.parent like '%XWikiIDIS%' and length(doc.parent)=19 and doc.parent not like '%Area%' and doc.parent not like '%Committee%' and doc.parent not like '%Metagroup%' and doc.name not like '%Evidences%' and doc.name not like '%OI' and doc.parent not like '%DirectionBoard%' and doc.translation = 0 and note.comment not like '%IDIS Group Leader%' order by doc.parent" I get as many entries of each document as comments not containing '%IDIS Group Leader%' are held by that document. But, please, how could I get one entry for each document not containing that string in any of its comments? Thanks for your help! -- Ricardo Rodríguez Research Management and Promotion Technician Technical Secretariat Health Research Institute of Santiago de Compostela (IDIS) http://www.idisantiago.es
