Difference between revisions of "Template: BP ServiceNameVar"
From Genesys Documentation
(Component._pageID is fine) (Tag: Undo) |
(switch to HOLDS Component.Id) |
||
| Line 9: | Line 9: | ||
Component | Component | ||
|join on= | |join on= | ||
| − | ArticleCloudRN.ComponentId HOLDS | + | ArticleCloudRN.ComponentId HOLDS Component.Id, |
ComponentRN.ComponentId=Component.Id | ComponentRN.ComponentId=Component.Id | ||
|fields=Component.Name | |fields=Component.Name | ||
Revision as of 15:32, June 21, 2022
This template is used for displaying the Service (Component) Name.
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__Component`.`Name` AS `Name` FROM `cargo__ArticleCloudRN`,`cargo__ComponentRN` LEFT OUTER JOIN `cargo__ArticleCloudRN__ComponentId` ON ((`cargo__ArticleCloudRN`.`_ID`=`cargo__ArticleCloudRN__ComponentId`.`_rowID`)) LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId`=`cargo__Component`.`Id`) AND (`cargo__ArticleCloudRN__ComponentId`.`_value`=`cargo__Component`.`Id`)) WHERE `cargo__ArticleCloudRN`.`_pageName`="Template:BP ServiceNameVar" AND `cargo__ComponentRN`.`ReleaseNumber` = ""
AND `cargo__ComponentRN`.`ComponentId` = "" GROUP BY `cargo__Component`.`_pageID`,`cargo__Component`.`Name` ORDER BY `cargo__Component`.`Name` LIMIT 100
Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__ArticleCloudRN._ID' in 'on clause' (127.0.0.1)