Difference between revisions of "Template: GetContainers"

From Genesys Documentation
Jump to: navigation, search
m (1 revision imported)
 
(36 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<tr>
+
<includeonly><tr>
 
<td><!-- get component name -->
 
<td><!-- get component name -->
−
{{#cargo_query:
+
{{#cargo_query:tables=
−
tables=ComponentRN,Component
+
ComponentRN,
−
|join on=ComponentRN.ComponentId HOLDS Component.Id
+
Component
 +
|join on=ComponentRN.ComponentId=Component.Id
 
|fields=Component.Name
 
|fields=Component.Name
 
|group by=Name
 
|group by=Name
−
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+
|where=
 +
ComponentRN.ComponentId="{{{ComponentId|}}}"
 +
AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 
}}
 
}}
 
</td>
 
</td>
 
<td><!-- get release number -->
 
<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)
 +
|where=
 +
ComponentRN.ComponentId="{{{ComponentId|}}}"
 +
AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
}}
 +
</td>
 +
<td><!-- get release date and format as link to ArticleCloudRN page -->
 +
{{#cargo_query:tables=
 +
ArticleCloudRN__ComponentId,
 +
ArticleCloudRN,
 +
ComponentRN,
 +
Component
 +
|join on=
 +
ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
 +
ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId,
 +
ComponentRN.ComponentId=Component.Id
 +
|fields=
 +
CONCAT('[[',ArticleCloudRN._pageName,'#',Component.Name,'-',ReleaseNumber,'|',DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y'),']]')
 +
|where=
 +
ComponentRN.ComponentId="{{{ComponentId|}}}"
 +
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
 +
|group by=ComponentRN.ComponentId
 
}}
 
}}
 
</td>
 
</td>
 
<td>
 
<td>
−
{{#cargo_query:
+
<!-- finding helm from RNElements with default to manual containers list from ComponentRN -->
−
tables=ArticleCloudRN
+
{{#cargo_query:tables=
−
|fields=_pageName
+
ComponentRN,
−
|where=ArticleCloudRN.ComponentId HOLDS '{{{ComponentId|}}}' AND _pageNamespace="0"
+
Component,
−
}}{{#cargo_query:
+
RNElements
−
tables=ComponentRN
+
|join on=
−
|fields=DATE_FORMAT(PrivateEditionReleaseDate),'%M %d, %Y'
+
ComponentRN.ComponentId=Component.Id,
−
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+
Component.IpName=RNElements.IpName
 +
|fields=
 +
RNElements.Filename
 +
|having=
 +
MAX(ComponentRN.ReleaseNumber)=RNElements.Version
 +
|group by=
 +
RNElements.Version,RNElements.Filename
 +
|format=
 +
ul
 +
|where=
 +
ComponentRN.ComponentId="{{{ComponentId|}}}"
 +
AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"
 +
AND Type="helm"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
|default=
 +
    {{#cargo_query:tables=ComponentRN
 +
    |fields=Containers
 +
    |where=
 +
      ComponentRN.ComponentId="{{{ComponentId|}}}"
 +
      AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}"  
 +
      AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
 +
      AND Containers IS NOT NULL
 +
    |format=template
 +
    |template=ArrayMapHelm
 +
    |default=
 +
          {{#cargo_query:
 +
          tables=
 +
            ArticleHelmRN,
 +
            Component
 +
          |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
 +
          |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
 +
          |where=
 +
            Component.Id = "{{{ComponentId|}}}"
 +
            AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
          |delimiter=
 +
          |default=N/A
 +
          |group by=ArticleHelmRN._pageName,Component.Name
 +
          }}
 +
    }}
 
}}
 
}}
 
</td>
 
</td>
 
<td>
 
<td>
 +
<!-- finding containers from RNElements with default to manual containers list from ComponentRN -->
 
{{#cargo_query:tables=ComponentRN,Component,RNElements
 
{{#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
 
|fields=RNElements.Filename
 
|having=MAX(ComponentRN.ReleaseNumber)=RNElements.Version
 
|having=MAX(ComponentRN.ReleaseNumber)=RNElements.Version
 
|group by=RNElements.Version,RNElements.Filename
 
|group by=RNElements.Version,RNElements.Filename
 
|format=ul
 
|format=ul
−
|where=ComponentRN.ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="helm" 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="{{NAMESPACENUMBER}}" AND Containers IS NOT NULL
 +
        |format=template
 +
        |template=ArrayMapDocker
 +
        |default=
 +
              {{#cargo_query:
 +
              tables=ArticleHelmRN,Component
 +
              |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
 +
              |fields=CONCAT('See [[',ArticleHelmRN._pageName,'|parent]]*')
 +
              |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
              |delimiter=
 +
              |default=N/A
 +
              |group by=ArticleHelmRN._pageName,Component.Name
 +
              }}
 +
        }}
 
}}
 
}}
−
 
−
<!-- add in to switch to manual list of containers by default
 
−
|default={{#arraymap:{{{Containers|}}}|*|x|{{#switch:{{#sub:x|-3|}}|tgz=*x{{#switch:{{NAMESPACENUMBER}}|620={{SuperscriptFlag}}|#default=}}|#default=}}|\n }} -->
 
 
</td>
 
</td>
−
<tr>
+
</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

Latest revision as of 20:29, May 25, 2022

Retrieved from "https://all.docs.genesys.com/Template:GetContainers (2025-06-19 12:09:48)"