| Line 6: | Line 6: | ||
tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified | tables=PDMTable,PDMTable__modified,PDMColumn,PDMColumn__modified | ||
|join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID | |join on=PDMTable._ID=PDMTable__modified._rowID,PDMTable._pageName=PDMColumn._pageName,PDMColumn._ID=PDMColumn__modified._rowID | ||
| − | |fields=PDMTable. | + | |fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:',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,''))=Introduced in release |
| − | |where=PDMTable._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="%:8.5DRAFT%"|preview|released|#default="%8.5PDMSource%"}} AND ((PDMTable.introduced IS NOT NULL) OR (PDMTable__modified._value IS NOT NULL)) | + | |where=(SUBSTRING(PDMTable._pageName, 15) LIKE "%GIM%") AND (PDMTable._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="%:8.5DRAFT%"|preview|released|#default="%8.5PDMSource%"}}) AND ((PDMTable.introduced IS NOT NULL) OR (PDMTable__modified._value IS NOT NULL)) |
|format=dynamic table | |format=dynamic table | ||
| + | |rows per page = 100 | ||
}} | }} | ||
| + | Query that used to work but doesn't since I changed PDMTable.modified to a list: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=PDMTable | tables=PDMTable | ||
Revision as of 13:00, June 26, 2018
Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
| Table | Column | Introduced in release |
|---|---|---|
| Table | Column | Introduced in release |
| ANCHOR_FLAGS | ANCHOR_FLAGS_KEY | |
| ANCHOR_FLAGS | ANCHOR_FLAGS_KEY | |
| ANCHOR_FLAGS | CREATE_AUDIT_KEY | |
| ANCHOR_FLAGS | CREATE_AUDIT_KEY | |
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_THRD | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | UPDATE_AUDIT_KEY | |
| ANCHOR_FLAGS | UPDATE_AUDIT_KEY | |
| ATTEMPT_DISPOSITION | ATTEMPT_DISPOSITION_KEY | |
| ATTEMPT_DISPOSITION | CAUSE | |
| ATTEMPT_DISPOSITION | CAUSE_CODE | |
| ATTEMPT_DISPOSITION | CAUSE_ID | |
| ATTEMPT_DISPOSITION | CREATE_AUDIT_KEY | |
| ATTEMPT_DISPOSITION | DESCRIPTOR | |
| ATTEMPT_DISPOSITION | DESCRIPTOR_CODE | |
| ATTEMPT_DISPOSITION | UPDATE_AUDIT_KEY | |
| BGS_BOT_DIM | BOT_CATEGORY | 8.5.011 |
| BGS_BOT_DIM | BOT_FUNCTION | 8.5.011 |
| BGS_BOT_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_BOT_DIM | ID | 8.5.011 |
| BGS_BOT_NAME_DIM | BOT_NAME | 8.5.011 |
| BGS_BOT_NAME_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_BOT_NAME_DIM | ID | 8.5.011 |
| BGS_SESSION_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_SESSION_DIM | ENDED_ABNORMALLY | 8.5.011 |
| BGS_SESSION_DIM | ENDED_BY | 8.5.011 |
| BGS_SESSION_DIM | END_REASON | 8.5.011 |
| BGS_SESSION_DIM | END_RESULT | 8.5.011 |
| BGS_SESSION_DIM | ID | 8.5.011 |
| BGS_SESSION_DIM | REJECTED_TO_START | 8.5.011 |
| BGS_SESSION_FACT | BGS_BOT_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | BGS_BOT_NAME_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | BGS_SESSION_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | CBS_ID | 8.5.011 |
| BGS_SESSION_FACT | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_SESSION_FACT | DURATION | 8.5.011 |
| BGS_SESSION_FACT | END_DATE_TIME_KEY | 8.5.011 |
| BGS_SESSION_FACT | END_TS | 8.5.011 |
| BGS_SESSION_FACT | INTERACTION_SDT_KEY | 8.5.011 |
| BGS_SESSION_FACT | MEDIA_SERVER_IXN_GUID | 8.5.011 |
| BGS_SESSION_FACT | MEDIA_TYPE_KEY | 8.5.011 |
| BGS_SESSION_FACT | MESSAGES_RECEIVED | 8.5.011 |
| BGS_SESSION_FACT | MESSAGES_SENT | 8.5.011 |
| BGS_SESSION_FACT | START_DATE_TIME_KEY | 8.5.011 |
| BGS_SESSION_FACT | START_TS | 8.5.011 |
| BGS_SESSION_FACT | TENANT_KEY | 8.5.011 |
| BGS_SESSION_FACT | UPDATE_AUDIT_KEY | 8.5.011 |
| CALLBACK_DIAL_RESULTS | CREATE_AUDIT_KEY | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_1_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_2_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_3_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_4_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_5_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | ID | 8.5.009.20 |
| CALLBACK_DIM_1 | CALLBACK_OFFER_TYPE | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CALLBACK_TYPE | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CHANNEL | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CONNECT_ORDER | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | CALL_DIRECTION | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | DIAL_DIALOG_RESULT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | FINAL_DIAL_RESULT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | OFFER_TIMING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | DISPOSITION | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | FINAL_TARGET | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_4 | ABANDONED_DURING_CB_OFFER | 8.5.009.20 |
| CALLBACK_DIM_4 | CREATE_AUDIT_KEY | 8.5.009.20 |
| CALLBACK_DIM_4 | DIAL_IGNORING_AVAILABILITY | 8.5.009.20 |
| CALLBACK_DIM_4 | ID | 8.5.009.20 |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | CALLBACK_ACCEPTED | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
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!