Template:PrintServiceHA - Revision history

WikiSysop at 12:15, June 28, 2022

2022-06-28T12:15:53Z

2021-11-29T13:40:05Z

2021-11-23T22:14:28Z

2021-11-23T18:53:26Z

2021-09-23T14:28:02Z

Update package: PrivateEdition

2021-09-09T16:07:03Z

2021-09-09T16:03:59Z

2021-09-09T16:03:30Z

2021-09-08T19:29:36Z

Install package: PrivateEdition

2021-06-11T01:17:45Z

@@ Line 1: / Line 1: @@
-''This information is under development: Flagged {{SuperscriptFlag}} items aren't yet confirmed or have info coming soon; Checked {{SuperscriptCheck}} items are valid.''
+{{#switch:{{NAMESPACENUMBER}}|620=
 ''Flagged {{SuperscriptFlag}} items aren't yet confirmed or have info coming soon; Checked {{SuperscriptCheck}} items are valid.''
 {{#cargo_query:
 tables=ArticleServiceHA,Service

@@ Line 8: / Line 8: @@
 |outro=</table>
 |format=template
-|where=ArticleServiceHA._pageNamespace="{{NAMESPACENUMBER}}" <!--AND ArticleServiceHA.ServiceId IS NOT NULL-->
+|where=ArticleServiceHA._pageNamespace="{{NAMESPACENUMBER}}" AND ArticleServiceHA.ServiceId IS NOT NULL
 |named args=yes
 |template=PrintServicesHAFormat}}<noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 8: / Line 8: @@
 |outro=</table>
 |format=template
-|where=ArticleServiceHA._pageNamespace="{{NAMESPACENUMBER}}" AND ArticleServiceHA.ServiceId IS NOT NULL
+|where=ArticleServiceHA._pageNamespace="{{NAMESPACENUMBER}}" <!--AND ArticleServiceHA.ServiceId IS NOT NULL-->
 |named args=yes
 |template=PrintServicesHAFormat}}<noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 2: / Line 2: @@
 {{#cargo_query:
-tables=ServiceHA,Service
+tables=ArticleServiceHA,Service
-|join on=ServiceHA.ServiceID=Service.Id
+|join on=ArticleServiceHA.ServiceID=Service.Id
-|fields=CONCAT('[[',ServiceHA._pageName,'|',Service.Name,']]')=Service,HA,DR,NoHA,Notes,Service.Id=ServiceId,AddIncluded
+|fields=CONCAT('[[',ArticleServiceHA._pageName,'|',Service.Name,']]')=Service,HA,DR,NoHA,Notes,Service.Id=ServiceId,AddIncluded,PrimaryUnit
 |intro=<table class="sortable"><tr><th>Service & Included Services</th><th>High Availability</th><th>Disaster Recovery</th><th>Where can you host this service?</th></tr>
 |outro=</table>
 |format=template
-|where=ServiceHA._pageNamespace="{{NAMESPACENUMBER}}" AND ServiceHA.ServiceId IS NOT NULL
+|where=ArticleServiceHA._pageNamespace="{{NAMESPACENUMBER}}" AND ArticleServiceHA.ServiceId IS NOT NULL
 |named args=yes
 |template=PrintServicesHAFormat}}<noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 1: / Line 1: @@
 {{#cargo_query:
 tables=ServiceHA,Service
 |join on=ServiceHA.ServiceID=Service.Id
-|fields=CONCAT('[[',ServiceHA._pageName,'|',Service.Name,IF (NoHA = "Yes",'*',' '),']]')=Service,HA=High Availability,DR=Disaster Recovery,NoHA,Notes,Service.Id=ServiceId,AddIncluded
+|fields=CONCAT('[[',ServiceHA._pageName,'|',Service.Name,']]')=Service,HA,DR,NoHA,Notes,Service.Id=ServiceId,AddIncluded
-|intro=<table class="sortable"><tr><th>Service & Included Services</th><th>High Availability</th><th>Disaster Recovery</th></tr>
+|intro=<table class="sortable"><tr><th>Service & Included Services</th><th>High Availability</th><th>Disaster Recovery</th><th>Where can you host this service?</th></tr>
 |outro=</table>
 |format=template