Difference between revisions of "Template: GetReleaseDetails"

From Genesys Documentation
Jump to: navigation, search
m (1 revision imported)
(PUBSWIKI-2672 - removed GCP icon td)
 
(9 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
<td><!-- get component name -->
 
<td><!-- get component name -->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ComponentRN,
+
tables=ComponentRN,Component
−
Component
+
|join on=ComponentRN.ComponentId=Component.Id
−
|join on=ComponentRN.ComponentId=Component.Id
+
|fields=Component.Name
−
|fields=Component.Name
+
|group by=Name
−
|group by=Name
+
|where=
−
|where=
+
ComponentId="{{{ComponentId|}}}"
−
ComponentId="{{{ComponentId|}}}"
+
AND ReleaseDate="{{{ReleaseDate|}}}"
−
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=
+
|where=
−
ComponentId="{{{ComponentId|}}}"
+
ComponentId="{{{ComponentId|}}}"
−
AND ReleaseDate="{{{ReleaseDate|}}}"
+
AND ReleaseDate="{{{ReleaseDate|}}}"
 
}}
 
}}
 
</td>
 
</td>
Line 25: Line 24:
 
IMPORTANT: this query uses hard-coded uuids-->
 
IMPORTANT: this query uses hard-coded uuids-->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=
+
tables=
−
ArticleCloudRN__ComponentId,
+
ArticleCloudRN__ComponentId,
−
ArticleCloudRN,
+
ArticleCloudRN,
−
ComponentRN,
+
ComponentRN,
−
Component
+
Component
−
|join on=
+
|join on=
−
ArticleCloudRN__ComponentId._value=Component.Id,
+
ArticleCloudRN__ComponentId._value=Component.Id,
−
ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
+
ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
−
ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId,
+
ArticleCloudRN__ComponentId._value = ComponentRN.ComponentId,
−
ComponentRN.ComponentId=Component.Id
+
ComponentRN.ComponentId=Component.Id
−
|fields=
+
|fields=
−
CONCAT
+
CONCAT
−
(
+
(
−
'[[',ArticleCloudRN._pageName,'#',Component.Name,'-',ReleaseNumber,'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]'
+
'[[',ArticleCloudRN._pageName,'#',Component.Name,'-',ReleaseNumber,'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]'
−
)
+
)
−
|where=
+
|where=
−
ComponentRN.ComponentId="{{{ComponentId|}}}"  
+
ArticleCloudRN._pageName NOT LIKE "%/Internal%"
−
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"  
+
                AND ComponentRN.ComponentId="{{{ComponentId|}}}"  
−
AND ReleaseDate="{{{ReleaseDate|}}}"  
+
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"  
−
AND (
+
AND ReleaseDate="{{{ReleaseDate|}}}"  
−
DeploymentTypeId HOLDS NOT '8b480b3c-2733-433a-9166-eab2c2d0663a'  
+
AND (
−
OR DeploymentTypeId HOLDS NOT '577e188b-36c5-4733-86a7-e1d0d6564aff'
+
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=
+
table=ComponentRN,DeploymentType
−
ComponentRN,
+
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
−
DeploymentType
+
|intro=<div style="margin: -10px 0 -10px 0">
−
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
|outro=</div>
−
|intro=<div style="margin: -10px 0 -10px 0">
+
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
−
|outro=</div>
+
|delimiter=
−
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+
|where=
−
|delimiter=
+
ComponentId="{{{ComponentId|}}}"  
−
|where=
+
AND ReleaseDate="{{{ReleaseDate|}}}"  
−
ComponentId="{{{ComponentId|}}}"  
+
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
−
AND ReleaseDate="{{{ReleaseDate|}}}"  
+
AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
−
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
+
|default=
−
AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
 
−
|default=
 
 
}}
 
}}
−
</td>
+
</td><!--  
−
<td>
+
 
−
<!-- get Azure icons for relevant release  -->
+
get Azure icons for relevant release   
−
{{#cargo_query:
+
 
−
table=ComponentRN,DeploymentType
+
--><td>
−
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
 
−
|intro=<div style="margin: -10px 0 -10px 0">
 
−
|outro=</div>
 
−
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
 
−
|delimiter=
 
−
|where=
 
−
ComponentId="{{{ComponentId|}}}"
 
−
AND ReleaseDate="{{{ReleaseDate|}}}"
 
−
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 
−
AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
 
−
|default=
 
−
}}
 
−
</td>
 
−
<!-- get GCP icons for relevant release  -->
 
−
<td>
 
 
{{#cargo_query:
 
{{#cargo_query:
−
table=ComponentRN,DeploymentType
+
table=
−
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
+
ComponentRN,
−
|intro=<div style="margin: -10px 0 -10px 0">
+
DeploymentType
−
|outro=</div>
+
|join on=ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id
−
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
+
|intro=<div style="margin: -10px 0 -10px 0">
−
|delimiter=
+
|outro=</div>
−
|where=
+
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
−
ComponentId="{{{ComponentId|}}}"  
+
|delimiter=
−
AND ReleaseDate="{{{ReleaseDate|}}}"  
+
|where=
−
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
+
ComponentId="{{{ComponentId|}}}"  
−
AND DeploymentType.Id="0cffec00-9053-4406-88d7-461255f48f53"
+
AND ReleaseDate="{{{ReleaseDate|}}}"  
−
|default=
+
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=
+
|where=
−
ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
+
ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"  
−
AND ComponentId="{{{ComponentId|}}}"
+
AND ComponentId="{{{ComponentId|}}}"
−
AND ReleaseDate="{{{ReleaseDate|}}}"  
+
AND ReleaseDate="{{{ReleaseDate|}}}"  
−
AND HighlightBoilerplateId IS NOT NULL
+
|default=
−
|default=
 
 
}}<!-- get Highlight from each release -->{{#cargo_query:
 
}}<!-- get Highlight from each release -->{{#cargo_query:
−
tables=ComponentRN
+
tables=ComponentRN
−
|fields=Highlight
+
|fields=Highlight
−
|where=
+
|where=
−
ComponentId="{{{ComponentId|}}}"
+
ComponentId="{{{ComponentId|}}}"
−
AND ReleaseDate="{{{ReleaseDate|}}}"  
+
AND ReleaseDate="{{{ReleaseDate|}}}"  
−
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
+
AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
−
|default=
+
|default=
 
}}
 
}}
 
</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</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 (2025-06-19 03:50:38)"