Changes for page Supervisors
From version 83.1
edited by Andrea Omicini
on 21/07/2022 18:45
on 21/07/2022 18:45
Change comment:
There is no comment for this version
To version 86.1
edited by Andrea Omicini
on 27/01/2023 17:24
on 27/01/2023 17:24
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 -Theses.WebHome 1 +Theses.Clouds.WebHome - Content
-
... ... @@ -1,4 +1,4 @@ 1 -= {{velocity}}#if( $request.tag )(% style="color:$theme.textSecondaryColor" %)tag : (%%)$request.tag#else{{stringEngIta eng="Tag Cloud" ita= "Nuvoladei tag"/}}#end{{/velocity}} =1 += {{velocity}}#if( $request.tag )(% style="color:$theme.textSecondaryColor" %)tag : (%%)$request.tag#else{{stringEngIta eng="Tags" ita= "Tag"/}}#end{{/velocity}} = 2 2 3 3 {{include reference="Theses.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 4 ## thesis page with menus ... ... @@ -84,10 +84,10 @@ 84 84 #end 85 85 #if( $request.user ) 86 86 #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, StringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3, LargeStringProperty as prop4, DateProperty as prop5" ) 87 - #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 = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop3.id.id = obj1.id and prop4.id.id = obj1.id and prop5.id.id = obj1.id and prop1.name = 'status' and prop2.name = 'supervisors' and prop3.name = 'cosupervisors' and prop4.name = 'contacts' and prop5.name = 'end Date' and lower(prop1.value) = 'completed' and ( prop2.value like '%$request.user%' or prop3.value like '%$request.user%' or prop4.value like '%$request.user%' ) order by prop5.value desc" )87 + #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 = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop3.id.id = obj1.id and prop4.id.id = obj1.id and prop5.id.id = obj1.id and prop1.name = 'status' and prop2.name = 'supervisors' and prop3.name = 'cosupervisors' and prop4.name = 'contacts' and prop5.name = 'end' and lower(prop1.value) = 'completed' and ( prop2.value like '%$request.user%' or prop3.value like '%$request.user%' or prop4.value like '%$request.user%' ) order by prop5.value desc" ) 88 88 #else 89 89 #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" ) 90 -#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 = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop1.name = 'end Date' and prop2.name = 'status' and lower(prop2.value) = 'completed' order by prop1.value desc" )90 +#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 = '${objectSpace}.${objectClass}' and obj1.name <> '${objectSpace}.${objectTemplate}' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop1.name = 'end' and prop2.name = 'status' and lower(prop2.value) = 'completed' order by prop1.value desc" ) 91 91 #end 92 92 #set( $sql = $from + " where " + $where ) 93 93 #set( $thesisFound = $xwiki.searchDocuments($sql) )