Difference between revisions of "Template: GetReleaseDetails"

From Genesys Documentation
Jump to: navigation, search
(PUBSWIKI-2672 - removed GCP icon td)
 
(15 intermediate revisions by 3 users not shown)
Line 2: Line 2:
 
<td><!-- get component name -->
 
<td><!-- get component name -->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ComponentRN,Component
+
tables=ComponentRN,Component
−
|join on=ComponentRN.ComponentId HOLDS Component.Id
+
|join on=ComponentRN.ComponentId=Component.Id
−
|fields=Component.Name
+
|fields=Component.Name
−
|group by=Name
+
|group by=Name
−
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}"
+
|where=
 +
ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"
 
}}
 
}}
 
</td>
 
</td>
 
<td><!-- get release number -->
 
<td><!-- get release number -->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ComponentRN
+
tables=ComponentRN
−
|fields=MAX(ReleaseNumber)
+
|fields=MAX(ReleaseNumber)
−
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}"
+
|where=
 +
ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"
 
}}
 
}}
 
</td>
 
</td>
−
<td><!-- get release date and format as link to ArticleCloudRN page -->
+
<td><!-- get release date and format as link to ArticleCloudRN page  
 +
 
 +
IMPORTANT: this query uses hard-coded uuids-->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN
+
tables=
−
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID
+
ArticleCloudRN__ComponentId,
−
|fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]')
+
ArticleCloudRN,
−
|where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND ReleaseDate="{{{ReleaseDate|}}}" AND (DeploymentTypeId HOLDS NOT '8b480b3c-2733-433a-9166-eab2c2d0663a' OR DeploymentTypeId HOLDS NOT '577e188b-36c5-4733-86a7-e1d0d6564aff')
+
ComponentRN,
−
|group by=ComponentRN.ComponentId
+
Component
 +
|join on=
 +
ArticleCloudRN__ComponentId._value=Component.Id,
 +
ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
 +
ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId,
 +
ComponentRN.ComponentId=Component.Id
 +
|fields=
 +
CONCAT
 +
(
 +
'[[',ArticleCloudRN._pageName,'#',Component.Name,'-',ReleaseNumber,'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]'
 +
)
 +
|where=
 +
ArticleCloudRN._pageName NOT LIKE "%/Internal%"
 +
                AND ComponentRN.ComponentId="{{{ComponentId|}}}"  
 +
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"  
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND (
 +
DeploymentTypeId HOLDS NOT '8b480b3c-2733-433a-9166-eab2c2d0663a'  
 +
OR DeploymentTypeId HOLDS NOT '577e188b-36c5-4733-86a7-e1d0d6564aff'
 +
)
 
}}
 
}}
−
</td>
+
</td><!--  
−
<td>
+
 
−
<!-- get AWS icons for relevant release  -->
+
get AWS icons for relevant release   
 +
 
 +
--><td>
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ComponentRN,DeploymentType
 
table=ComponentRN,DeploymentType
Line 34: Line 61:
 
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
 
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
 
|delimiter=
 
|delimiter=
−
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
+
|where=
−
        |default=
+
ComponentId="{{{ComponentId|}}}"  
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
 +
AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
 +
|default=
 
}}
 
}}
−
</td>
+
</td><!--  
−
<td>
+
 
−
<!-- get Azure icons for relevant release  -->
+
get Azure icons for relevant release   
 +
 
 +
--><td>
 
{{#cargo_query:
 
{{#cargo_query:
−
table=ComponentRN,DeploymentType
+
table=
 +
ComponentRN,
 +
DeploymentType
 
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
 
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
 
|intro=<div style="margin: -10px 0 -10px 0">
 
|intro=<div style="margin: -10px 0 -10px 0">
Line 47: Line 82:
 
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
 
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
 
|delimiter=
 
|delimiter=
−
|where=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
+
|where=
−
        |default=
+
ComponentId="{{{ComponentId|}}}"  
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
 +
AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
 +
|default=
 
}}
 
}}
 
</td>
 
</td>
 
<td>
 
<td>
 
<!-- get HighlightBoilerplateId and send to formatting template -->{{#cargo_query:
 
<!-- get HighlightBoilerplateId and send to formatting template -->{{#cargo_query:
−
tables=ComponentRN
+
tables=ComponentRN
−
|fields=HighlightBoilerplateId
+
|fields=HighlightBoilerplateId,ReleaseNumber,ComponentId
−
|format=template
+
|format=template
−
|template=PrintHighlightBoilerplate
+
|template=PrintHighlightBoilerplate
−
|named args=yes
+
|named args=yes
−
|where=ComponentRN._pageNamespace="0" AND ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND HighlightBoilerplateId IS NOT NULL
+
|where=
−
|default=
+
ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
 +
AND ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
|default=
 
}}<!-- get Highlight from each release -->{{#cargo_query:
 
}}<!-- get Highlight from each release -->{{#cargo_query:
−
tables=ComponentRN
+
tables=ComponentRN
−
|fields=Highlight
+
|fields=Highlight
−
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+
|where=
−
|default=
+
ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 +
|default=
 
}}
 
}}
−
</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>
+
</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

Latest revision as of 05:51, December 21, 2022

Retrieved from "https://all.docs.genesys.com/Template:GetReleaseDetails (2024-11-09 10:33:33)"