User:Bgrenon/2 - Revision history

WikiSysop at 20:00, April 29, 2022

2022-04-29T20:00:44Z

Bgrenon at 19:52, April 29, 2022

2022-04-29T19:52:46Z

WikiSysop at 19:15, April 29, 2022

2022-04-29T19:15:40Z

Bgrenon at 18:08, April 29, 2022

2022-04-29T18:08:23Z

Bgrenon at 18:00, April 29, 2022

2022-04-29T18:00:01Z

Bgrenon at 17:58, April 29, 2022

2022-04-29T17:58:58Z

Bgrenon at 17:56, April 29, 2022

2022-04-29T17:56:07Z

Bgrenon at 15:25, April 29, 2022

2022-04-29T15:25:05Z

Bgrenon at 15:23, April 29, 2022

2022-04-29T15:23:51Z

Bgrenon at 15:22, April 29, 2022

2022-04-29T15:22:08Z

@@ Line 5: / Line 5: @@
 Released in last 7 days=
 {{#cargo_query:
-tables=ComponentRN,Component
+tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,DeploymentType,ComponentRN__ComponentId=CompId,Component
-|join on=ComponentRN.ComponentId HOLDS Component.Id
+|join on=ComponentRN._ID=DepId._rowID,DepId._value=DeploymentType.Id,DepId._rowID=CompId._rowID,CompId._value=Component.Id
-|fields=ComponentRN.ComponentId
+|fields=ComponentRN.ComponentId=ComponentId
 |group by=ComponentRN.ComponentId
 |format=template
@@ Line 13: / Line 13: @@
 |named args=yes
 |order by=Component.Name
-|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Released for</th><th>Highlights</th></tr>
+|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND DATEDIFF(ReleaseDate,NOW()) >= -7
+|where=ComponentRN._pageNamespace="0" AND DeploymentType.Hosted IS TRUE AND DATEDIFF(ReleaseDate,NOW()) >= -7
 }}
 |-|
-Releases in last 30 days=
+Released in last 30 days=
 {{#cargo_query:
-tables=ComponentRN,Component
+tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,DeploymentType,ComponentRN__ComponentId=CompId,Component
-|join on=ComponentRN.ComponentId HOLDS Component.Id
+|join on=ComponentRN._ID=DepId._rowID,DepId._value=DeploymentType.Id,DepId._rowID=CompId._rowID,CompId._value=Component.Id
-|fields=ComponentRN.ComponentId
+|fields=ComponentRN.ComponentId=ComponentId
 |group by=ComponentRN.ComponentId
 |format=template
@@ Line 28: / Line 28: @@
 |named args=yes
 |order by=Component.Name
-|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Released for</th><th>Highlights</th></tr>
+|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0" AND DATEDIFF(ReleaseDate,NOW()) >= -30
+|where=ComponentRN._pageNamespace="0" AND DeploymentType.Hosted IS TRUE AND DATEDIFF(ReleaseDate,NOW()) >= -30
 }}
 |-|
@@ Line 45: / Line 45: @@
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ComponentRN._pageNamespace="0" AND DeploymentType.Hosted IS TRUE <!--(DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')-->
+|where=ComponentRN._pageNamespace="0" AND DeploymentType.Hosted IS TRUE
 }}
 </tabber>

@@ Line 45: / Line 45: @@
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ComponentRN._pageName NOT LIKE "%Draft%" AND DeploymentType.Hosted IS TRUE <!--(DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')-->
+|where=ComponentRN._pageNamespace="0" AND DeploymentType.Hosted IS TRUE <!--(DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')-->
 }}
 </tabber>

@@ Line 35: / Line 35: @@
 Latest releases per service=
 {{#cargo_query:
-tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component
+tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,DeploymentType,ComponentRN__ComponentId=CompId,Component
-|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID,CompId._value=Component.Id
+|join on=ComponentRN._ID=DepId._rowID,DepId._value=DeploymentType.Id,DepId._rowID=CompId._rowID,CompId._value=Component.Id
-|fields=CompId._value=ComponentId
+|fields=ComponentRN.ComponentId=ComponentId
 |group by=ComponentRN.ComponentId
 |format=template
@@ Line 45: / Line 45: @@
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ComponentRN._pageName NOT LIKE "%Draft%" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')
+|where=ComponentRN._pageName NOT LIKE "%Draft%" AND DeploymentType.Hosted IS TRUE <!--(DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')-->
 }}
 </tabber>

@@ Line 45: / Line 45: @@
 |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Azure</th><th>AWS</th><th>Highlights</th></tr>
 |outro=</table>
-|where=ComponentRN._pageName NOT LIKE "%Draft%" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a') AND ReleaseDate IS NOT NULL
+|where=ComponentRN._pageName NOT LIKE "%Draft%" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a')
 }}
 </tabber>

@@ Line 3: / Line 3: @@
 <!-- finding all containers-->
 <tabber>
-Last 7 days=
+Released in last 7 days=
 {{#cargo_query:
 tables=ComponentRN,Component
@@ Line 18: / Line 18: @@
 }}
 |-|
-Last 30 days=
+Releases in last 30 days=
 {{#cargo_query:
 tables=ComponentRN,Component
@@ Line 33: / Line 33: @@
 }}
 |-|
-Latest helm and containers=
+Latest releases per service=
 {{#cargo_query:
 tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component

@@ Line 39: / Line 39: @@
 |fields=CompId._value=ComponentId,Component.Name
 |group by=ComponentRN.ComponentId
-|order by=Component.Name DESC
+|order by=Component.Name
 <!--|format=template
 |template=GetMaxReleaseDate