User:Jdruker/GCXI PG CloudRestricted - Revision history

WikiSysop at 23:00, May 10, 2022

2022-05-10T23:00:30Z

WikiSysop at 22:15, May 10, 2022

2022-05-10T22:15:27Z

WikiSysop at 13:00, May 10, 2022

2022-05-10T13:00:30Z

WikiSysop at 12:00, May 10, 2022

2022-05-10T12:00:26Z

Show changes

WikiSysop at 21:45, May 9, 2022

2022-05-09T21:45:32Z

WikiSysop: Created page with "==iWD > Agent== {{ColumnFormat|cols=2|content= {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFol..."

2022-05-09T21:30:29Z

Created page with "==iWD > Agent== {{ColumnFormat|cols=2|content= {{#cargo_query: tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFol..."

New page

==iWD > Agent==
{{ColumnFormat|cols=2|content=
{{#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
|intro=Existing query:
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}
{{#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=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_Cloud._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT 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
|intro=New query:
|default=* There are no attributes in this folder
|format=ul
|order by=GCXI_Attribute.attr ASC
}}
}}

@@ Line 14: / Line 14: @@
 |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") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|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:
@@ Line 25: / Line 25: @@
 |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") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|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.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIPRG:
@@ Line 36: / Line 36: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._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_Cloud._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute__displaysInFolder_Cloud._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Agent")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIMCPRG:
@@ Line 47: / Line 47: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._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_Premise._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Agent")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Agent" OR (GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Agent")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIPRG:
@@ Line 62: / Line 62: @@
 |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") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIMCPRG:
@@ Line 73: / Line 73: @@
 |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") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Age" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD > Age") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIPRG:
@@ Line 84: / Line 84: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._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_Cloud._value LIKE "iWD > Age" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Age")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Age" OR (GCXI_Attribute__displaysInFolder_Cloud._value LIKE "iWD > Age" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Age")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIMCPRG:
@@ Line 95: / Line 95: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._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_Premise._value LIKE "iWD > Age" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Age")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD > Age" OR (GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD > Age" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD > Age")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIPRG:
@@ Line 110: / Line 110: @@
 |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") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIMCPRG:
@@ Line 121: / Line 121: @@
 |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") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR GCXI_Attribute__displaysInFolder._value LIKE "iWD") AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=Existing query for GCXIPRG:
@@ Line 132: / Line 132: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Cloud._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_Cloud._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR (GCXI_Attribute__displaysInFolder_Cloud._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.cloud LIKE "yes" OR GCXI_Attribute.cloud IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIMCPRG:
@@ Line 143: / Line 143: @@
 |join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID,GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder_Premise._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_Premise._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
+|where=GCXI_Attribute._pageName LIKE "Draft:PEC-REP/Library/GCXIPRGLibrary/%%" AND (GCXI_Attribute.folder LIKE "iWD" OR (GCXI_Attribute__displaysInFolder_Premise._value LIKE "iWD" AND GCXI_Attribute__displaysInFolder._value NOT LIKE "iWD")) AND (GCXI_Attribute.premise LIKE "yes" OR GCXI_Attribute.premise IS NULL)
 |group by=GCXI_Attribute.attr
 |intro=New query for GCXIPRG:

← Older revision		Revision as of 22:15, May 10, 2022
Line 1:		Line 1:
		+	Related link: [[User:Tgilchri/PRG]]
		+
	{{#cargo_query:		{{#cargo_query:
	tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder		tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder

← Older revision		Revision as of 13:00, May 10, 2022
Line 1:		Line 1:
		+	{{#cargo_query:
		+	tables=GCXI_Attribute,GCXI_Attribute__displaysInFolder
		+	\|join on=GCXI_Attribute._ID=GCXI_Attribute__displaysInFolder._rowID
		+	\|fields=attr,displaysInFolder,displaysInFolder_Cloud,displaysInFolder_Premise,cloud,premise
		+	\|where=GCXI_Attribute.displaysInFolder_Cloud HOLDS LIKE "%%" OR GCXI_Attribute.displaysInFolder_Premise HOLDS LIKE "%%"
		+	}}
		+
	==iWD > Agent==		==iWD > Agent==
	{{ColumnFormat\|cols=2\|content=		{{ColumnFormat\|cols=2\|content=

@@ Line 17: / Line 17: @@
 |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_Cloud._value LIKE "iWD > Agent" AND GCXI_Attribute__displaysInFolder._value NOT 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
 |intro=New query: