User:MPandian/UpgradeSummary - Revision history

WikiSysop at 20:45, June 13, 2022

2022-06-13T20:45:54Z

WikiSysop at 13:45, June 13, 2022

2022-06-13T13:45:48Z

WikiSysop at 14:16, June 1, 2022

2022-06-01T14:16:03Z

WikiSysop: Created page with "==Copy== {{#cargo_query: tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService |join on=ArticlePEServiceUpgrade.ServiceId=Servi..."

2022-06-01T14:01:08Z

Created page with "==Copy== {{#cargo_query: tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService |join on=ArticlePEServiceUpgrade.ServiceId=Servi..."

New page

==Copy==
{{#cargo_query:
tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',Service.Name,']]')=Service, CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',IncludedService.ShortName,']]')=Included Service,IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('✓'),CONCAT('')))=Rolling Update,IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('✓'),CONCAT('')))=Blue/Green,IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('✓'),CONCAT('')))=Canary
|where={{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
|format=table
}}
{{{!}} class="sortable"
!'''Service'''
!'''Included Service'''
!'''Rolling Update'''
!'''Blue/Green'''
!'''Canary'''
{{!}}-
{{!}}Designer
{{!}}DES
{{!}}✓
{{!}}✓
{{!}}✓
{{!}}-
{{!}}Designer
{{!}}DAS
{{!}}✓
{{!}}✓
{{!}}✓
{{!}}-
{{!}}Genesys Info Mart
{{!}}{{#cargo_query:
tables=Service,IncludedService
|join on=Service.Id=IncludedService.ServiceId
|fields=IncludedService.ShortName
|where=Service.Name="Genesys Info Mart"
|format=ul
}}
{{!}}✓
{{!}}
{{!}}
{{!}}-
{{!}}Event Stream
{{!}}
{{!}}✓
{{!}}
{{!}}
{{!}}-
{{!}}UCS
{{!}}
{{!}}✓
{{!}}
{{!}}
{{!}}}

@@ Line 3: / Line 3: @@
 tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
-|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',Service.Name,']]')=Service, CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',IncludedService.ShortName,']]')=Included Service,IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('&#10003;'),CONCAT('')))=Rolling Update,IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('&#10003;'),CONCAT('')))=Blue/Green,IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('&#10003;'),CONCAT('')))=Canary
+|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',Service.Name,']]')=Service, CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',IncludedService.Name,']]')=Included Service,IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('&#10003;'),CONCAT('')))=Rolling Update,IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('&#10003;'),CONCAT('')))=Blue/Green,IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('&#10003;'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('&#10003;'),CONCAT('')))=Canary
 |where={{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
 |format=table
@@ Line 15: / Line 15: @@
 {{!}}-
 {{!}}{{#if:{{{IncludedService|}}}|
-{{!}}colspan="5"{{!}}Designer
+|{{!}}Designer
 {{!}}-
 }}<!-- end of if-->
@@ Line 26: / Line 24: @@
 {{!}}&#10003;
 {{!}}-
-{{!}}Designer
+{{!}}
 {{!}}DAS
 {{!}}&#10003;

← Older revision		Revision as of 20:45, June 13, 2022
Line 54:		Line 54:
	{{!}}		{{!}}
	{{!}}}		{{!}}}
		+
		+	==The query we want (without a formatting template)==
		+	{{#cargo_query:
		+	tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
		+	\|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
		+	\|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'\|',Service.Name,']]')=Service, CONCAT('[[',ArticlePEServiceUpgrade._pageName,'\|',IncludedService.Name,']]')=Included Service,IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('✓'),CONCAT('')))=Rolling Update,IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('✓'),CONCAT('')))=Blue/Green,IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('✓'),CONCAT('')))=Canary
		+	\|where={{#switch:{{NAMESPACENUMBER}}\|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"\|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
		+	\|format=rortable table
		+	}}
		+
		+	==With a formatting template==
		+	{{#cargo_query:
		+	tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
		+	\|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
		+	\|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'\|',Service.Name,']]')=Service, CONCAT('[[',ArticlePEServiceUpgrade._pageName,'\|',IncludedService.Name,']]')=Included Service,IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('✓'),CONCAT('')))=Rolling Update,IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('✓'),CONCAT('')))=Blue/Green,IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('✓'),IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('✓'),CONCAT('')))=Canary
		+	\|where={{#switch:{{NAMESPACENUMBER}}\|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"\|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
		+	\|format=template
		+	\|template=UpgradeStratsFormat
		+	\|named args=yes
		+	}}