Changes for page Supervisors

From version 18.1
edited by Andrea Omicini
on 25/06/2021 02:11
Change comment: There is no comment for this version
To version 20.1
edited by Andrea Omicini
on 25/07/2021 16:44
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -4,7 +4,7 @@
4 4  > **Tag Cloud** / {{stringEngIta eng="Theses" ita="Tesi" /}}
5 5  
6 6  #set ($from = ", BaseObject as obj0")
7 -#set ($where = "obj0.name=doc.fullName and obj0.className='Theses.ThesisClass' and obj0.name<>'Theses.ThesisClassTemplate'")
7 +#set ($where = "obj0.name=doc.fullName and obj0.className='Theses.ThesisClass' and obj0.name<>'Theses.ThesisClassTemplate and obj1.name<>'Theses.ThesisTemplate''")
8 8  #set ($tagCount = $xwiki.tag.getTagCountForQuery($from, $where))
9 9  
10 10  (% style='text-align: center' %)(((
... ... @@ -27,7 +27,7 @@
27 27  #else ## one tag specified in the query
28 28  
29 29  #set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1" )
30 -#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 prop1.id.id=obj1.id and prop1.name = 'endDate' order by prop1.value desc" )
30 +#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" )
31 31  #set ( $sql = $from + " where " + $where )
32 32  #set($thesisFound = $xwiki.searchDocuments($sql)) // //
33 33  > Tag “**$request.tag**” / {{stringEngIta eng = "Theses" ita = "Tesi" /}} // //