Template:EPPOQueries - Revision history

WikiSysop at 18:46, July 18, 2022

2022-07-18T18:46:47Z

Bgrenon: fixing link to suite-level guide

2022-06-17T19:05:43Z

fixing link to suite-level guide

Bgrenon at 15:26, June 8, 2022

2022-06-08T15:26:14Z

WikiSysop: Created page with "{{#cargo_query: tables=HIW |fields=CONCAT('Getting started with Genesys Multicloud CX') |where=HIW._page..."

2022-06-03T13:15:53Z

Created page with "{{#cargo_query: tables=HIW |fields=CONCAT('Getting started with Genesys Multicloud CX') |where=HIW._page..."

New page

{{#cargo_query:
tables=HIW
|fields=CONCAT('[[PEC-Admin/HIW|Getting started with Genesys Multicloud CX]]')
|where=HIW._pageName="{{FULLPAGENAME}}"
|format=template
|template=ListItems
|default=
}}{{#cargo_query:
tables=HIW
|fields=CONCAT('[[',HIW._pageName ,'|',HIW.DisplayName,']]')
|where=
HIW.productshort LIKE '%{{#explode:{{FULLPAGENAME}}|/|0}}%'
AND HIW._pageNamespace="{{NAMESPACENUMBER}}"
AND HIW._pageName!="{{FULLPAGENAME}}"
|format=template
|template=ListItems
|default=
}}{{#cargo_query:
tables=GetStarted
|fields=CONCAT('[[',GetStarted._pageName,'|',GetStarted.DisplayName,']]')
|where=
GetStarted.productshort LIKE '%{{#explode:{{FULLPAGENAME}}|/|0}}%'
AND GetStarted._pageNamespace="{{NAMESPACENUMBER}}"
AND GetStarted._pageName!="{{FULLPAGENAME}}"
AND _pageName LIKE "%/{{#explode:{{FULLPAGENAME}}|/|2}}/%"
|format=template
|template=ListItems
|default=
}}{{#cargo_query:
tables={{{PageType|}}}
|fields=CONCAT('[[',_pageName,'|',DisplayName,']]')
|where=
Dimension="{{{Dimension|}}}"
AND Dimension IS NOT NULL
AND _pageName!="{{FULLPAGENAME}}"
AND {{{PageType|}}}._pageName LIKE '%{{#explode:{{FULLPAGENAME}}|/|1}}%'
AND {{{PageType|}}}._pageNamespace="{{NAMESPACENUMBER}}"
|format=template
|template=ListItems
|default=
}}{{#cargo_query:
tables=Article,MintyDocsManual
|join on=Article._pageNamespace=MintyDocsManual._pageNamespace
|fields=CONCAT('[[',MintyDocsManual._pageName ,'|Suite-level guide]]')
|where=
Article._pageName="{{FULLPAGENAME}}"
AND Article.Manual=MintyDocsManual.Manual
AND MintyDocsManual._pageName!="{{FULLPAGENAME}}"
AND MintyDocsManual._pageName NOT LIKE "%Boilerplate%"
|format=template
|template=ListItems
|default=
}}{{#cargo_query:
tables=Article,MintyDocsManual
|join on=Article._pageNamespace=MintyDocsManual._pageNamespace
|fields=CONCAT('{{Link-AnywhereElse|product=PrivateEdition|version=Current|manual=PEGuide|topic=GEServices|display text=All services}}')
|where=
Article._pageName="{{FULLPAGENAME}}"
AND Article.Manual=MintyDocsManual.Manual
AND MintyDocsManual._pageName NOT LIKE "%Boilerplate%"
AND Article._pageName NOT LIKE "%GEServices%"
|format=template
|template=ListItems
|default=
|group by=MintyDocsManual.ServiceId
}}{{#cargo_query:
tables=ArticleIndexRN,MintyDocsManual,Article,Service
|join on=
ArticleIndexRN.ServiceId HOLDS MintyDocsManual.ServiceId,
MintyDocsManual.Manual=Article.Manual,
MintyDocsManual.ServiceId=Service.Id
|fields=CONCAT('[[',ArticleIndexRN._pageName,'|',Service.Name,' Release Notes]]')
|where=
Article._pageName="{{FULLPAGENAME}}"
AND MintyDocsManual.ServiceId IS NOT NULL
AND ArticleIndexRN._pageNamespace="{{NAMESPACENUMBER}}"
|format=template
|template=ListItems
|default= 
{{#cargo_query:
tables=ArticleCloudRN,MintyDocsManual,Article,Service
|join on=
ArticleCloudRN.ServiceId HOLDS MintyDocsManual.ServiceId,
MintyDocsManual.Manual=Article.Manual,
MintyDocsManual.ServiceId=Service.Id
|fields=CONCAT('[[',ArticleCloudRN._pageName,'|',Service.Name,' Release Notes]]')
|where=
Article._pageName="{{FULLPAGENAME}}"
AND MintyDocsManual.ServiceId IS NOT NULL
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
|format=template
|template=ListItems
|default=
|group by=ArticleCloudRN._pageName,Service.Name
}}
|group by=ArticleIndexRN._pageName,Service.Name
}}{{#arraymap:{{{DepGuideServiceId|}}}
|,
|x
|{{#cargo_query:
tables=ArticleCloudRN,MintyDocsManual,Service
|join on=
ArticleCloudRN.DepGuideServiceId HOLDS MintyDocsManual.ServiceId,
MintyDocsManual.ServiceId=Service.Id
|fields=CONCAT('[[',MintyDocsManual._pageName,'|',MintyDocsManual.displayname,']]')
|where=
ArticleCloudRN.DepGuideServiceId HOLDS "x"
AND MintyDocsManual.ServiceId IS NOT NULL
AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"
AND MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"
AND ArticleCloudRN._pageName="{{FULLPAGENAME}}"
|format=template
|delimiter=
|template=ListItems
|default=
|group by=MintyDocsManual._pageName,MintyDocsManual.displayname,MintyDocsManual.ServiceId
}}
|\s
}}{{#arraymap:{{{DepGuideServiceId|}}}
|,
|x
|{{#cargo_query:
tables=ArticleHelmRN,MintyDocsManual,Service
|join on=
ArticleHelmRN.DepGuideServiceId HOLDS MintyDocsManual.ServiceId,
MintyDocsManual.ServiceId=Service.Id
|fields=CONCAT('[[',MintyDocsManual._pageName,'|',MintyDocsManual.displayname,']]')
|where=
ArticleHelmRN.DepGuideServiceId HOLDS "x"
AND MintyDocsManual.ServiceId IS NOT NULL
AND ArticleHelmRN._pageNamespace="{{NAMESPACENUMBER}}"
AND MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"
AND ArticleHelmRN._pageName="{{FULLPAGENAME}}"
|format=template
|delimiter=
|template=ListItems
|default=
|group by=MintyDocsManual._pageName,MintyDocsManual.displayname,MintyDocsManual.ServiceId
}}
|\s
}}{{#if:{{{ServiceId|}}}
|{{#switch:{{{RN|}}} 
|#default=
|Yes=
{{#if: 
{{#cargo_query:
tables=ArticleIndexRN
|where=ArticleIndexRN._pageName = "{{FULLPAGENAME}}"
|default=
}}
| 
|{{#cargo_query: 
tables=Article,ArticleIndexRN,Service
|join on=
Article._pageNamespace=ArticleIndexRN._pageNamespace,
ArticleIndexRN.ServiceId HOLDS Service.Id
|fields=CONCAT('[[',ArticleIndexRN._pageName,'|',ArticleIndexRN.DisplayName,']]')=Page
|where={{#arraymap:{{{ServiceId|}}}|,|z| (ArticleIndexRN._pageName != "{{FULLPAGENAME}}" AND Article._pageName="{{FULLPAGENAME}}" AND ArticleIndexRN.ServiceId HOLDS 'z')||OR }}
|format=template
|delimiter=
|template=ListItems
|default=
{{#cargo_query: 
tables=ArticleIndexRN,Article,ArticleCloudRN,Service
|join on=
ArticleIndexRN._pageNamespace=Article._pageNamespace,
Article._pageNamespace=ArticleCloudRN._pageNamespace,
ArticleCloudRN.ServiceId HOLDS Service.Id
|fields=CONCAT('[[',ArticleCloudRN._pageName,'|',Service.Name,' Release Notes]]')=Page
|where={{#arraymap:{{{ServiceId|}}}|,|z| (ArticleCloudRN._pageName != "{{FULLPAGENAME}}" AND Article._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN.ServiceId HOLDS 'z')||OR }}
|format=template
|delimiter=
|template=ListItems
|default=
|group by=ArticleCloudRN._pageName,Service.Name
}}
|group by=ArticleIndexRN._pageName,ArticleIndexRN.DisplayName
}}
}}
}} {{#switch:{{{RN|}}}
|#default=
|Yes=
{{#cargo_query: 
tables=Article,ArticleHelmRN,Service
|join on=
Article._pageNamespace=ArticleHelmRN._pageNamespace,
ArticleHelmRN.ServiceId HOLDS Service.Id
|fields=CONCAT('[[',ArticleHelmRN._pageName,'|',ArticleHelmRN.DisplayName,']]')
|where=
{{#arraymap:{{{ServiceId|}}}|,|x|(Article._pageName="{{FULLPAGENAME}}" AND ArticleHelmRN.ServiceId HOLDS 'x')||OR }}
AND ArticleHelmRN._pageName != "{{FULLPAGENAME}}"
|format=template
|delimiter=
|template=ListItems
|default=
|group by=ArticleHelmRN._pageName,ArticleHelmRN.DisplayName
}}
}}
|
}}<nowiki/><noinclude>[[Category:GroupByFix]]</noinclude>

@@ Line 127: / Line 127: @@
 		}}
 	|group by=ArticleIndexRN._pageName,Service.Name
 }}<!--

@@ Line 62: / Line 62: @@
 	tables=Article,MintyDocsManual
 	|join on=Article._pageNamespace=MintyDocsManual._pageNamespace
-	|fields=CONCAT('[[',MintyDocsManual._pageName ,'|Suite-level guide]]')
+	|fields=CONCAT('{{Link-AnywhereElse|product=PrivateEdition|version=Current|manual=PEGuide|display text=Suite-level guide}}')
 	|where=
 		MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"

@@ Line 1: / Line 1: @@
-<!--
+<includeonly><!--
 	add link to HIW portal to HIW pages
@@ Line 64: / Line 64: @@
 	|fields=CONCAT('[[',MintyDocsManual._pageName ,'|Suite-level guide]]')
 	|where=
-		Article._pageName="{{FULLPAGENAME}}"
+		MintyDocsManual._pageNamespace="{{NAMESPACENUMBER}}"
 		AND Article.Manual=MintyDocsManual.Manual
 		AND MintyDocsManual._pageName!="{{FULLPAGENAME}}"
 		AND MintyDocsManual._pageName NOT LIKE "%Boilerplate%"
 	|format=template
 	|template=ListItems
@@ Line 84: / Line 87: @@
 		AND MintyDocsManual._pageName NOT LIKE "%Boilerplate%"
 		AND Article._pageName NOT LIKE "%GEServices%"
 	|format=template
 	|template=ListItems
@@ Line 105: / Line 109: @@
 	|format=template
 	|template=ListItems
-	|default=  <!-- Adding link to RN page on PE pages, if no Index RN exists -->
+	|default=
 		{{#cargo_query:
 			tables=ArticleCloudRN,MintyDocsManual,Article,Service
@@ Line 183: / Line 187: @@
 		|#default=
 		|Yes=
 			{{#if: <!-- check if page is IndexRN  -->
 				{{#cargo_query:
@@ Line 218: / Line 237: @@
 				}}
 			}}
 		}}
+	|
-}}<nowiki/><noinclude>[[Category:GroupByFix]]</noinclude>
+}}</includeonly>