Database Anniversary Dates: Difference between revisions

TOstryzniuk (talk | contribs)
mNo edit summary
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Anniversary dates for:
Anniversary dates for:


<!-- this will self-update the age -->
<!-- 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
}}


* {{Location Age | Location =CON MICU }}
== Legacy ==
* {{Location Age | Location =GRA EMIP }}
{{#cargo_query:
* {{Location Age | Location =GRA MICU }}
tables=CollectionLocation
* {{Location Age | Location =GRA N3 }}
|fields=_pageName=unit,
* {{Location Age | Location =GRA N5 }}
StartDate=start,
* {{Location Age | Location =GRA OVER }}
EndDate=end,
* {{Location Age | Location =GRA W3 }}
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
* {{Location Age | Location =HSC A4 }}
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
* {{Location Age | Location =HSC B3 }}
|where=EndDate IS NOT NULL
* {{Location Age | Location =HSC CCU }}
|order by=unit
* {{Location Age | Location =HSC D4 }}
|limit=100
* {{Location Age | Location =HSC D5 }}
|default=no results were found
* {{Location Age | Location =HSC H4 }}
}}
* {{Location Age | Location =HSC H4H }}
 
* {{Location Age | Location =HSC IICU }}
== Wiki ==
* {{Location Age | Location =HSC MICU }}
* the first account on this wiki was set up 2008-03-11
* {{Location Age | Location =HSC SICU }}
 
* {{Location Age | Location =HSC EMIP }}
== Related articles ==
* {{Location Age | Location =OAK MICU }}
{{Related Articles}}
* {{Location Age | Location =STB B5old }}
* {{Location Age | Location =STB B4 }}
* {{Location Age | Location =STB B5 }}
* {{Location Age | Location =STB CCU }}
* {{Location Age | Location =STB CICU }}
* {{Location Age | Location =STB E5 }}
* {{Location Age | Location =STB E6 }}
* {{Location Age | Location =STB MICU }}
* {{Location Age | Location =STB SICU }}
* {{Location Age | Location =STB EMIP }}
* {{Location Age | Location =VIC EMIP }}
* [[VIC MICU]] (18 yrs 3 mth
* [[VIC N3F]] 1 yr
* {{Location Age | Location =VIC N4 }}
* {{Location Age | Location =VIC N5 }}
* {{Location Age | Location =VIC S3 }}
* {{Location Age | Location =VIC S4 }}
* {{Location Age | Location =VIC S5 }}
* {{Location Age | Location =VIC N4C }}
* {{Location Age | Location =VIC N5C }}


[[Category:Site and Location]]
[[Category:Site and Location]]