Difference between revisions of "Template: GetContainers"

From Genesys Documentation
Jump to: navigation, search
m (1 revision imported)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
<includeonly><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>
 
<td><!-- get release date and format as link to ArticleCloudRN page -->
 
<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
 +
|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
 
|group by=ComponentRN.ComponentId
 
}}
 
}}
Line 27: Line 45:
 
<td>
 
<td>
 
<!-- finding helm from RNElements with default to manual containers list from ComponentRN -->
 
<!-- 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
 +
|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=
 
|default=
 
     {{#cargo_query:tables=ComponentRN
 
     {{#cargo_query:tables=ComponentRN
 
     |fields=Containers
 
     |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="{{NAMESPACENUMBER}}"  
 +
      AND Containers IS NOT NULL
 
     |format=template
 
     |format=template
 
     |template=ArrayMapHelm
 
     |template=ArrayMapHelm
 
     |default=
 
     |default=
 
           {{#cargo_query:  
 
           {{#cargo_query:  
−
           tables=ArticleHelmRN,Component
+
           tables=
 +
            ArticleHelmRN,
 +
            Component
 
           |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
 
           |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"
+
           |where=
 +
            Component.Id = "{{{ComponentId|}}}"  
 +
            AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
 
           |delimiter=  
 
           |delimiter=  
 
           |default=N/A
 
           |default=N/A
Line 56: Line 95:
 
<!-- finding containers from RNElements with default to manual containers list from ComponentRN -->
 
<!-- 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="docker" AND ComponentRN._pageNamespace="0"
+
|where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 
|default=
 
|default=
 
         {{#cargo_query:tables=ComponentRN
 
         {{#cargo_query:tables=ComponentRN
 
         |fields=Containers
 
         |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="{{NAMESPACENUMBER}}" AND Containers IS NOT NULL
 
         |format=template
 
         |format=template
 
         |template=ArrayMapDocker
 
         |template=ArrayMapDocker
Line 73: Line 112:
 
               |join on=ArticleHelmRN.ComponentId HOLDS Component.ParentComponentId
 
               |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"
+
               |where=Component.Id = "{{{ComponentId|}}}" AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
 
               |delimiter=  
 
               |delimiter=  
 
               |default=N/A
 
               |default=N/A
Line 81: Line 120:
 
}}
 
}}
 
</td>
 
</td>
−
</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>
+
</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 13:49:01)"