Modifiche per il documento Relatori
Dalla versione 65.1
modificato da Andrea Omicini
il 01/09/2021 23:31
il 01/09/2021 23:31
Cambia il commento:
Nessun commento per questa versione
Alla versione 65.3
modificato da Andrea Omicini
il 02/09/2021 00:07
il 02/09/2021 00:07
Cambia il commento:
Nessun commento per questa versione
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -5,7 +5,7 @@ 5 5 6 6 #set( $from = ", BaseObject as obj0" ) 7 7 #set( $where = " obj0.name = doc.fullName and obj0.className = 'Theses.ThesisClass' and obj0.name <> 'Theses.ThesisClassTemplate' and obj0.name <> 'Theses.ThesisTemplate' " ) 8 -#set($tagCount = $xwiki.tag.getTagCountForQuery($from, $where)) 8 +#set( $tagCount = $xwiki.tag.getTagCountForQuery($from, $where) ) 9 9 (% style='text-align: center' %)((( 10 10 #foreach( $thesisTag in $tagCount.keySet() ) 11 11 #set( $thesisCount = $tagCount.get($thesisTag) ) ... ... @@ -27,8 +27,8 @@ 27 27 28 28 #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1" ) 29 29 #set( $where = "obj0.className='XWiki.TagClass' and obj0.name=doc.fullName and obj0.id=prop0.id.id and prop0.id.name='tags' and lower(item)=lower('$request.tag') and obj1.name=doc.fullName and obj1.className='Theses.ThesisClass' and obj1.name<>'Theses.ThesisClassTemplate' and obj1.name<>'Theses.ThesisTemplate' and prop1.id.id=obj1.id and prop1.name = 'endDate' order by prop1.value desc" ) 30 -#set 31 -#set($thesisFound = $xwiki.searchDocuments($sql)) 30 +#set( $sql = $from + " where " + $where ) 31 +#set( $thesisFound = $xwiki.searchDocuments($sql) ) 32 32 ## show tag 33 33 ((( 34 34 #foreach( $thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis) )