Question:
Which external database data types correspond with DocuWare index fields?
Answer:
Please refer to the below diagram of which external database data types correspond with DocuWare index fields;
Which external database data types correspond with DocuWare index fields?
Answer:
Please refer to the below diagram of which external database data types correspond with DocuWare index fields;
DocuWare Data Type (Index fields) | Database Data Type |
Text | nvarchar |
Date | datetime |
Numeric | int |
Memo | nvarchar(Max) |
Keyword | is not a data type |
Decimal | decimal |
DateTime | datetime2 |
Table | is not a data type |
By product design, when utilizing DocuWare index fields with external database data types, please note the following information;
- Numeric data types are compatible with each other.
- Character data types are compatible with each other.
- Binary data types are compatible with each other.
- Keep in mind that if you set the size of a variable, you can't assign the value to another variable that is larger. For example, text that is nvarchar can't be assigned a nvarchar max.
KBA is applicable to both Cloud and On-premise Organizations.