|
|
| (2 intermediate revisions by the same user not shown) |
| Line 2: |
Line 2: |
|
| |
|
| <!-- this will self-update the age BUT NOT THE UNITS as they are added and removed --> | | <!-- this will self-update the age BUT NOT THE UNITS as they are added and removed --> |
| == Cargo == | | == 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: | | {{#cargo_query: |
| tables=CollectionLocation | | tables=CollectionLocation |
| Line 10: |
Line 23: |
| DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days, | | DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days, |
| CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years | | CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years |
| | |where=EndDate IS NOT NULL |
| |order by=unit | | |order by=unit |
| |limit=100 | | |limit=100 |
| Line 15: |
Line 29: |
| }} | | }} |
|
| |
|
| * {{Location Age | Location =GRA EMIP }}
| | == Wiki == |
| | | * the first account on this wiki was set up 2008-03-11 |
| == old ==
| |
| * {{Location Age | Location =GRA MICU }}
| |
| * {{Location Age | Location =GRA N3 }}
| |
| * {{Location Age | Location =GRA N5 }}
| |
| * {{Location Age | Location =GRA OVER}}
| |
| * {{Location Age | Location =GRA W3 }}
| |
| * {{Location Age | Location =HSC A4 }}
| |
| * {{Location Age | Location =HSC B3 }}
| |
| * {{Location Age | Location =HSC CCU }}
| |
| * {{Location Age | Location =HSC D4 }}
| |
| * {{Location Age | Location =HSC WRS3 }}
| |
| * {{Location Age | Location =HSC D5 }}
| |
| * {{Location Age | Location =HSC H4 }}
| |
| * {{Location Age | Location =HSC H4H }}
| |
| * {{Location Age | Location =HSC IICU }}
| |
| * {{Location Age | Location =HSC MICU }}
| |
| * {{Location Age | Location =HSC SICU }}
| |
| * {{Location Age | Location =HSC EMIP }}
| |
| * {{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 B }}
| |
| * {{Location Age | Location =STB MICU }}
| |
| * {{Location Age | Location =STB SICU }}
| |
| * {{Location Age | Location =STB EMIP }}
| |
| | |
| ==Ended==
| |
| * [[VIC MICU]] - '''18 yrs 3 mths''' - (1999-Jun-01 to 2017-Sep 25)
| |
| * [[VIC N3F]]- '''1 year''' - (2005-Jul-01 to 2006-Jun-30)
| |
| * [[VIC N4]] - '''3.5 mths''' - (2017-Sep-29 to 2018-Jan-12)
| |
| * [[VIC N5]] - '''12 yrs 2 mths''' - (2005-Aug-01 to 2017-Oct-01)
| |
| * [[VIC S3]] - '''12 yrs''' - (2005-Oct-01 to 2017-Sep-22)
| |
| * [[VIC S4]] - '''12 yrs''' - (2005-Oct-01 to 2017-Oct-01)
| |
| * {{Location Age | Location =VIC EMIP }}
| |
| * {{Location Age | Location =VIC S5 }}
| |
| * [[VIC N5C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27)) | |
| * [[VIC S5C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27))
| |
| * [[VIC N4C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27))
| |
|
| |
|
| == Related articles == | | == Related articles == |