Jump to: navigation, search
Line 7: Line 7:
 
* Column modified__full = 25
 
* Column modified__full = 25
 
* Column modified -- itemized = 29
 
* Column modified -- itemized = 29
−
Ideally, total number of entries should be 63+70+29 = 162
+
Ideally, total number of entries should be 63+70+29 = 162 {{Editgrn_open}}NEED TO VERIFY BY DPL{{Editgrn_close}}
  
−
===Column modified -- itemized===
 
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=PDMColumn,PDMColumn__modified
+
tables=PDMTable,PDMColumn
−
|join on=PDMColumn._ID=PDMColumn__modified._rowID
+
|join on=PDMTable._pageName=PDMColumn._pageName
−
|fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn__modified._value=Column modified
+
|fields=IF((PDMColumn.introduced IS NULL),IF(PDMTable.introduced IS NOT NULL),PDMTable.tableName,'')=Table,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.colName,'')=Column,IF((PDMColumn.introduced IS NULL),PDMTable.introduced,'')=TableIntroduced,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.introduced,'')=ColumnIntroduced
−
|where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL)
+
|where=(SUBSTRING(PDMTable._pageName, 15,{{#len:{{#explode:{{FULLPAGENAME}}|:|1}}}}) LIKE "GIM") AND (PDMTable._pageName LIKE  
 +
{{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND ((PDMTable.introduced IS NOT NULL)  OR (PDMColumn.introduced IS NOT NULL))
 
|format=dynamic table
 
|format=dynamic table
−
|rows per page=100
+
|named args=yes
 
}}
 
}}
  
−
===Column modified__full===
+
Trying with a formatting template.
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=PDMColumn
+
tables=PDMTable,PDMColumn
−
|fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn.modified__full=Column modified
+
|join on=PDMTable._pageName=PDMColumn._pageName
−
|where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL)
+
|fields=PDMTable._pageName=Page,PDMTable.tableName=Table,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.colName,'')=Column,IF((PDMColumn.introduced IS NULL),PDMTable.introduced,'')=TableIntroduced,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.introduced,'')=ColumnIntroduced
−
|format=dynamic table
+
|where=(SUBSTRING(PDMTable._pageName, 15,{{#len:{{#explode:{{FULLPAGENAME}}|:|1}}}}) LIKE "GIM") AND (PDMTable._pageName LIKE  
−
|rows per page=100
+
{{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND ((PDMTable.introduced IS NOT NULL) OR (PDMColumn.introduced IS NOT NULL))
 +
|intro=
 +
{{{!}} class="sortable"
 +
! '''Table'''
 +
! '''Column'''
 +
! '''Change occurred in'''
 +
! '''Type of change'''
 +
{{!}}-
 +
|outro=
 +
{{!}}}
 +
|format=template
 +
|template=PDMSchemaChangeSummary
 +
|named args=yes
 
}}
 
}}
  
−
===Modified===
+
You need all sorts of nested ifs for PDMTable.introduced with and without PDMColumn.introduced. e.g., This query doesn't allow for the permutations.
−
 
 
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=PDMTable,PDMColumn
 
tables=PDMTable,PDMColumn
 
|join on=PDMTable._pageName=PDMColumn._pageName
 
|join on=PDMTable._pageName=PDMColumn._pageName
−
|fields=PDMTable._pageName=Table,PDMTable.introduced=Table Introduced,PDMColumn.introduced=Column Introduced,PDMColumn.modified__full=Column Modified
+
|fields=PDMTable._pageName=Table,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.colName,'')=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,PDMColumn.introduced)=Change occurred in,IF((PDMTable.introduced IS NOT NULL),"New table","New column")=Type of change
 
|where=(SUBSTRING(PDMTable._pageName, 15,{{#len:{{#explode:{{FULLPAGENAME}}|:|1}}}}) LIKE "GIM") AND (PDMTable._pageName LIKE  
 
|where=(SUBSTRING(PDMTable._pageName, 15,{{#len:{{#explode:{{FULLPAGENAME}}|:|1}}}}) LIKE "GIM") AND (PDMTable._pageName LIKE  
−
{{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified HOLDS LIKE "%.%")
+
{{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:8.5PDMSource"}}) AND ((PDMTable.introduced IS NOT NULL) OR (PDMColumn.introduced IS NOT NULL))
 
|format=dynamic table
 
|format=dynamic table
−
|rows per page = 100
 
 
}}
 
}}
  
 +
===Column modified -- itemized===
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified
+
tables=PDMColumn,PDMColumn__modified
−
|join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID
+
|join on=PDMColumn._ID=PDMColumn__modified._rowID
−
|fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:Table-',PDMTable.tableName,':{{PONYDOCSVERSION}}|',PDMTable.tableName,']]')=Table,IF( (PDMColumn.introduced IS NOT NULL),PDMColumn.colName,'')=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.introduced,''))=Change occurred in
+
|fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn__modified._value=Column modified
−
|where=(SUBSTRING(PDMTable._pageName, 15) LIKE "{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:%%") AND (PDMTable._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="%:8.5DRAFT%"|preview|released|#default="%8.5PDMSource%"}}) AND ((PDMTable.introduced IS NOT NULL) OR (PDMTable.modified HOLDS LIKE "%.%"))
+
|where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL)
 
|format=dynamic table
 
|format=dynamic table
−
|rows per page = 100
+
|rows per page=100
 
}}
 
}}
  
 +
===Column modified__full===
 
{{#cargo_query:
 
{{#cargo_query:
−
tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified
+
tables=PDMColumn
−
|join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID
+
|fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn.modified__full=Column modified
−
|fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:Table-',PDMTable.tableName,':{{PONYDOCSVERSION}}|',PDMTable.tableName,']]')=Table,PDMColumn.colName=Column,IF((PDMTable.introduced IS NOT NULL),PDMTable.introduced,IF((PDMColumn.introduced IS NOT NULL),PDMColumn.introduced,IF((PDMColumn__modified._value IS NOT NULL),PDMColumn__modified._value,'')))=Change occurred in
+
|where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL)
−
|where=(SUBSTRING(PDMTable._pageName, 15) LIKE "%{{#explode:{{FULLPAGENAME}}|:|1}}%") AND (PDMTable._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="%:8.5DRAFT%"|preview|released|#default="%8.5PDMSource%"}}) AND ((PDMTable.introduced IS NOT NULL) OR (PDMTable.modified HOLDS LIKE "%.%"))
 
 
|format=dynamic table
 
|format=dynamic table
−
|rows per page = 100
+
|rows per page=100
 
}}
 
}}
 +
  
 
Query that used to work but doesn't since I changed PDMTable.modified to a list:
 
Query that used to work but doesn't since I changed PDMTable.modified to a list:

Revision as of 20:58, July 4, 2018

Summary of Info Mart Schema Changes

The following tables summarize Genesys Info Mart schema changes between 8.5 releases.

  • Table introduced = 63
  • Column introduced = 70
  • Column modified__full = 25
  • Column modified -- itemized = 29

