Difference between revisions of "Template: ArticleCloudRN"
From Genesys Documentation
| Line 103: | Line 103: | ||
|join on= | |join on= | ||
ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId, | ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId, | ||
| − | ComponentRN._ID =ComponentRN__DeploymentTypeId._rowID | + | ComponentRN._ID=ComponentRN__DeploymentTypeId._rowID |
|fields= | |fields= | ||
ComponentRN.ComponentId, | ComponentRN.ComponentId, | ||
| Line 116: | Line 116: | ||
|limit=10000 | |limit=10000 | ||
|order by=ComponentRN.ReleaseDate DESC | |order by=ComponentRN.ReleaseDate DESC | ||
| − | |group by=ComponentRN.ComponentId, | + | |group by= |
| + | ComponentRN._pageID, | ||
| + | ComponentRN.ComponentId, | ||
ComponentRN.ReleaseNumber, | ComponentRN.ReleaseNumber, | ||
ComponentRN.ReleaseDate, | ComponentRN.ReleaseDate, | ||
| Line 126: | Line 128: | ||
|intro= | |intro= | ||
<table class="sortable" style="font-size:90%"> | <table class="sortable" style="font-size:90%"> | ||
| − | <tr> | + | <tr>{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID|fields=COUNT(*)|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"|no html}}|1||<th rowspan="2" style="width:15%">Service</th>}} |
| − | |||
<th rowspan="2" style="width:12%">Available</th> | <th rowspan="2" style="width:12%">Available</th> | ||
<th colspan="3" style="text-align: center>Genesys CX on</th> | <th colspan="3" style="text-align: center>Genesys CX on</th> | ||
| Line 146: | Line 147: | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables= | tables= | ||
| − | + | Component, | |
ComponentRN, | ComponentRN, | ||
| − | ComponentRN__DeploymentTypeId | + | ComponentRN__DeploymentTypeId |
| − | |||
|join on= | |join on= | ||
| − | + | Component.Id=ComponentRN.ComponentId, | |
| − | ComponentRN._ID=ComponentRN__DeploymentTypeId._rowID | + | ComponentRN._ID=ComponentRN__DeploymentTypeId._rowID |
| − | |||
|fields= | |fields= | ||
ComponentId=Component, | ComponentId=Component, | ||
ComponentRN.ReleaseNumber=ReleaseNumber, | ComponentRN.ReleaseNumber=ReleaseNumber, | ||
ComponentRN.ReleaseDate=ReleaseDate, | ComponentRN.ReleaseDate=ReleaseDate, | ||
| − | |||
| − | |||
Component.Name=ComponentName | Component.Name=ComponentName | ||
|format=template | |format=template | ||
| Line 169: | Line 166: | ||
|named args=yes | |named args=yes | ||
|order by=ComponentRN.ReleaseDate DESC | |order by=ComponentRN.ReleaseDate DESC | ||
| − | |group by=ComponentRN. | + | |group by= |
| + | Component._pageID, | ||
| + | ComponentRN._pageID, | ||
| + | ComponentRN.ComponentId, | ||
| + | ComponentRN.ReleaseNumber, | ||
| + | ComponentRN.ReleaseDate, | ||
| + | Component.Name | ||
}} | }} | ||
Revision as of 20:45, June 14, 2022
This is the "ArticleCloudRN" template.
It should be called in the following format:
{{ArticleCloudRN
|ServiceId=
|DepGuideServiceId=
|ComponentId=
|DeploymentTypeId=
|ReleaseTypeId=
|Footer=
}}
Edit the page to see the template text.
This template defines the table "ArticleCloudRN". View table. This template adds rows to the table "Article", which is declared by the template Article. View table.