Database Anniversary Dates: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Database_Anniversary_Dates"

@@ Line 1: / Line 1: @@
-Anniversary dates in 2013 for:
+Anniversary dates for:
-*HSC ICU - '''25 yrs''' '''(Jul 1988)'''
-*GRA ICU - '''15 yrs''' (Sep 1998)
-*STB ICU - '''14 yrs''' (May 1999), CICU - 6 yrs (Jan 15.07)
-*CON ICU - '''14 yrs''' (May 1999)
-*OAK ICU - '''14 yrs''' (Jun 1999)
-*VIC ICU - '''14 yrs''' (Jun 1999)
-*HSC Med A4 - '''10 yrs''' (Oct 2003)
-**HSC Med - '''9 yrs''' (Mar-Apr 2004)
-*Gra Med - '''9 yrs''' (Jan 2004)
-*STB Med - '''9 yrs''' (Aug-Dec 2004)
-*VIC Med - '''8 yrs''' (Aug-Oct 2005)
+<!-- this will self-update the age BUT NOT THE UNITS as they are added and removed -->
+== Current ==
+{{#cargo_query:
+tables=CollectionLocation
+|fields=_pageName=unit,
+StartDate=start,
+DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
+CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
+|where=EndDate IS NULL
+|order by=unit
+|limit=100
+|default=no results were found
+}}
+== Legacy ==
+{{#cargo_query:
+tables=CollectionLocation
+|fields=_pageName=unit,
+StartDate=start,
+EndDate=end,
+DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
+CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
+|where=EndDate IS NOT NULL
+|order by=unit
+|limit=100
+|default=no results were found
+}}
-{{stub}}
+== Wiki ==
+* the first account on this wiki was set up 2008-03-11
+== Related articles ==
+{{Related Articles}}
+[[Category:Site and Location]]