Ideally, total number of entries should be 63+70+29 = 162 NEED TO VERIFY BY DPL

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT IF((`cargo__PDMColumn`.`introduced` IS NULL),IF(`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`tableName`,) AS `Table`,IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`colName`,) AS `Column`,IF((`cargo__PDMColumn`.`introduced` IS NULL),`cargo__PDMTable`.`introduced`,) AS `TableIntroduced`,IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`introduced`,) AS `ColumnIntroduced` FROM `cargo__PDMTable` LEFT OUTER JOIN `cargo__PDMColumn` ON ((`cargo__PDMTable`.`_pageName`=`cargo__PDMColumn`.`_pageName`)) WHERE (SUBSTRING(`cargo__PDMTable`.`_pageName`, 15,3) LIKE "GIM") AND (`cargo__PDMTable`.`_pageName` LIKE "Documentation:GIM:Library:%%:8.5PDMSource") AND ((`cargo__PDMTable`.`introduced` IS NOT NULL) OR (`cargo__PDMColumn`.`introduced` IS NOT NULL)) ORDER BY IF((`cargo__PDMColumn`.`introduced` IS NULL),IF(`cargo__PDMTable`.`introduced` IS NOT NULL),`cargo__PDMTable`.`tableName`,),IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`colName`,),IF((`cargo__PDMColumn`.`introduced` IS NULL),`cargo__PDMTable`.`introduced`,),IF((`cargo__PDMColumn`.`introduced` IS NOT NULL),`cargo__PDMColumn`.`introduced`,) 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 '),`cargo__PDMTable`.`tableName`,) AS `Table`,IF((`cargo__PDMColumn`.`introduce' at line 1 (127.0.0.1)

Trying with a formatting template.

Table Column Change occurred in Type of change

Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information


Table Column Changed in release Type of change More information
Table Column Changed in release Type of change More information

More...

You need all sorts of nested ifs for PDMTable.introduced with and without PDMColumn.introduced. e.g., This query doesn't allow for the permutations.

Table Column Change occurred in Type of change
Table Column Change occurred in Type of change
Documentation:GIM:Library:Table-ANCHOR FLAGS:8.5PDMSource CUSTOMER_LEFT_FIRST 8.5.004 New column
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS BOT NAME DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION DIM:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5PDMSource 8.5.011 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIAL RESULTS:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK DIM 4:8.5PDMSource 8.5.009.20 New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CALLBACK_DIAL_RESULTS_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CALLBACK_DIM_4_KEY 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource CUSTOMER_ANI 8.1.402. Supported for on-premises deployments starting with release 8.5.005. New table

More...

Column modified -- itemized

Table Column Column modified
Table Column Column modified
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_OFFER_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CHANNEL 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CONNECT_ORDER 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource CALL_DIRECTION 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource DIAL_DIALOG_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource FINAL_DIAL_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource OFFER_TIMING 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource FINAL_TARGET 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DS_AUDIT_KEY 8.5.008 (data type increased from 10 to 19 digits)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource FIRST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_CALLBACK_OFFERED_TS 8.5.008 (default value added)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORIGINATION_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORS_SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource PAGE_QUERY 8.5.012.15 (No longer a mandatory field)
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource PROPAGATION_RULE 8.5.001 (IRF_INITIAL value is added).
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource PROPAGATION_RULE 8.5.006 (IRF_ROUTE value is added)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MEDIA_SERVER_IXN_GUID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MESSAGE 8.5.009.20 (default value no longer defined)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource START_DATE_TIME_KEY 8.5.011 (added to the composite primary key in nonpartitioned databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR_ID 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource CUSTOMER_FOUND 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_MODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_STATUS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_USE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource BUSINESS_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource CUSTOMER_SEGMENT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_SUBTYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource STATUS 8.5.001 (error code 26 added)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource SUBJECT 8.5.007 (data type extended from 255 to 1024 characters)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ANCHOR_FLAGS_KEY 8.5.004 (scope extended)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_INIT_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_DURATION 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_DURATION 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource LAST_INTERACTION_RESOURCE 8.5.003 and 8.5.004 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource QUEUE_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ROUTING_POINT_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE 8.5.001 (InternalConferenceInvite subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE 8.5.005 (OutboundCallback subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE_CODE 8.5.001 (INTERNALCONFERENCEINVITE subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE_CODE 8.5.005 (OUTBOUNDCALLBACK subtype added)
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource CUSTOM_DATA_1 through CUSTOM_DATA_16 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types).
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource CUSTOM_DATA_1 through CUSTOM_DATA_16 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IAGENTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICALLSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICOMPANYSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IPRODUCTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IQ1 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ2 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ3 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ4 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ5 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ6 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ10 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ7 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ8 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ9 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_COMPLETE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_IRECOMMENDSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_RECORDING 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource RESOURCE_SUBTYPE 8.5.003.17 (new value, Person, added for the Agent resource type)
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_TITLE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_VERSION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_CATEGORY 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource FINAL_DISPOSITION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource CALL_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource MEDIA_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource ATRIBUTE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource DNIS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource APPLICATION_EXIT_POINT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource URL 8.5.008.29 (behavior changed)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource URL 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource SUCCESS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource METHOD 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource SERVICE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource SERVICE_RESPONSE_DESC 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)

More...

Column modified__full

Table Column Column modified
Table Column Column modified
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_OFFER_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CALLBACK_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CHANNEL 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource CONNECT_ORDER 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource CALL_DIRECTION 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource DIAL_DIALOG_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource FINAL_DIAL_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource OFFER_TIMING 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource FINAL_TARGET 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource DS_AUDIT_KEY 8.5.008 (data type increased from 10 to 19 digits)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource FIRST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_CALLBACK_OFFERED_TS 8.5.008 (default value added)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource LAST_OUT_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORIGINATION_IXN_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource ORS_SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource PAGE_QUERY 8.5.012.15 (No longer a mandatory field)
Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource PROPAGATION_RULE 8.5.006 (IRF_ROUTE value is added) • 8.5.001 (IRF_INITIAL value is added).
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MEDIA_SERVER_IXN_GUID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource MESSAGE 8.5.009.20 (default value no longer defined)
Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource START_DATE_TIME_KEY 8.5.011 (added to the composite primary key in nonpartitioned databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource MODEL_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource PREDICTOR_ID 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource CUSTOMER_FOUND 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_MODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_STATUS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource GPM_USE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource BUSINESS_RESULT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource CUSTOMER_SEGMENT 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_SUBTYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource SERVICE_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource STATUS 8.5.001 (error code 26 added)
Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource SUBJECT 8.5.007 (data type extended from 255 to 1024 characters)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ANCHOR_FLAGS_KEY 8.5.004 (scope extended)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_INIT_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_RING_DURATION 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_COUNT 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource CONS_RCV_TALK_DURATION 8.5.001 (scope expanded to include chat consultations)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource LAST_INTERACTION_RESOURCE 8.5.003 and 8.5.004 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource QUEUE_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource ROUTING_POINT_DURATION 8.1.2, 8.1.3, 8.1.4 (behavior changed)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE 8.5.005 (OutboundCallback subtype added) • 8.5.001 (InternalConferenceInvite subtype added)
Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource INTERACTION_SUBTYPE_CODE 8.5.005 (OUTBOUNDCALLBACK subtype added) • 8.5.001 (INTERNALCONFERENCEINVITE subtype added)
Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource CUSTOM_DATA_1 through CUSTOM_DATA_16 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) • 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types).
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IAGENTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICALLSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_ICOMPANYSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IPRODUCTSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource SURVEY_IQ1 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ2 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ3 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_IQ4 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ1 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource SURVEY_SQ2 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ3 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ4 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ5 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ6 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource SURVEY_SQ7 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ5 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_IQ6 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ10 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ8 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource SURVEY_SQ9 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ10 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ7 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ8 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource SURVEY_IQ9 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_COMPLETE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_IRECOMMENDSCORE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource SURVEY_RECORDING 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource RESOURCE_SUBTYPE 8.5.003.17 (new value, Person, added for the Agent resource type)
Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource SESSION_ID 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_ID 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_TITLE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource APPLICATION_VERSION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_CATEGORY 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource DISPOSITION_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource FINAL_DISPOSITION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource CALL_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource MEDIA_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource ATRIBUTE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource DNIS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource APPLICATION_EXIT_POINT 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource URL 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) • 8.5.008.29 (behavior changed)
Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource SUCCESS 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource METHOD 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource REQUEST_TYPE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource SERVICE_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource SERVICE_RESPONSE_DESC 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource COUNTRY_CODE 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)
Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource COUNTRY_NAME 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource REGION 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource TIMEZONE 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5PDMSource SELECTED_OPTION 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases)

More...


Query that used to work but doesn't since I changed PDMTable.modified to a list:

Error: operator for the virtual field 'PDMTable.modified' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
Comments or questions about this documentation? Contact us for support!