Changes for page Supervisors

From version 81.1
edited by Andrea Omicini
on 09/03/2022 23:37
Change comment: There is no comment for this version
To version 83.1
edited by Andrea Omicini
on 21/07/2022 18:45
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -36,14 +36,12 @@
36 36   #end
37 37   #if( $userSelected )
38 38  >{{stringEngIta eng = "Theses" ita = "Tesi" /}} / **$userFirstName $userLastName**
39 -
40 40   #set( $from = ", BaseObject as obj0, StringProperty as prop0, LargeStringProperty as prop1, LargeStringProperty as prop2, LargeStringProperty as prop3" )
41 - #set( $where = "obj0.name = doc.fullName and obj0.className = 'Theses.ThesisClass' and obj0.name <> 'Theses.ThesisTemplate' and prop0.id.id = obj0.id and prop1.id.id = obj0.id and prop2.id.id = obj0.id and prop3.id.id = obj0.id and prop0.name = 'status' and lower(prop0.value) = 'completed' and prop1.name = 'supervisors' and prop2.name = 'cosupervisors' and prop3.name = 'contacts' and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' )" )
40 + #set( $where = "obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectSpace}.${objectTemplate}' and prop0.id.id = obj0.id and prop1.id.id = obj0.id and prop2.id.id = obj0.id and prop3.id.id = obj0.id and prop0.name = 'status' and lower(prop0.value) = 'completed' and prop1.name = 'supervisors' and prop2.name = 'cosupervisors' and prop3.name = 'contacts' and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' )" )
42 42   #else
43 43  >{{stringEngIta eng="Theses" ita="Tesi" /}}
44 -
45 45   #set( $from = ", BaseObject as obj0, StringProperty as prop0" )
46 - #set( $where = "obj0.name = doc.fullName and obj0.className = 'Theses.ThesisClass' and obj0.name <> 'Theses.ThesisTemplate' and prop0.id.id = obj0.id and prop0.name = 'status' and lower(prop0.value) = 'completed'" )
44 + #set( $where = "obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectSpace}.${objectTemplate}' and prop0.id.id = obj0.id and prop0.name = 'status' and lower(prop0.value) = 'completed'" )
47 47   #end
48 48   ##
49 49   #set( $tagCount = $xwiki.tag.getTagCountForQuery($from, $where) )
... ... @@ -86,14 +86,14 @@
86 86   #end
87 87   #if( $request.user )
88 88   #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" )
89 - #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.ThesisTemplate' 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 = 'endDate' 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 = 'endDate' 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" )
90 90   #else
91 91   #set( $from = ", BaseObject as obj0, DBStringListProperty as prop0 join prop0.list item, BaseObject as obj1, DateProperty as prop1, StringProperty as prop2" )
92 -#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.ThesisTemplate' and prop1.id.id = obj1.id and prop2.id.id = obj1.id and prop1.name = 'endDate' 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 = 'endDate' and prop2.name = 'status' and lower(prop2.value) = 'completed' order by prop1.value desc" )
93 93   #end
94 94   #set( $sql = $from + " where " + $where )
95 95   #set( $thesisFound = $xwiki.searchDocuments($sql) )
96 - #set( $thesisFoundNo = $thesisFound.size() )
94 + #set( $thesisFoundNo = $thesisFound.size() )
97 97  >$thesisFoundNo #if( $thesisFoundNo == 1 ){{stringEngIta eng = "Thesis" ita = "tesi" /}}#else{{stringEngIta eng = "Theses" ita = "tesi" /}}#end#if( $request.user ) / **$userFirstName $userLastName**#end
98 98  ## show tag
99 99  (((