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.
