User:Bgrenon/1 - Revision history

Bgrenon at 21:37, April 20, 2022

2022-04-20T21:37:32Z

WikiSysop at 19:45, April 1, 2022

2022-04-01T19:45:40Z

WikiSysop at 19:30, April 1, 2022

2022-04-01T19:30:38Z

Bgrenon at 12:34, June 15, 2020

2020-06-15T12:34:33Z

Bgrenon at 12:26, June 15, 2020

2020-06-15T12:26:52Z

Bgrenon at 12:26, June 15, 2020

2020-06-15T12:26:16Z

Bgrenon at 12:25, June 15, 2020

2020-06-15T12:25:52Z

Bgrenon at 15:39, June 12, 2020

2020-06-12T15:39:59Z

Bgrenon at 15:37, June 12, 2020

2020-06-12T15:37:18Z

Bgrenon at 15:35, June 12, 2020

2020-06-12T15:35:28Z

@@ Line 1: / Line 1: @@
-<tabber>
+TEST<tabber>
 Last 24 hours=
 {{#cargo_query:

@@ Line 1: / Line 1: @@
 <tabber>
 Last 24 hours=
 {{#cargo_query:
-tables=ComponentRN
+tables=ComponentRN,Component
-|fields=ComponentId,ReleaseDate,Highlight
+|join on=ComponentRN.ComponentId HOLDS Component.Id
 |where=DATEDIFF(ReleaseDate,NOW()) >= -1
 }}
 |-|
 Last week=
 {{#cargo_query:
-tables=ComponentRN
+tables=ComponentRN,Component
-|fields=ComponentId,ReleaseDate,Highlight
+|join on=ComponentRN.ComponentId HOLDS Component.Id
 |where=DATEDIFF(ReleaseDate,NOW()) >= -7
 |merge similar cells=yes
 }}
 |-|
 Last 30 days=
 {{#cargo_query:
-tables=ComponentRN
+tables=ComponentRN,Component
-|fields=ComponentId,ReleaseDate,Highlight
+|join on=ComponentRN.ComponentId HOLDS Component.Id
 |where=DATEDIFF(ReleaseDate,NOW()) >= -30
 |merge similar cells=yes
 }}
 </tabber>

@@ Line 1: / Line 1: @@
-==Shared content area for Engage (excluding Purecloud and PureConnect only pages)==
+<tabber>
 {{#cargo_query:
-tables=Article,MintyDocsProduct,ContentAreaSection
+tables=ComponentRN
-|join on=Article.productshort=MintyDocsProduct.workspace_id,MintyDocsProduct.contentarea=ContentAreaSection.DisplayName
+|fields=ComponentId,ReleaseDate,Highlight
-|fields=Article._pageName=Page,Article.Platform
+|where=DATEDIFF(ReleaseDate,NOW()) >= -1
 }}
+|-|
+Last week=
 {{#cargo_query:
-tables=Article,MintyDocsProduct
+tables=ComponentRN
-|join on=Article.productshort=MintyDocsProduct.workspace_id
+|fields=ComponentId,ReleaseDate,Highlight
-|fields=Article._pageName=Page
+|where=DATEDIFF(ReleaseDate,NOW()) >= -7
-|where=Article._pageNamespace="0" AND contentarea="Genesys Engage Multicloud"
+|merge similar cells=yes
 }}
+|-|
-==Use Cases were platform=PureEngage and PureEngageCloud==
+Last 30 days=
 {{#cargo_query:
-|tables=PublicUseCase
+tables=ComponentRN
-|fields=PublicUseCase._pageName=Page
+|fields=ComponentId,ReleaseDate,Highlight
-|where=(Platform="PureEngage" OR Platform="PureEngageCloud") AND PublicUseCase._pageNamespace="0"
+|where=DATEDIFF(ReleaseDate,NOW()) >= -30
-|format=dynamic table
+|merge similar cells=yes
 }}

@@ Line 1: / Line 1: @@
 {{#cargo_query:
-tables=Article,MintyDocsProduc
+tables=Article,MintyDocsProduct
 |join on=Article.productshort=MintyDocsProduct.workspace_id
-|fields=_pageName,Product
+|fields=Article._pageName,Product
-|where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud"
+|where=(Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud")
 }}

@@ Line 1: / Line 1: @@
 {{#cargo_query:
-tables=Article
+tables=Article,MintyDocsProduc
 |fields=_pageName,Product
 |where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud"

← Older revision		Revision as of 12:25, June 15, 2020
Line 1:		Line 1:
		+	{{#cargo_query:
		+	tables=Article
		+	\|fields=_pageName,Product
		+	\|where=Article._pageNamespace="0" AND MintyDocsProduct.contentarea="Genesys Engage Multicloud";limit=100000
		+	}}
		+
	==Combined query ==		==Combined query ==
	{{#cargo_compound_query:		{{#cargo_compound_query:

@@ Line 5: / Line 5: @@
 |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
 }}

@@ Line 1: / Line 1: @@
 ==Combined 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=10000
+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=10000
+|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
 }}