Changes for page Theses
From version 11.1
edited by Andrea Omicini
on 11/12/2020 17:22
on 11/12/2020 17:22
Change comment:
There is no comment for this version
To version 10.1
edited by Andrea Omicini
on 11/12/2020 17:20
on 11/12/2020 17:20
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -2,8 +2,8 @@ 2 2 ##tagged research on Thesis space based on tag "Alchemist" 3 3 #set( $thesisTag = "Alchemist") 4 4 #set( $thesisStatus = "Completed") 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' andprop2.value= '$thesisStatus' orderby prop1.value desc" )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" ) 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))
