Maintenance Notice - PDF Generation
Dynamic PDF generation for web-based content is temporarily unavailable. This maintenance affects dynamic PDF files that are generated from either the HTML-based page or manual that you are viewing. Links that normally allow this functionality have been hidden, and will reappear as soon as the feature is restored.


Note: Access to static files, including PDF files that are not dynamically generated from our web-based content, is unaffected.

Jump to: navigation, search

(Created page with "{{#cargo_query: tables=PDMTable,PDMColumn |join on=PDMTable._pageName=PDMColumn._pageName |fields=CONCAT('',PDMTable.tableName,'')=table,PDMColumn.c...")
 
 
Line 3: Line 3:
 
|join on=PDMTable._pageName=PDMColumn._pageName
 
|join on=PDMTable._pageName=PDMColumn._pageName
 
|fields=CONCAT('[[',PDMTable._pageName,'|',PDMTable.tableName,']]')=table,PDMColumn.colName=column,PDMColumn.dataType_MSSQL=MSSQL,PDMColumn.dataType_Postgre=Postgre
 
|fields=CONCAT('[[',PDMTable._pageName,'|',PDMTable.tableName,']]')=table,PDMColumn.colName=column,PDMColumn.dataType_MSSQL=MSSQL,PDMColumn.dataType_Postgre=Postgre
|where=PDMColumn._pageName LIKE "Documentation:GIM:Library:%%:8.5DRAFT" AND PDMColumn.dataType_Postgre LIKE "varchar%%" AND IF(PDMColumn.dataType_MSSQL LIKE "nvarchar%%",SUBSTRING(PDMColumn.dataType_MSSQL,2,LENGTH(PDMColumn.dataType_Postgre)) NOT LIKE PDMColumn.dataType_Postgre,SUBSTRING(PDMColumn.dataType_MSSQL,1,LENGTH(PDMColumn.dataType_Postgre)) NOT LIKE PDMColumn.dataType_Postgre)
+
|where=PDMColumn._pageName LIKE "Documentation:GIM:Library:%%:8.5DRAFT" AND PDMColumn.dataType_Postgre LIKE "varchar%%" AND IF(PDMColumn.dataType_MSSQL LIKE "nvarchar%%",SUBSTRING(PDMColumn.dataType_MSSQL,2,LENGTH(PDMColumn.dataType_Postgre)) NOT LIKE PDMColumn.dataType_Postgre,IF(LENGTH(PDMColumn.dataType_MSSQL)>14,SUBSTRING(PDMColumn.dataType_MSSQL,-LENGTH(PDMColumn.dataType_Postgre),LENGTH(PDMColumn.dataType_Postgre)) NOT LIKE PDMColumn.dataType_Postgre,PDMColumn.dataType_MSSQL NOT LIKE PDMColumn.dataType_Postgre))
 
|format=dynamic table
 
|format=dynamic table
 
|rows per page=100
 
|rows per page=100
 
}}
 
}}

Latest revision as of 20:18, November 8, 2019

table column MSSQL Postgre
table column MSSQL Postgre
CALLBACK_DIM_1 CALLBACK_OFFER_TYPE varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_1 CALLBACK_TYPE varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_1 CHANNEL varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_1 CONNECT_ORDER varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_2 CALL_DIRECTION varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_2 DIAL_DIALOG_RESULT varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_2 FINAL_DIAL_RESULT varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_2 OFFER_TIMING varchar(170)/nvarchar(170) varchar(255)
CALLBACK_DIM_3 FINAL_TARGET varchar(170)/nvarchar(170) varchar(255)
GROUP_ANNEX KEYNAME varchar(255)/nvarchar(200) varchar(255)
GROUP_ANNEX SECTIONNAME varchar(255)/nvarchar(200) varchar(255)
INTERACTION_DESCRIPTOR BUSINESS_RESULT nvarchar(170) varchar(255)
INTERACTION_DESCRIPTOR CUSTOMER_SEGMENT nvarchar(170) varchar(255)
INTERACTION_DESCRIPTOR SERVICE_SUBTYPE nvarchar(170) varchar(255)
INTERACTION_DESCRIPTOR SERVICE_TYPE nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_2 SURVEY_SQ1 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_2 SURVEY_SQ2 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ3 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ4 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ5 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ6 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_3 SURVEY_SQ7 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ10 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ8 nvarchar(170) varchar(255)
POST_CALL_SURVEY_DIM_4 SURVEY_SQ9 nvarchar(170) varchar(255)
RESOURCE_ANNEX KEYNAME varchar(255)/nvarchar(200) varchar(255)
RESOURCE_ANNEX SECTIONNAME varchar(255)/nvarchar(200) varchar(255)
SDR_GEO_LOCATION COUNTRY_NAME nvarchar(170) varchar(255)
SDR_GEO_LOCATION REGION nvarchar(170) varchar(255)
SDR_GEO_LOCATION TIMEZONE nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I1 IQ1 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I1 IQ2 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I1 IQ3 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I1 IQ4 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I1 IQ5 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I2 IQ10 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I2 IQ6 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I2 IQ7 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I2 IQ8 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_I2 IQ9 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S1 SQ1 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S1 SQ2 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S1 SQ3 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S1 SQ4 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S1 SQ5 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S2 SQ10 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S2 SQ6 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S2 SQ7 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S2 SQ8 nvarchar(170) varchar(255)
SDR_SURVEY_QUESTIONS_S2 SQ9 nvarchar(170) varchar(255)
SDR_SURVEY_S1 SQ1 nvarchar(170) varchar(255)
SDR_SURVEY_S1 SQ2 nvarchar(170) varchar(255)
SDR_SURVEY_S1 SQ3 nvarchar(170) varchar(255)
SDR_SURVEY_S1 SQ4 nvarchar(170) varchar(255)
SDR_SURVEY_S1 SQ5 nvarchar(170) varchar(255)
SDR_SURVEY_S2 SQ10 nvarchar(170) varchar(255)
SDR_SURVEY_S2 SQ6 nvarchar(170) varchar(255)
SDR_SURVEY_S2 SQ7 nvarchar(170) varchar(255)
SDR_SURVEY_S2 SQ8 nvarchar(170) varchar(255)
SDR_SURVEY_S2 SQ9 nvarchar(170) varchar(255)
USER_DATA_CUST_DIM_1 DIM_ATTRIBUTE_1 Through DIM_ATTRIBUTE_5 nvarchar(170) varchar(255)
This page was last edited on November 8, 2019, at 20:18.