(Created page with "= Summary of Info Mart Schema Changes = The following tables summarize Genesys Info Mart schema changes between 8.5 releases. {{#cargo_query: tables=PDMTable |fields=PDMTabl...") |
|||
| Line 2: | Line 2: | ||
The following tables summarize Genesys Info Mart schema changes between 8.5 releases. | The following tables summarize Genesys Info Mart schema changes between 8.5 releases. | ||
| + | |||
| + | {{#cargo_query: | ||
| + | tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified | ||
| + | |join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID | ||
| + | |fields=PDMTable._pageName=Table,PDMColumn.colName=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,IF((PDMColumn.modified IS NOT NULL),PDMColumn.introduced,''))=Introduced in release,IF((PDMColumn__modified._value IS NOT NULL),PDMColumn__modified._value,'')=Modified in release | ||
| + | |where=PDMTable._pageName LIKE "%Library:%:8.5DRAFT" | ||
| + | |format=dynamic table | ||
| + | }} | ||
{{#cargo_query: | {{#cargo_query: | ||
| Line 10: | Line 18: | ||
|rows per page = 100 | |rows per page = 100 | ||
}} | }} | ||
| + | |||
| + | [[Category:V:GIM:8.5DRAFT]] | ||
Revision as of 20:24, June 25, 2018
Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
Query: SELECT `cargo__PDMTable`.`_pageName` AS `Table`,`cargo__PDMColumn`.`colName` AS `Column`,IF((`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`introduced`,IF((`cargo__PDMColumn`.`modified` IS NOT NULL),`cargo__PDMColumn`.`introduced`,)) AS `Introduced in release`,IF((`cargo__PDMColumn__modified`.`_value` IS NOT NULL),`cargo__PDMColumn__modified`.`_value`,) AS `Modified in release` FROM `cargo__PDMTable` LEFT OUTER JOIN `cargo__PDMTable__modified` ON ((`cargo__PDMTable`.`_ID`=`cargo__PDMTable__modified`.`_rowID`)) LEFT OUTER JOIN `cargo__PDMColumn` ON ((`cargo__PDMTable`.`_pageName`=`cargo__PDMColumn`.`_pageName`)) LEFT OUTER JOIN `cargo__PDMColumn__modified` ON ((`cargo__PDMColumn`.`_ID`=`cargo__PDMColumn__modified`.`_rowID`)) WHERE `cargo__PDMTable`.`_pageName` LIKE "%Library:%:8.5DRAFT" ORDER BY `cargo__PDMTable`.`_pageName`,`cargo__PDMColumn`.`colName`,IF((`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`introduced`,IF(`cargo__PDMColumn__modified`.`_valueIS` NOT NULL),`cargo__PDMColumn`.`introduced`,)),IF((`cargo__PDMColumn__modified`.`_value` IS NOT NULL),`cargo__PDMColumn__modified`.`_value`,) LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL),`cargo__PDMColumn`.`introduced`,)),IF((`cargo__PDMColumn__modified`.`_va' at line 1 (127.0.0.1)