Re: [xwiki-users] understanding Livetable Macro (XE 2.4.30451)

Hi! Thanks for your detailed answer. Please, see below... -- Ricardo Rodríguez Research Management and Promotion Technician Health Research Institute of Santiago de Compostela (IDIS) http://www.idisantiago.es ________________________________________ From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Marius Dumitru Florea [mariusdumitru.florea(a)xwiki.com] Sent: 20 February 2012 09:03 To: XWiki Users Subject: Re: [xwiki-users] understanding Livetable Macro (XE 2.4.30451) Hi Ricardo, On Sun, Feb 19, 2012 at 12:25 PM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote: Thanks for the explanation. Are these lines the ones concerned in this task? #set($rm = $xwiki.rightsmanager) #if($request.member && !$request.member.trim().equals(''))

#set($countm = $rm.getAllMatchedMembersNamesForGroup($doc.fullName, $request.member, 0, 0, $order).size()) #set($members = $rm.getAllMatchedMembersNamesForGroup($doc.fullName, $request.member, $limit, $off, $order))

>>> I replaced these two lines with: >>> >>> ----------8<---------- >>> ## Statement to filter group members by their translated title. >>> #set($statement = "FROM BaseObject as groupObject, StringProperty as >>> memberField, XWikiDocument as memberDoc WHERE groupObject.name = >>> :groupName and groupObject.className = 'XWiki.XWikiGroups' and >>> groupObject.id = memberField.id.id and memberDoc.fullName = >>> memberField.value and (memberDoc.language = :language or >>> (memberDoc.language = '' and memberDoc.defaultLanguage = :language)) >>> and lower(memberDoc.title) like :titleFilter") >>> ## Determine the member count. >>> #set($countStatement = "SELECT count(memberField.value) $statement") >>> #set($query = $services.query.hql($countStatement)) >>> #set($query = $query.bindValue('groupName', $doc.fullName)) >>> #set($query = $query.bindValue('language', $context.language)) >>> #set($query = $query.bindValue('titleFilter', >>> "%$!request.member.toLowerCase()%")) >>> #set($countm = $query.execute().get(0)) >>> ## Retrieve a subset of the filtered members. >>> #set($selectStatement = "SELECT memberField.value $statement ORDER BY >>> memberDoc.title $order") >>> #set($query = $services.query.hql($selectStatement).setLimit($limit).setOffset($off)) >>> #set($query = $query.bindValue('groupName', $doc.fullName)) >>> #set($query = $query.bindValue('language', $context.language)) >>> #set($query = $query.bindValue('titleFilter', >>> "%$!request.member.toLowerCase()%")) >>> #set($members = $query.execute()) >>> ---------->8---------- >>> >>> and it worked for me on a 4.0 snapshot. I'll let you adapt it for your >>> older version of XWiki Enterprise. >>> >>> Hope this helps, >>> Marius

#else #set($countm = $rm.countAllMembersNamesForGroup($doc.fullName)) #set($members = $rm.getAllMatchedMembersNamesForGroup($doc.fullName, $util.null, $limit, $off, $order)) #end $doc.fullName clearly appears as a parameter passed to getAllMatchedMembersNameForGroup method. I'm afraid I'm not a developer myself! It is not easy for me to understand that source code. But, even not been a Java person, is not possible to pass other fields to the method to get the Livetable filtered? Please, why? I've also found this... http://www.xwiki.org/xwiki/bin/view/FAQ/Why+is+it+not+possible+to+filter+on… I can understand this, but I would like to find/be able to implement a solution here (XWiki Enterprise 2.4.30451) because: 1. Livetables created showing group members are a really useful tool here. XWiki groups are rather convenient to organize users and groups and assign them rights on the set of documents of their concern. 2. Document title is a really, at least until now!, useful piece of information that allow us, for instance, to store different translations of the name of a group and recover them using getTranslatedDocument(). 3. read-only SQL access to xwikidoc.XWD_TITLE and, for instance, XWD_PARENT offers us a quite useful source of information to tabulate information on users and groups. It is simple to create new documents with a given structure in their names to easily filter contents by type of document. Livetable filtering is an impressive tool. I would like to enable our users to use filtering by name in documents like this... http://atrium_km.idisantiago.es/bin/XWiki/XWikiIDISAreaEndocrinology?langua… All pages have title: we have edited it in the three available languages. Must I go through the creation of a new component to get it? Is there any simpler way of achieving this? Any workaround to be used until I'm able to understand how does work the whole thing and to write that component? Thank you for your help, Ricardo _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o copia de este mensaje no está autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users