Changes for page Deadlines
From version 68.1
edited by Andrea Omicini
on 27/04/2023 08:29
on 27/04/2023 08:29
Change comment:
There is no comment for this version
To version 67.1
edited by Andrea Omicini
on 27/04/2023 08:28
on 27/04/2023 08:28
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -3,8 +3,8 @@ 3 3 {{include reference="Events.Environment" excludeFirstHeading="true"/}}{{velocity}} 4 4 #if( !$userName || $userName == "" || !$userSpace || $userSpace == "" || !$userFullname || $userFullname == "" ) 5 5 ## overall incoming deadlines 6 - #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop Date7 - where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and prop Date.id.id = obj.id and propDate.name = 'paper_submission' and date(propDate.value) > current_date() order by date(propDate.value) asc ")6 + #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, DateProperty as prop 7 + where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and prop.id.id = obj.id and prop.name = 'paper_submission' and date(prop.value) > current_date() order by date(prop.value) asc ") 8 8 ## where doc.fullName = obj.name and obj.className = '${objectSpace}.${objectClass}' and obj.name <> '${objectPool}.${objectTemplate}' and prop.id.id = obj.id and prop.name = 'paper_submission' 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()) ) ) order by date(prop.value) asc ") 9 9 #else 10 10 #set( $query = "select doc.fullName from XWikiDocument doc, BaseObject obj, BaseObject as obj1, LargeStringProperty as prop1, DateProperty as prop