Changes for page Theses
From version 12.1
edited by Andrea Omicini
on 11/12/2020 17:26
on 11/12/2020 17:26
Change comment:
There is no comment for this version
To version 16.1
edited by Andrea Omicini
on 11/12/2020 17:28
on 11/12/2020 17:28
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,15 +1,18 @@ 1 1 {{velocity filter="none"}}{{html clean="false" wiki="true"}} 2 +#foreach ($thesisStatus in ["Available","Ongoing","Completed"]) 2 2 ##tagged research on Thesis space based on tag "Alchemist" 3 3 #set( $thesisTag = "Alchemist") 4 -## completed 5 -#set( $thesisStatus = "Completed") 6 6 #set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" ) 7 7 #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('$thesisTag') 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' and prop2.id.id=obj1.id and prop2.name = 'status' and prop2.value = '$thesisStatus' order by prop1.value desc" ) 8 8 #set ( $sql = $from + " where " + $where ) 9 9 #set($thesisFound = $xwiki.searchDocuments($sql)) 9 +#if ($thesisFound.size()>0) 10 += $thesisStatus = 10 10 #foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis)) 11 11 * [[$thesisDoc.getValue('title')>>$thesis]] 12 -#end 13 +#end 14 +#end 15 +#end 13 13 {{/html}} 14 14 15 - #foreach ($thesisStatus in ["Availble","Completed"]) $thesisStatus #end18 +