Difference between revisions of "User: Bgrenon/3"
(Created page with "test") |
|||
| Line 1: | Line 1: | ||
| − | + | {{#cargo_query: | |
| + | tables=SMART_Meta,SMART_Canonical,SMART_UseCase | ||
| + | |join on=SMART_Meta.ID=SMART_Canonical.ID,SMART_Canonical.ID=SMART_UseCase.ID | ||
| + | |fields=SMART_Meta.ID,SMART_Meta.Title,Subtitle,Offering,PlatformSolution,PlatformChallenge,SMART_UseCase.SellableItems,PainPoints,DesiredState,SMART_UseCase.BuyerPersonas,SMART_UseCase.QualifyingQuestions | ||
| + | |where=SMART_Meta.ID="CE01" AND SMART_UseCase.Offering="PureEngage" | ||
| + | |format=JSON | ||
| + | |parse values=yes | ||
| + | }} | ||
Revision as of 14:38, November 29, 2018
Query: SELECT `cargo__SMART_Meta`.`ID` AS `ID`,`cargo__SMART_Meta`.`Title` AS `Title`,`Subtitle` AS `Subtitle`,`Offering` AS `Offering`,`PlatformSolution` AS `PlatformSolution`,`PlatformChallenge` AS `PlatformChallenge`,`SellableItems__full` AS `SellableItems`,`PainPoints` AS `PainPoints`,`DesiredState` AS `DesiredState`,`cargo__SMART_UseCase`.`BuyerPersonas` AS `BuyerPersonas`,`cargo__SMART_UseCase`.`QualifyingQuestions` AS `QualifyingQuestions` FROM `cargo__SMART_Meta` LEFT OUTER JOIN `cargo__SMART_Canonical` ON ((`cargo__SMART_Meta`.`ID`=`cargo__SMART_Canonical`.`ID`)) LEFT OUTER JOIN `cargo__SMART_UseCase` ON ((`cargo__SMART_Canonical`.`ID`=`cargo__SMART_UseCase`.`ID`)) WHERE `cargo__SMART_Meta`.`ID`="CE01" AND `cargo__SMART_UseCase`.`Offering`="PureEngage" ORDER BY `cargo__SMART_Meta`.`ID`,`cargo__SMART_Meta`.`Title`,`Subtitle`,`Offering`,`PlatformSolution` LIMIT 100 Function: CargoSQLQuery::run Error: 1052 Column 'PainPoints' in field list is ambiguous (127.0.0.1)