PDMSchemaChangeSummary

Cargo query to generate the summary of schema changes, based on introduced/modified/discontinued entries in the PDMTable and PDMColumn template calls in PDM Library books. The |fields and |where parameters need to allow for the correct manuals and versions for the source Library content and target links.

The query is:

{{#css: 
th.field_Table {width:35%;} 
th.field_Column {width:35%;} 
th.field_Changed in release {width:10%;}
th.field_Type of change {width:15%;}
th.field_More information {width:5%;}
}}
{{#cargo_compound_query:
tables=PDMTable;where=PDMTable._pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#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 (PDMTable.introduced IS NOT NULL);fields=REPLACE(PDMTable.tableName,"_","_<wbr/>")=Table,CONCAT('')=Column,PDMTable.introduced=Changed in release,IF((PDMTable.introduced IS NOT NULL),"Table added",'')=Type of change,CONCAT('[[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{{page}}}|:|4}}|See table]]')=More information;limit=5000

|tables=PDMTable,PDMColumn;join on=PDMTable._pageName=PDMColumn._pageName;where=PDMTable._pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#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 (PDMColumn.introduced IS NOT NULL);fields=REPLACE(PDMTable.tableName,"_","_<wbr/>")=Table,REPLACE(PDMColumn.colName,"_","_<wbr/>")=Column,PDMColumn.introduced=Changed in release,IF((PDMColumn.introduced IS NOT NULL),"Column added",'')=Type of change,CONCAT('[[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{{page}}}|:|4}}|See table]]')=More information;limit=5000

|tables=PDMTable,PDMColumn;join on=PDMTable._pageName=PDMColumn._pageName;where=PDMTable._pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#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 (PDMColumn.discontinued IS NOT NULL);fields=REPLACE(PDMTable.tableName,"_","_<wbr/>")=Table,REPLACE(PDMColumn.colName,"_","_<wbr/>")=Column,PDMColumn.discontinued=Changed in release,IF((PDMColumn.discontinued IS NOT NULL),"Column discontinued",'')=Type of change,CONCAT('[[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{{page}}}|:|4}}|See table]]')=More information;limit=5000

|tables=PDMTable,PDMColumn,PDMColumn__modified;join on=PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID;where=PDMTable._pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#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 (PDMColumn.modified__full IS NOT NULL);fields=REPLACE(PDMTable.tableName,"_","_<wbr/>")=Table,REPLACE(PDMColumn.colName,"_","_<wbr/>")=Column,SUBSTRING_INDEX(PDMColumn__modified._value,'(',1)=Changed in release,CONCAT('Column modified (',SUBSTRING_INDEX(PDMColumn__modified._value,'(',-1))=Type of change,CONCAT('[[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{{page}}}|:|4}}|See table]]')=More information;limit=5000

|tables=PDMTable,PDMTable__modified;join on=PDMTable._ID=PDMTable__modified._rowID;where=PDMTable._pageName LIKE {{#switch:{{#explode:{{{page}}}|:|1}}|PSAAS="Documentation:GIM:Library:Table-%%:{{#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 (PDMTable__modified._value LIKE "%character-length semantics%");fields=REPLACE(PDMTable.tableName,"_","_<wbr/>")=Table,CONCAT('Various columns')=Column,SUBSTRING_INDEX(PDMTable__modified._value,'(',1)=Changed in release,CONCAT('Column modified (',SUBSTRING_INDEX(PDMTable__modified._value,'(',-1))=Type of change,CONCAT('[[Documentation:{{#explode:{{{page}}}|:|1}}:{{#explode:{{{page}}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{{page}}}|:|4}}|See table]]')=More information;limit=5000
|format=dynamic table
|rows per page=150
}}

Show 102550100150 entries

Search:

Table	Column	Changed in release	Type of change	More information
Table	Column	Changed in release	Type of change	More information
No data available in table

Showing 0 to 0 of 0 entries

PreviousNext