Changes for page Supervisors

From version 67.1
edited by Andrea Omicini
on 08/11/2021 01:40
Change comment: There is no comment for this version
To version 69.2
edited by Andrea Omicini
on 08/11/2021 13:41
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Tag Cloud
Content
... ... @@ -25,8 +25,8 @@
25 25  ## one tag specified in the query
26 26  >Tag “**$request.tag**” / {{stringEngIta eng = "Theses" ita = "Tesi" /}}
27 27  
28 -#set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1" )
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" )
28 +#set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" )
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 prop2.id.id = obj1.id and prop1.name = 'endDate' and prop2.name = 'status' and lower(prop2.value) <> 'out-of-date' order by prop1.value desc" )
30 30  #set( $sql = $from + " where " + $where )
31 31  #set( $thesisFound = $xwiki.searchDocuments($sql) )
32 32  ## show tag
... ... @@ -34,7 +34,6 @@
34 34  #foreach( $thesis in $thesisFound)
35 35   #set($thesisDoc = $xwiki.getDocument($thesis) )
36 36  * {{thesis}}$thesisDoc{{/thesis}}
37 -
38 38  #end
39 39  )))
40 40