Database Anniversary Dates: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-Anniversary dates in 2015 for:
+Anniversary dates for:
-*HSC ICU - '''27 yrs''' '''(Jul 1988)'''
-*GRA ICU - '''17 yrs''' (Sep 1998)
-*STB ICU - '''16 yrs''' (May 1999)
-**STB_CICU - '''8 yrs''' (Jan 15.2007)
-*CON ICU - '''16 yrs''' (May 1999)
-*OAK ICU - '''16 yrs''' (Jun 1999)
-*VIC ICU - '''16 yrs''' (Jun 1999)
-*HSC Med A4 - '''12 yrs''' (Oct 2003)
-**HSC Med - '''11 yrs''' (Mar-Apr 2004)
-*Gra Med - '''11 yrs''' (Jan 2004)
-*STB Med - '''11 yrs''' (Aug-Dec 2004)
-*VIC Med - '''10 yrs''' (Aug-Oct 2005)
+<!-- this will self-update the age BUT NOT THE UNITS as they are added and removed -->
-See if we can do this with Semantic Mediawiki:
+== Current ==
-{{#ask: [[Category:Collection Location]]
+{{#cargo_query:
-| searchlabel=Collection Locations
+tables=CollectionLocation
-| ?Collection Location Startdate
+|fields=_pageName=unit,
-| ?Collection Location Program
+StartDate=start,
-| ?Collection Location Hospital
+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
 }}
-{{#ask: [[Category:Collection Location]]
+== Legacy ==
-| searchlabel=Collection Locations
+{{#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
 }}
+== Wiki ==
+* the first account on this wiki was set up 2008-03-11
+== Related articles ==
+{{Related Articles}}
-{{#show: HSC_A4 | ?Collection Location Startdate#ISO}}
+[[Category:Site and Location]]
-* {{Location Age | Location=HSC_A4 }}