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

Hi! Once again, thank your very much for your patience. Please, see below... ________________ From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Marius Dumitru Florea [mariusdumitru.florea(a)xwiki.com] Sent: 24 February 2012 09:52 To: XWiki Users Subject: Re: [xwiki-users] understanding Livetable Macro (XE 2.4.30451) On Thu, Feb 23, 2012 at 6:58 PM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote: Please, see what is working here... #set($selectStatement = "SELECT memberField.value $statement ORDER BY memberDoc.title") I think I've not removed at all the ORDER BY clausule and, in fact, memberDoc.title is accepted even though it is not selected. #set($selectStatement = "SELECT memberField.value $statement ORDER BY memberDoc.title $order") This is the very same line you initially proposed. I think I got the point. The problem is how $order is set. As .countAllMembersNamesForGroup is only used for not filtered lists, I've moved these lines... #set($order = true) #if("$!{request.dir}" == 'desc') #set($order = false) after the #else of the filter statement. It now reads this way... #else #set($order = true) #if("$!{request.dir}" == 'desc') #set($order = false) #end #set($countm = $rm.countAllMembersNamesForGroup($doc.fullName)) #set($members = $rm.getAllMatchedMembersNamesForGroup($doc.fullName, $util.null, $limit, $off, $order)) #end When .countAllMembersNamesForGroup is not used, we have to set $order in a different way. I've tried this within and it worked... #set($order = 'asc') #if("$!{request.dir}" == 'desc') #set($order = 'desc') #end BUT.. I would like to have the same criteria to order both non-filtered and filtered lists. Thus, using what I've learnt here, I'm sure that it si not elegant this code, I'm running not these lines: *** #set($order = 'asc') #if("$!{request.dir}" == 'desc') #set($order = 'desc') #end #if($request.member && !$request.member.trim().equals('')) ## 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' or groupObject.className = 'XWiki.XWikiUsers') 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()) #else #set($statement = "FROM BaseObject as groupObject, StringProperty as memberField, XWikiDocument as memberDoc WHERE groupObject.name = :groupName and (groupObject.className = 'XWiki.XWikiGroups' or groupObject.className = 'XWiki.XWikiUsers') and groupObject.id = memberField.id.id and memberDoc.fullName = memberField.value and (memberDoc.language = :language or (memberDoc.language = '' and memberDoc.defaultLanguage = :language))") ## 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($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($members = $query.execute()) #end *** This way I can use any file to order the lists. To the best of my understanding, $xwiki.rightsmanager won'be used anymore in this script. Thus, I'll commented it out. Am I right? Thanks! Done. I did this before, but I was not able to remember that solution! Thank you very much. BUT, it doesn't work. It must be some other problema as far as the translations doesn't reply to the language settings of each page.For instance, Results x - y out-of z per page of m, all in English, appears eventhough I select Spanish or Galician... This text doesn't change... These keys exist in the concerned ApplicationResources file: # Deprecated: xe.pagination.results=Results xe.pagination.results.of=out of ui.ajaxTable.outof=out of ui.ajaxTable.loading=Loading... But I'm not able yet of understanding how these, or other translated strings, are called by this pagination tool. Any help will be welcome! Thanks! 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