Changes for page Forthcoming

Summary

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

Details

Page properties

Content

...	...	@@ -17,11 +17,11 @@
17	17	where doc.fullName = obj.name and obj.className = '$objectSpace.$objectClass' and obj.name <> '$objectSpace.$objectTemplate' and prop.id.id = obj.id and prop1.id.id = obj.id and prop2.id.id = obj.id and prop3.id.id = obj.id and prop4.id.id = obj.id and prop5.id.id = obj.id and prop6.id.id = obj.id and prop7.id.id = obj.id and prop8.id.id = obj.id and prop.name = 'start_date' and prop1.name = 'general_chair' and prop2.name = 'program_chair' and prop2.name = 'program_chair' and prop3.name = 'organising_chair' and prop4.name = 'pc_member' and prop5.name = 'spc_member' and prop6.name = 'organiser' and prop7.name = 'lecturer' and prop8.name = 'other_role_player_1' and ( ( year(prop.value) > year(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) > month(current_date()) ) or ( year(prop.value) = year(current_date()) and month(prop.value) = month(current_date()) and day(prop.value) > day(current_date()) ) ) and ( prop1.value like '%$userName%' or prop2.value like '%$userName%' or prop3.value like '%$userName%' or prop4.value like '%$userName%' or prop5.value like '%$userName%' or prop6.value like '%$userName%' or prop7.value like '%$userName%' or prop8.value like '%$userName%' ) order by date(prop.value) asc ")
18	18	#set( $eventsFound = $xwiki.search($query) )
19	19	## user forthcoming events new
20		- #set( $query = ", BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2
	20	+ #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject as obj0, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop2
21	21	where obj0.name = doc.fullName and obj0.className = '${objectSpace}.${objectClass}' and obj0.name <> '${objectSpace}.${objectTemplate}' and prop2.id.id = obj0.id and prop2.name = 'end_date' and ( ( year(prop2.value) > year(current_date()) ) or ( year(prop2.value) = year(current_date()) and month(prop2.value) > month(current_date()) ) or ( year(prop2.value) = year(current_date()) and month(prop2.value) = month(current_date()) and day(prop2.value) > day(current_date()) ) ) and obj1.name = doc.fullName and obj1.className = '${objectSpace}.Roles.${objectClass}' and prop1.id.id = obj1.id and prop1.name = 'who' and prop1.value like '%$userName%' order by date(prop2.value) asc " )
22	22	## execute query new
23	23	#set( $eventsFoundNew = $xwiki.searchDocuments($query) )
24		- #if( $eventsFoundNew.size() > 0 )$eventsFoundNew
	24	+ #if( $eventsFoundNew.size() > 0 )
25	25	#set( $discard = $eventsFound.addAll($eventsFoundNew) )
26	26	#end
27	27	##