Template:GetContainers - Revision history

Bgrenon: 1 revision imported

2022-05-25T20:29:05Z

1 revision imported

WikiSysop at 20:15, May 25, 2022

2022-05-25T20:15:47Z

production>Bgrenon: (by SublimeText.Mediawiker)

2022-05-20T18:02:29Z

(by SublimeText.Mediawiker)

Bgrenon at 20:11, April 29, 2022

2022-04-29T20:11:07Z

WikiSysop at 14:45, April 28, 2022

2022-04-28T14:45:44Z

Bgrenon: Adding PrivateEdition category

2022-04-20T12:16:30Z

Adding PrivateEdition category

Bgrenon at 11:39, April 20, 2022

2022-04-20T11:39:13Z

Bgrenon at 19:07, April 12, 2022

2022-04-12T19:07:00Z

Bgrenon at 15:01, April 12, 2022

2022-04-12T15:01:47Z

Bgrenon at 00:46, April 12, 2022

2022-04-12T00:46:17Z

@@ Line 10: / Line 10: @@
 ComponentRN.ComponentId="{{{ComponentId|}}}"
 AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
-AND ComponentRN._pageNamespace="0"
+AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 }}
 </td>
@@ Line 21: / Line 21: @@
 ComponentRN.ComponentId="{{{ComponentId|}}}"
 AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
-AND ComponentRN._pageNamespace="0"
+AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 }}
 </td>
@@ Line 38: / Line 38: @@
 |where=
 ComponentRN.ComponentId="{{{ComponentId|}}}"
-AND ArticleCloudRN._pageNamespace="0"
+AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
 AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
 |group by=ComponentRN.ComponentId
@@ Line 64: / Line 64: @@
 AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
 AND Type="helm"
-AND ComponentRN._pageNamespace="0"
+AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 |default=
       {{#cargo_query:tables=ComponentRN
@@ Line 71: / Line 71: @@
        ComponentRN.ComponentId="{{{ComponentId|}}}"
        AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
-       AND ComponentRN._pageNamespace="0"
+       AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
        AND Containers IS NOT NULL
       |format=template
@@ Line 84: / Line 84: @@
             |where=
              Component.Id = "{{{ComponentId|}}}"
-             AND ArticleHelmRN._pageNamespace="0"
+             AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
             |delimiter=
             |default=N/A
@@ Line 100: / Line 100: @@
 |group by=RNElements.Version,RNElements.Filename
 |format=ul
-|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="0"
+|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 |default=
          {{#cargo_query:tables=ComponentRN
          |fields=Containers
-         |where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
+         |where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" AND Containers IS NOT NULL
          |format=template
          |template=ArrayMapDocker
@@ Line 112: / Line 112: @@
                |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
                |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
-               |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="0"
+               |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
                |delimiter=
                |default=N/A

@@ Line 1: / Line 1: @@
 <includeonly><tr>
 <td><!-- get component name -->
-{{#cargo_query:
+{{#cargo_query:tables=
-tables=ComponentRN,Component
+ComponentRN,
-|join on=ComponentRN.ComponentId HOLDS Component.Id
+Component
 |fields=Component.Name
 |group by=Name
-|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+|where=
 }}
 </td>
 <td><!-- get release number -->
-{{#cargo_query:
+{{#cargo_query:tables=
-tables=ComponentRN
+ComponentRN
-|fields=MAX(ReleaseNumber)
+|fields=
-|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+MAX(ReleaseNumber)
 }}
 </td>
 <td><!-- get release date and format as link to ArticleCloudRN page -->
-{{#cargo_query:
+{{#cargo_query:tables=
-tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN
+ArticleCloudRN__ComponentId,
-|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID
+ArticleCloudRN,
-|fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y'),']]')
+ComponentRN,
-|where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
+Component
 |group by=ComponentRN.ComponentId
 }}
@@ Line 27: / Line 45: @@
 <td>
 <!-- finding helm from RNElements with default to manual containers list from ComponentRN -->
-{{#cargo_query:tables=ComponentRN,Component,RNElements
+{{#cargo_query:tables=
-|join on=ComponentRN.ComponentId HOLDS Component.Id,Component.IpName=RNElements.IpName
+ComponentRN,
-|fields=RNElements.Filename
+Component,
-|having=MAX(ComponentRN.ReleaseNumber)=RNElements.Version
+RNElements
-|group by=RNElements.Version,RNElements.Filename
+|join on=
-|format=ul
+ComponentRN.ComponentId=Component.Id,
-|where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="helm" AND ComponentRN._pageNamespace="0"
+Component.IpName=RNElements.IpName
 |default=
       {{#cargo_query:tables=ComponentRN
       |fields=Containers
-      |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
+      |where=
       |format=template
       |template=ArrayMapHelm
       |default=
             {{#cargo_query:
-            tables=ArticleHelmRN,Component
+            tables=
             |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
             |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
-            |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="0"
+            |where=
             |delimiter=
             |default=N/A
@@ Line 56: / Line 95: @@
 <!-- finding containers from RNElements with default to manual containers list from ComponentRN -->
 {{#cargo_query:tables=ComponentRN,Component,RNElements
-|join on=ComponentRN.ComponentId HOLDS Component.Id,Component.IpName=RNElements.IpName
+|join on=ComponentRN.ComponentId=Component.Id,Component.IpName=RNElements.IpName
 |fields=RNElements.Filename
 |having=MAX(ComponentRN.ReleaseNumber)=RNElements.Version
 |group by=RNElements.Version,RNElements.Filename
 |format=ul
-|where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="0"
+|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="0"
 |default=
          {{#cargo_query:tables=ComponentRN
          |fields=Containers
-         |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
+         |where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
          |format=template
          |template=ArrayMapDocker
@@ Line 81: / Line 120: @@
 }}
 </td>
-</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>
+</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

@@ Line 44: / Line 44: @@
             tables=ArticleHelmRN,Component
             |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
-            |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]')
+            |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
             |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="0"
             |delimiter=
@@ Line 72: / Line 72: @@
                tables=ArticleHelmRN,Component
                |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
-               |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]')
+               |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
                |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="0"
                |delimiter=

@@ Line 34: / Line 34: @@
 |format=ul
 |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="helm" AND ComponentRN._pageNamespace="0"
-|default={{#cargo_query:tables=ComponentRN
+|default=
-|fields=Containers
+     {{#cargo_query:tables=ComponentRN
-|where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
+     |fields=Containers
-|format=template
+     |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
-|template=ArrayMapHelm
+     |format=template
-|default=N/A
+     |template=ArrayMapHelm
-}}
+     |default=
 }}
 </td>
@@ Line 52: / Line 62: @@
 |format=ul
 |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="0"
-|default={{#cargo_query:tables=ComponentRN
+|default=
-|fields=Containers
+        {{#cargo_query:tables=ComponentRN
-|where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
+        |fields=Containers
-|format=template
+        |where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL
-|template=ArrayMapDocker
+        |format=template
-|default=N/A
+        |template=ArrayMapDocker
-}}
+        |default=
 }}
 </td>
 </tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 1: / Line 1: @@
-<tr>
+<includeonly><tr>
 <td><!-- get component name -->
 {{#cargo_query:
@@ Line 61: / Line 61: @@
 }}
 </td>
-</tr>
+</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>

← Older revision	Revision as of 20:29, May 25, 2022
(No difference)