Template:GCXI ReportsList - Revision history

WikiSysop at 14:45, May 19, 2022

2022-05-19T14:45:45Z

WikiSysop at 14:01, May 4, 2022

2022-05-04T14:01:09Z

WikiSysop at 13:30, April 21, 2022

2022-04-21T13:30:30Z

WikiSysop: Created page with "Query template to generate the list of reports per folder in the GCXI Universe Guide. TBD what optional parameters the template will need to accept customize either..."

2022-04-14T15:30:53Z

Created page with "<noinclude>Query template to generate the list of reports per folder in the GCXI Universe Guide. TBD what optional parameters the template will need to accept customize either..."

New page

<noinclude>Query template to generate the list of reports per folder in the GCXI Universe Guide. TBD what optional parameters the template will need to accept customize either content or formatting. The baseline template is expected to be called on the Folder page and simply to display a bulleted list of links to the reports for that folder.

Content is:
<source lang="xml">
{{#cargo_query:
tables=GCXI_Report
|fields= IF ( (anchor IS NOT NULL),CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'#',anchor,'|',reportName,']]' ),CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]'))
|where=_pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/{{#explode:{{FULLPAGENAME}}|/|3}}"
|limit=500
|format=ul
}}</source>
</noinclude>

<onlyinclude>
{{#cargo_query:
tables=GCXI_Report
|fields= IF ( (anchor IS NOT NULL),CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'#',anchor,'|',reportName,']]' ),CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]'))
|where=_pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/{{#explode:{{FULLPAGENAME}}|/|3}}"
|limit=500
|format=ul
}}
</onlyinclude>

<noinclude>[[Category:GCXI]] [[Category:Cargo_queries]]</noinclude>

@@ Line 5: / Line 5: @@
 {{#cargo_query:
 tables=GCXI_Report
-|fields= CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]')
+|fields={{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} |GCXIPRG = CONCAT( '[https://docs.genesys.com/Documentation/GCXI/{{#switch:{{NAMESPACENUMBER}}|620=9.0DRAFT|#default=9.0.0}}/User/',reportPage,' ',reportName,']')|GCXIMCPRG | #default = CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]') }}
 |where=_pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/{{#explode:{{FULLPAGENAME}}|/|3}}" {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Report.cloud LIKE "yes" OR GCXI_Report.cloud IS NULL) | GCXIPRG = AND (GCXI_Report.premise LIKE "yes" OR GCXI_Report.premise IS NULL) | #default= }}
 |limit=500
@@ Line 15: / Line 15: @@
 {{#cargo_query:
 tables=GCXI_Report
-|fields= CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]')
+|fields={{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} |GCXIPRG = CONCAT( '[https://docs.genesys.com/Documentation/GCXI/{{#switch:{{NAMESPACENUMBER}}|620=9.0DRAFT|#default=9.0.0}}/User/',reportPage,' ',reportName,']')|GCXIMCPRG | #default = CONCAT( '[[{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Current/RPRT/',reportPage,'|',reportName,']]') }}
 |where=_pageName LIKE "{{#switch:{{NAMESPACENUMBER}}|620=Draft:|#default=}}PEC-REP/Library/GCXIPRGLibrary/{{#explode:{{FULLPAGENAME}}|/|3}}" {{#switch: {{#explode:{{FULLPAGENAME}}|/|2}} | GCXIMCPRG = AND (GCXI_Report.cloud LIKE "yes" OR GCXI_Report.cloud IS NULL) | GCXIPRG = AND (GCXI_Report.premise LIKE "yes" OR GCXI_Report.premise IS NULL) | #default= }}
 |limit=500