Difference between revisions of "User: Bgrenon/1"
| Line 1: | Line 1: | ||
==Combined query == | ==Combined query == | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| − | tables=Article,MintyDocsProduct ;join on=Article.productshort=MintyDocsProduct.workspace_id;fields=Article._pageName=Page,Article.Product=Product;where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud";limit= | + | tables=Article,MintyDocsProduct ;join on=Article.productshort=MintyDocsProduct.workspace_id;fields=Article._pageName=Page,Article.Product=Product;where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud";limit=100000 |
| − | |tables=PublicUseCase;fields=PublicUseCase._pageName=Page,Platform=Product;where=(Platform="PureEngageCloud" OR Platform="PureEngage") AND PublicUseCase._pageNamespace="0";limit= | + | |tables=PublicUseCase;fields=PublicUseCase._pageName=Page,Platform=Product;where=(Platform="PureEngageCloud" OR Platform="PureEngage") AND PublicUseCase._pageNamespace="0";limit=100000 |
| − | |tables=Article,MintyDocsProduct,ContentAreaSection;join on=Article.productshort=MintyDocsProduct.workspace_id,MintyDocsProduct.contentarea=ContentAreaSection.DisplayName;fields=Article._pageName=Page,Article.Product=Product;where=Article._pageNamespace="0" AND contentarea="Shared" AND (Article.Platform!="PureCloud" AND Article.Platform!="PureConnect") | + | |tables=Article,MintyDocsProduct,ContentAreaSection;join on=Article.productshort=MintyDocsProduct.workspace_id,MintyDocsProduct.contentarea=ContentAreaSection.DisplayName;fields=Article._pageName=Page,Article.Product=Product;where=Article._pageNamespace="0" AND contentarea="Shared" AND (Article.Platform!="PureCloud" AND Article.Platform!="PureConnect");limit=100000 |
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
Revision as of 15:37, June 12, 2020
Contents
Combined query[ | edit source]
Query: SELECT `cargo__Article`.`_pageName` AS `Page`,`cargo__Article`.`Product` AS `Product` FROM `cargo__Article` LEFT OUTER JOIN `cargo__MintyDocsProduct` ON ((`cargo__Article`.`productshort`=`cargo__MintyDocsProduct`.`workspace_id`)) LEFT OUTER JOIN `cargo__ContentAreaSection` ON ((`cargo__MintyDocsProduct`.`contentarea`=`cargo__ContentAreaSection`.`DisplayName`)) WHERE `cargo__Article`.`_pageNamespace`="0" AND contentarea="Shared" AND (`cargo__Article`.`Platform`!="PureCloud" AND `cargo__Article`.`Platform`!="PureConnect") ORDER BY `cargo__Article`.`_pageName`,`cargo__Article`.`Product` LIMIT 5000 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MYZd1YIi' (OS errno 28 - No space left on device) (127.0.0.1)
Shared content area for Engage (excluding Purecloud and PureConnect only pages)[ | edit source]
Query: SELECT `cargo__Article`.`_pageName` AS `Page`,`cargo__Article`.`Platform` AS `Platform` FROM `cargo__Article` LEFT OUTER JOIN `cargo__MintyDocsProduct` ON ((`cargo__Article`.`productshort`=`cargo__MintyDocsProduct`.`workspace_id`)) LEFT OUTER JOIN `cargo__ContentAreaSection` ON ((`cargo__MintyDocsProduct`.`contentarea`=`cargo__ContentAreaSection`.`DisplayName`)) WHERE `cargo__Article`.`_pageNamespace`="0" AND contentarea="Shared" AND (`cargo__Article`.`Platform`!="PureCloud" AND `cargo__Article`.`Platform`!="PureConnect") ORDER BY `cargo__Article`.`_pageName`,`cargo__Article`.`Platform` LIMIT 5000 Function: CargoSQLQuery::run Error: 1 Can't create/write to file '/tmp/MY57u7yb' (OS errno 28 - No space left on device) (127.0.0.1)
Genesys Engage Multicloud content area[ | edit source]
No results
Use Cases were platform=PureEngage and PureEngageCloud[ | edit source]
No results