Difference between revisions of "User: Bgrenon/3"
From Genesys Documentation
| Line 2: | Line 2: | ||
tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType | tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN,DeploymentType | ||
|join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | |join on=ArticleCloudRN__ComponentId._value=Component.Id,ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value,ComponentRN__ComponentId._rowID=ComponentRN._ID,ComponentRN.DeploymentTypeId HOLDS DeploymentType.Id | ||
| − | |fields=Component.Name,ArticleCloudRN._pageName, | + | |fields=Component.Name,ArticleCloudRN._pageName,MAX(ReleaseDate),MAX(PrivateEditionReleaseDate),ReleaseNumber,Image,Highlights,ComponentId,ReleaseDate,ReleaseNumber,Component.IpName,Containers |
| − | |where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "% | + | |where=ComponentRN._pageNamespace="0" AND ArticleCloudRN._pageNamespace="0" AND ArticleCloudRN._pageName LIKE "%GenesysEngage-cloud%" AND PrivateEditionReleaseDate IS NOT NULL AND Component.IpName IS NOT NULL |
|format=table | |format=table | ||
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
| + | |limit=10 | ||
}} | }} | ||
Revision as of 18:03, April 8, 2022
Error: No field named "Highlights" found for any of the specified database tables.