Changes for page Supervisors

From version 65.2
edited by Andrea Omicini
on 02/09/2021 00:07
Change comment: There is no comment for this version
To version 65.3
edited by Andrea Omicini
on 02/09/2021 00:07
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -27,8 +27,8 @@
27 27  
28 28  #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1" )
29 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" )
30 -#set ( $sql = $from + " where " + $where )
31 -#set($thesisFound = $xwiki.searchDocuments($sql))
30 +#set( $sql = $from + " where " + $where )
31 +#set( $thesisFound = $xwiki.searchDocuments($sql) )
32 32  ## show tag
33 33  (((
34 34  #foreach( $thesis in $thesisFound)#set($thesisDoc = $xwiki.getDocument($thesis) )