Changes for page Theses

From version 9.1
edited by Andrea Omicini
on 11/12/2020 17:19
Change comment: There is no comment for this version
To version 13.1
edited by Andrea Omicini
on 11/12/2020 17:27
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,13 +1,18 @@
1 1  {{velocity filter="none"}}{{html clean="false" wiki="true"}}
2 +#foreach ($thesisStatus in ["Availble","Ongoing","Completed"])
3 +
4 += $thesisStatus =
5 +
2 2  ##tagged research on Thesis space based on tag "Alchemist"
3 3  #set( $thesisTag = "Alchemist")
4 -#set( $thesisStatus = "Completed")
5 -#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1" )
6 -#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' order by prop1.value desc" )
8 +#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" )
9 +#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" )
7 7  #set ( $sql = $from + " where " + $where )
8 8  #set($thesisFound = $xwiki.searchDocuments($sql))
9 9  #foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis))
10 -* [[$thesisDoc.getValue('title')|$thesis]]
13 +* [[$thesisDoc.getValue('title')>>$thesis]]
11 11  #end
15 +#end
12 12  {{/html}}
13 13  
18 +

Logo