Template:EmbedPrintServices - Revision history

WikiSysop at 20:15, July 21, 2022

2022-07-21T20:15:59Z

2021-10-28T19:51:09Z

2021-10-19T17:00:58Z

2021-08-26T21:56:16Z

2021-08-17T20:40:14Z

2021-08-11T19:39:39Z

2021-08-11T19:39:18Z

2021-08-11T19:25:39Z

2021-08-11T18:56:27Z

2021-08-11T18:24:26Z

@@ Line 1: / Line 1: @@
-{{#cargo_query:tables=Service,MintyDocsManual
+<!--
-|join on=MintyDocsManual.ServiceId=Service.Id
-|fields=Service.Id=ServiceId,CONCAT ('[[',MintyDocsManual._pageName,'|',Service.Name,']]')=Service
+	finding information for each service
-|intro=<table class="sortable"><tr><th>Service</th><th>Included Services</th></tr>
-|outro=</table>
+-->{{#cargo_query:
-|where=MintyDocsManual.ServiceId IS NOT NULL AND MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"
+	tables=Service
-|format=template
+	|fields=
-|template=PrintServices2
+		Service.Id=ServiceId,
-|group by=Service.Id
+		IF (workspace_id IS NULL, Service.Name, CONCAT('[[',workspace_id,'|',Service.Name,']]'))=Service
-|order by=Service.Name
+	|intro=<table class="sortable">
-|named args=yes}}<noinclude>[[Category:PrivateEdition]]</noinclude>
+			<tr>

@@ Line 1: / Line 1: @@
-{{#cargo_query:tables=Service,ServiceGroup,MintyDocsManual
+{{#cargo_query:tables=Service,MintyDocsManual
-|join on=Service.ServiceGroupId=ServiceGroup.Id,MintyDocsManual.ServiceId=Service.Id
+|join on=MintyDocsManual.ServiceId=Service.Id
-|fields=Service.Id=ServiceId,ServiceGroup.Name=ServiceGroup,CONCAT ('[[',MintyDocsManual._pageName,'|',Service.Name,']]')=Service
+|fields=Service.Id=ServiceId,CONCAT ('[[',MintyDocsManual._pageName,'|',Service.Name,']]')=Service
-|intro=<table class="sortable"><tr><th>Service</th><th>Service group</th><th>Included Services</th></tr>
+|intro=<table class="sortable"><tr><th>Service</th><th>Included Services</th></tr>
 |outro=</table>
 |where=MintyDocsManual.ServiceId IS NOT NULL AND MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"

@@ Line 8: / Line 8: @@
 |template=PrintServices2
 |group by=Service.Id
 |named args=yes}}<noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 4: / Line 4: @@
 |intro=<table class="sortable"><tr><th>Service</th><th>Service group</th><th>Included Services</th></tr>
 |outro=</table>
-|where=MintyDocsManual.ServiceId IS NOT NULL
+|where=MintyDocsManual.ServiceId IS NOT NULL AND MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"
 |format=template
 |template=PrintServices2
 |group by=Service.Id
 |named args=yes}}<noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 1: / Line 1: @@
 {{#cargo_query:tables=Service,ServiceGroup,MintyDocsManual
 |join on=Service.ServiceGroupId=ServiceGroup.Id,MintyDocsManual.ServiceId=Service.Id
@@ Line 10: / Line 8: @@
 |template=PrintServices2
 |group by=Service.Id
-|named args=yes}}
+|named args=yes}}<noinclude>[[Category:PrivateEdition]]</noinclude>