Difference between revisions of "Template: GetReleaseDetails"

From Genesys Documentation
Jump to: navigation, search
(Created page with "<includeonly><tr> <td><!-- get component name --> {{#cargo_query: tables=ComponentRN,Component |join on=ComponentRN.ComponentId HOLDS Component.Id |fields=Component.Name |grou...")
 
Line 18: Line 18:
 
<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=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN
+
tables=ComponentRN
−
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID
+
|fields=CONCAT('[[File:',Image,'|80px]]')
−
|fields=CONCAT('[[',ArticleCloudRN._pageName,'#',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),'|',DATE_FORMAT(MAX(ReleaseDate),'%M %d, %Y'),']]')
+
|where=ComponentId HOLDS '{{{ComponentId|}}}' AND ReleaseDate="{{{ReleaseDate|}}}" AND ComponentRN._pageNamespace="0"
−
|where=ComponentRN__ComponentId._value="{{{ComponentId|}}}" AND ArticleCloudRN._pageNamespace="0" AND ReleaseDate="{{{ReleaseDate|}}}"
 
−
|group by=ComponentRN.ComponentId
 
 
}}
 
}}
 
</td>
 
</td>

Revision as of 17:35, April 28, 2022

Retrieved from "https://all.docs.genesys.com/Template:GetReleaseDetails (2024-10-06 22:39:11)"