Difference between revisions of "Template: GetContainers"
From Genesys Documentation
production>Bgrenon ((by SublimeText.Mediawiker)) |
|||
| 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 | + | Component |
| + | |join on=ComponentRN.ComponentId=Component.Id | ||
|fields=Component.Name | |fields=Component.Name | ||
|group by=Name | |group by=Name | ||
| − | |where=ComponentId | + | |where= |
| + | ComponentRN.ComponentId="{{{ComponentId|}}}" | ||
| + | AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" | ||
| + | AND ComponentRN._pageNamespace="0" | ||
}} | }} | ||
</td> | </td> | ||
<td><!-- get release number --> | <td><!-- get release number --> | ||
| − | {{#cargo_query: | + | {{#cargo_query:tables= |
| − | tables=ComponentRN | + | ComponentRN |
| − | |fields=MAX(ReleaseNumber) | + | |fields= |
| − | |where=ComponentId | + | MAX(ReleaseNumber) |
| + | |where= | ||
| + | ComponentRN.ComponentId="{{{ComponentId|}}}" | ||
| + | AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" | ||
| + | AND ComponentRN._pageNamespace="0" | ||
}} | }} | ||
</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 | + | ArticleCloudRN__ComponentId, |
| − | |join on= | + | ArticleCloudRN, |
| − | |fields=CONCAT('[[',ArticleCloudRN._pageName,'#', | + | ComponentRN, |
| − | |where= | + | 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="0" | ||
| + | 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 | + | 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 | + | 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="0" | ||
|default= | |default= | ||
{{#cargo_query:tables=ComponentRN | {{#cargo_query:tables=ComponentRN | ||
|fields=Containers | |fields=Containers | ||
| − | |where=ComponentRN.ComponentId | + | |where= |
| + | ComponentRN.ComponentId="{{{ComponentId|}}}" | ||
| + | AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" | ||
| + | AND ComponentRN._pageNamespace="0" | ||
| + | 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="0" | ||
|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 | + | |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 | + | |where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND Type="docker" AND ComponentRN._pageNamespace="0" |
|default= | |default= | ||
{{#cargo_query:tables=ComponentRN | {{#cargo_query:tables=ComponentRN | ||
|fields=Containers | |fields=Containers | ||
| − | |where=ComponentRN.ComponentId | + | |where=ComponentRN.ComponentId="{{{ComponentId|}}}" AND PrivateEditionReleaseDate="{{{PrivateEditionReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND Containers IS NOT NULL |
|format=template | |format=template | ||
|template=ArrayMapDocker | |template=ArrayMapDocker | ||
| Line 81: | Line 120: | ||
}} | }} | ||
</td> | </td> | ||
| − | </tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude> | + | </tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> |