Re: [xwiki-devs] distict blog authors

I found this: http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HPriv… Getting documents where objects' properties equals some value #displayQuery(select doc.fullName from XWikiDocument doc, BaseObject obj, StringProperty prop where doc.fullName=obj.name and obj.className='XWiki.XWikiUsers' and prop.id.id=obj.id and prop.name='first_name' and prop.value='Jean-Vincent' true) What is #displayQuery ? So I guessed and tried this: #set ($sql = "select doc.author from XWikiDocument doc, BaseObject obj, StringProperty prop where doc.author=obj.name and obj.className='XWiki.ArticleClass' and prop.id.id=obj.id and prop.name='author' and prop.value='XWiki.GEVERITT'") <p>$sql</p> #set($results =$xwiki.search($sql, 30, 0)) #set($arrayresults = $results.toArray()) #foreach($res in $results) <p>$res</p> #end but I don't understand how to specify the name of author - Help. -- View this message in context: http://www.nabble.com/distict-blog-authors-tp17367672p17372634.html Sent from the XWiki- Dev mailing list archive at Nabble.com.