Views:
Question:
How do I make a database field a unique entry?

Answer:
Making a database field unique allows you to ensure that an entry for that field cannot be mistakenly stored twice. Please refer to the following guide to make a database field a unique entry;
  1. In the file cabinet where you would like to set this up, go to the Database Fields tab and select the field name you would like to make unique.

     
  2.  After selecting your desired database field, select the More Options button to bring up the unique field property.
         
  3. From More Options, the unique field property option will now be accessible. Additionally, the option to use a Database or DocuWare mechanism will also be displayed.
    Note: A database mechanism ensures that the entry appears only once. Thus, the query and storage can take place faster than with a DocuWare mechanism.


    DocuWare Mechanism 
    The DocuWare option is especially suited for special cases where the unique field is stored even without an entry. The background to this is that databases like Oracle and MSSQL interpret a field without an entry as a field with the entry [blank]. A second document without an entry in this field would not be possible. The unique field would then become required. In contrast, DocuWare and MySQL can ignore an empty field entry so that any number of documents with empty unique fields can be stored.​​​​

KBA is applicable for both Cloud and On-premise Organizations 

This article is valid for DocuWare versions: 7.1, 7.2, 7.3, 7.4, 7.5, 7.6, 7.7, 7.8, 7.9, 7.10, 7.11, File Cabinets, Database fields, Unique Entry