Difference between revisions of "Template: GetReleaseDetails"

From Genesys Documentation
Jump to: navigation, search
production>Bgrenon
((by SublimeText.Mediawiker))
Line 2: Line 2:
 
<td><!-- get component name -->
 
<td><!-- get component name -->
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=ComponentRN,Component
+
tables=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 ReleaseDate="{{{ReleaseDate|}}}"
+
|where=
 +
ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"
 
}}
 
}}
 
</td>
 
</td>
Line 13: Line 16:
 
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,
 +
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=
 +
ComponentRN.ComponentId="{{{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'
 +
)
 
}}
 
}}
 
</td>
 
</td>
Line 27: Line 53:
 
<!-- get AWS icons for relevant release  -->
 
<!-- get AWS icons for relevant release  -->
 
{{#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=ComponentId HOLDS "{{{ComponentId|}}}" AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0" AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
+
|fields=CONCAT('[[File:',Image,'|',Size,'px|link=]]')
−
        |default=
+
|delimiter=
 +
|where=
 +
ComponentId="{{{ComponentId|}}}"  
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="0"  
 +
AND DeploymentType.Id="5439f1be-1868-4091-b058-1667389b6ce1"
 +
|default=
 
}}
 
}}
 
</td>
 
</td>
Line 40: Line 72:
 
<!-- get Azure icons for relevant release  -->
 
<!-- get Azure icons for relevant release  -->
 
{{#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">
−
|outro=</div>
+
|outro=</div>
−
|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="0"  
 +
AND DeploymentType.Id="ec194bf2-b79a-436d-8ff6-eaff94d9f43a"
 +
|default=
 +
}}
 +
</td>
 +
<!-- get GCP icons for relevant release  -->
 +
<td>
 +
{{#cargo_query:
 +
table=ComponentRN,DeploymentType
 +
|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="0"
 +
AND DeploymentType.Id="0cffec00-9053-4406-88d7-461255f48f53"
 +
|default=
 
}}
 
}}
 
</td>
 
</td>
Line 57: Line 110:
 
|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=
 +
ComponentRN._pageNamespace="0"  
 +
AND ComponentId="{{{ComponentId|}}}"
 +
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=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
+
|where=
 +
ComponentId="{{{ComponentId|}}}"
 +
AND ReleaseDate="{{{ReleaseDate|}}}"  
 +
AND ComponentRN._pageNamespace="0"
 
|default=
 
|default=
 
}}
 
}}
−
</tr></includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>
+
</tr></includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

Revision as of 18:54, May 20, 2022

Retrieved from "https://all.docs.genesys.com/Template:GetReleaseDetails (2024-09-01 20:19:15)"