PDMs GIMTenantUserSchemaList

Query template to construct the list of views of GIM tables/views in the Tenant User schema. The template is called on the Tenant User Schema and Tenant Views page in the PDMs.

This template was revised in December 2019 as part of the general refactoring to conform with the platform upgrade and with new Library book versions for GIM 9.0.

Content is:

{{#cargo_compound_query:
tables=PDMTable;where=_pageName LIKE {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#switch:{{#explode:{{FULLPAGENAME}}|:|4}}|draft=DRAFT|Public=PDMSource}}"|GIM|#default="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:{{#switch:{{lc:{{#sub:{{FULLPAGENAME}}|-5}}}}|draft|ource={{#explode:{{FULLPAGENAME}}|:|4}}|#default={{#switch:{{lc:{{#explode:{{FULLPAGENAME}}|:|4}}}}|public|current=PDMSource|#default={{#sub:{{#explode:{{FULLPAGENAME}}|:|4}}|0|3}}PDMSource}}}}"}} AND _pageName NOT LIKE "%GIM:Library:Table-CTL%" AND _pageName NOT LIKE "%Library:Table-STG%" AND _pageName NOT LIKE "%Library:Table-USER_DATA_CUST_DIM%" AND _pageName NOT LIKE "%Library:Table-IRF_USER_DATA_CUST%";fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:Table-',IF(SUBSTRING(PDMTable.tableName,-1)="_",SUBSTRING(PDMTable.tableName,1,(LENGTH(PDMTable.tableName)-1)),PDMTable.tableName),':{{#explode:{{FULLPAGENAME}}|:|4}}|',PDMTable.tableName,']]');limit=1000

|tables=PDMView;where=_pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:View-%%:{{#switch:{{#explode:{{{page}}}|:|4}}|draft=DRAFT|Public=PDMSource}}"|GIM|#default="Documentation:{{#explode:{{{page}}}|:|1}}:Library:%%:{{#switch:{{lc:{{#sub:{{{page}}}|-5}}}}|draft|ource={{#explode:{{{page}}}|:|4}}|#default={{#switch:{{lc:{{#explode:{{{page}}}|:|4}}}}|public|current=PDMSource|#default={{#sub:{{#explode:{{{page}}}|:|4}}|0|3}}PDMSource}}}}"}} AND _pageName NOT LIKE "%GIM:Library:View-ADMIN%" and _pageName NOT LIKE "%GIM:Library:View-CDR%" AND _pageName NOT LIKE "%GIM:Library:View-CTL%";fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:View-',IF(SUBSTRING(viewName,-1)="_",SUBSTRING(viewName,1,(LENGTH(viewName)-1)),viewName),':{{#explode:{{FULLPAGENAME}}|:|4}}|',viewName,']]');limit=500

|format=ul
}}