Template:PrintIncludedServicesUpgradeStrat - Revision history

WikiSysop at 07:45, July 14, 2022

2022-07-14T07:45:45Z

WikiSysop at 12:15, July 6, 2022

2022-07-06T12:15:46Z

WikiSysop at 13:45, June 22, 2022

2022-06-22T13:45:44Z

WikiSysop at 10:30, June 21, 2022

2022-06-21T10:30:54Z

WikiSysop at 09:30, June 21, 2022

2022-06-21T09:30:43Z

WikiSysop at 09:15, June 21, 2022

2022-06-21T09:15:43Z

WikiSysop at 09:00, June 21, 2022

2022-06-21T09:00:46Z

WikiSysop at 07:15, June 21, 2022

2022-06-21T07:15:41Z

WikiSysop at 06:45, June 21, 2022

2022-06-21T06:45:42Z

WikiSysop at 06:34, June 21, 2022

2022-06-21T06:34:32Z

@@ Line 10: / Line 10: @@
 </td>
 </td>
-<td>
+<td style="text-align:center;">
 	{{#cargo_query:
 		tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
@@ Line 25: / Line 25: @@
 	}}
 </td>
-<td>
+<td style="text-align:center;">
 	{{#cargo_query:
 		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
@@ Line 42: / Line 42: @@
 	}}
 </td>
-<td>
+<td style="text-align:center;">
 	{{#cargo_query:
 		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService

@@ Line 1: / Line 1: @@
 <tr>
 <td style="white-space: nowrap;">&nbsp;&nbsp;&mdash; {{{Included Service|}}}
@@ Line 4: / Line 11: @@
 </td>
 <td>
-{{#cargo_query:
+	{{#cargo_query:
-tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
+		tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
+		|join on=
-|fields=IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('&#10003;'),CONCAT(''))
+			ArticlePEServiceUpgrade.ServiceId=Service.Id,
-|where=IncludedServiceUpgradeStrategy.IncludedServiceId="{{{IncludedServiceId|}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+			ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,
-}}
+			IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
 </td>
 <td>
-{{#cargo_query:
+	{{#cargo_query:
-tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
+		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
+		|join on=
-|fields=IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('&#10003;'),CONCAT(''))
+			ArticlePEServiceUpgrade.ServiceId=Service.Id,
-|where=IncludedServiceUpgradeStrategy.IncludedServiceId="{{{IncludedServiceId|}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+			ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,
-}}
+			ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,
 </td>
 <td>
-{{#cargo_query:
+	{{#cargo_query:
-tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
+		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy,IncludedServiceUpgradeStrategy,IncludedService
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
+		|join on=
-|fields=IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%d58cea3b-ff08-4fad-8b9d-7579b4145ba8%",CONCAT('&#10003;'),CONCAT(''))
+			ArticlePEServiceUpgrade.ServiceId=Service.Id,
-|where=IncludedServiceUpgradeStrategy.IncludedServiceId="{{{IncludedServiceId|}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+			ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,
-}}
+			ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,
 </td>
 </td>

@@ Line 27: / Line 27: @@
 }}
 </td>
-</tr>
+</td>

@@ Line 1: / Line 1: @@
 <tr>
-<td>{{{Included Service|}}}
+<td style="white-space: nowrap;">&nbsp;&nbsp;&mdash; {{{Included Service|}}}
 </td>
 <td>

@@ Line 26: / Line 26: @@
 }}
 </td>
-</td>
+</tr>

@@ Line 13: / Line 13: @@
 |join on=IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
 |fields=IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%40f069a2-01ae-4027-9aef-13f54bc53613%",CONCAT('&#10003;'),CONCAT(''))
-|where=IncludedService.ServiceId="{{{ServiceId|}}}" AND IncludedService.Name="{{{Included Service|}}}"
+|where=IncludedServiceUpgradeStrategy.IncludedServiceId="{{{IncludedServiceId|}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=IncludedServiceUpgradeStrategy._pageName LIKE "Draft:%%"|#default=IncludedServiceUpgradeStrategy._pageName NOT LIKE "Draft:%%"}}
 }}
 </td>
@@ Line 21: / Line 21: @@
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName,IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
 |fields=IF(IncludedServiceUpgradeStrategy.IncludedServiceUpgradeStrategy LIKE "%adcd5516-e0cf-4525-a74e-1467389675c9%",CONCAT('&#10003;'),CONCAT(''))
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId|}}}" AND ArticlePEServiceUpgrade._pageName="{{NAMESPACENUMBER}}"
+|where=IncludedServiceUpgradeStrategy.IncludedServiceId="{{{IncludedServiceId|}}}"
 }}
 </td>