User:Tgilchri/PRG - Revision history

WikiSysop at 18:45, May 11, 2022

2022-05-11T18:45:56Z

WikiSysop at 16:45, May 11, 2022

2022-05-11T16:45:37Z

WikiSysop at 14:15, May 10, 2022

2022-05-10T14:15:33Z

WikiSysop at 13:45, May 10, 2022

2022-05-10T13:45:33Z

Show changes

WikiSysop at 19:15, May 6, 2022

2022-05-06T19:15:37Z

WikiSysop at 15:00, May 6, 2022

2022-05-06T15:00:25Z

WikiSysop: Created page with "==ROOT== {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID |fields=CONCAT( '{{FULLPA..."

2022-05-06T13:30:32Z

Created page with "==ROOT== {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID |fields=CONCAT( '{{FULLPA..."

New page

==ROOT==
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr
|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
|group by=GCXI_Attribute.attr
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}

==AGE==
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr
|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
|group by=GCXI_Attribute.attr
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}

==AGENT==
{{#cargo_query:
tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'|',GCXI_Attribute.attr,']]')=attr
|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent") {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) | GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) | #default= }}
|group by=GCXI_Attribute.attr
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}

The iWD root folder contains numerous attributes that you can use to build intelligent Workload Distribution (iWD)-related reports.

Note the following:
*When creating attributes, any forms you create must have a one-is-to-one mapping relationship. For example, an attribute that represents the name of a customer can have only one phone number form associated with it.
*Objects in each folder or subfolder are designed to be used together to create reports. Avoid mixing attributes and metrics from multiple folders into your reports. One exception to this rule is objects in the Time folder; Time attributes can be used in any report, and most reports include at least one attribute from the Time folder.

{{GCXI_Attributes_Display}}

@@ Line 22: / Line 22: @@
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIMCPRG:
 |default=* There are no attributes in this folder
 |format=table

← Older revision		Revision as of 16:45, May 11, 2022
Line 1:		Line 1:
		+	==May 11==
		+
		+	{{Editgrn_open}}IS THIS IT for iWD > Agent in cloud?{{Editgrn_close}}<br/>
		+	It uses IF that evaluates to the following where condition:
		+	* If displaysInFolder__Cloud is not empty --> pagename AND (folder=<folder> OR displaysInFolder_Cloud contains <folder>) AND cloud = yes or null.
		+	* If displaysInFolder__Cloud is empty --> pagename AND (folder=<folder> OR displaysInFolder contains <folder>) AND cloud = yes or null.
		+	Expecting 7 results, meaning Department and Process are excluded. There's no diffs if the interior clauses in the IF statement are not in brackets.
		+	{{#cargo_query:
		+	tables=GCXI_Attribute
		+	\|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'\|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
		+	\|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND IF(GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%",(GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "iWD > Agent"),(GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute.displaysInFolder HOLDS LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
		+	\|format=table
		+	\|group by=GCXI_Attribute.attr
		+	\|order by=GCXI_Attribute.attr
		+	}}
		+
		+	{{#cargo_query:
		+	tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
		+	\|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
		+	\|fields=CONCAT( '[[{{FULLPAGENAME}}#',GCXI_Attribute.anchor,'\|',GCXI_Attribute.attr,']]')=attr,GCXI_Attribute.folder=folder,GCXI_Attribute.displaysInFolder__full=displaysInFolder,GCXI_Attribute.displaysInFolder_Cloud__full=displaysInFolder_Cloud,GCXI_Attribute.cloud=cloud
		+	\|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Agent") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
		+	\|group by=GCXI_Attribute.attr
		+	\|intro=Existing query for GCXIMCPRG:
		+	\|default=* There are no attributes in this folder
		+	\|format=table
		+	\|order by=GCXI_Attribute.attr ASC
		+	}}
		+
	==May 10==		==May 10==
	{{#cargo_query:		{{#cargo_query:

← Older revision		Revision as of 15:00, May 6, 2022
Line 1:		Line 1:
		+
		+	===Pseudocode-ish===
		+	<source lang="bash">
		+	{{#if:displaysInFolder_Cloud
		+	\|show displaysInFolder_Cloud
		+	\| {{#if:{{{displaysInFolder_Premise\|}}}
		+	\|show displaysInFolder_Premise
		+	\|default displaysInFolder
		+	}}<!--end of nested if if cloud parameter is null-->
		+	}}<!--end of first if--></source>
		+
		+	===GCXI_Attribute__displaysInFolder_Cloud._value===
		+	{{ColumnFormat\|cols=3\|content=
		+	{{#cargo_query:
		+	tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Cloud
		+	\|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._rowID
		+	\|fields=IF(GCXI_Attribute__displaysInFolder_Cloud._value LIKE "%%",CONCAT('do this'),GCXI_Attribute.attr)=attr
		+	\|where=GCXI_Attribute._pageName LIKE "{{#switch:{{NAMESPACENUMBER}}\|620=Draft:\|#default=}}PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") {{#switch: {{#explode:{{FULLPAGENAME}}\|/\|2}} \| GCXIMCPRG = AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL) \| GCXIPRG = AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL) \| #default= }}
		+	\|group by=GCXI_Attribute.attr
		+	\|default=* There are no attributes in this folder
		+	\|format=ul
		+	\|order by=GCXI_Attribute.attr ASC
		+	}}
		+	}}
		+
	==ROOT==		==ROOT==
	{{#cargo_query:		{{#cargo_query:

@@ Line 21: / Line 21: @@
 |order by=GCXI_Attribute.attr ASC
 }}
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
@@ Line 32: / Line 33: @@
 |order by=GCXI_Attribute.attr ASC
 }}
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Cloud
@@ Line 43: / Line 45: @@
 |order by=GCXI_Attribute.attr ASC
 }}
 {{#cargo_query:
 tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder,GCXI_Attribute__displaysInFolder_Premise

@@ Line 24: / Line 24: @@
 }}
 ==ROOT==
 {{#cargo_query: