Changes for page Theses

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,13 +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		-#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" )
	5	+#set ( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" )
	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' 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	+#if ($thesisFound.size()>0)
	10	+= $thesisStatus =
9	9	#foreach ($thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis))
10		-* [[$thesisDoc.getValue('title')|$thesis]]
11		-#end
	12	+* [[$thesisDoc.getValue('title')>>$thesis]]
	13	+#end
	14	+#end
	15	+#end
12	12	{{/html}}
13	13
	18	+