Publicado Thu, 02 May 2019 15:24:19 GMT por Sabino Civita
What is the easiest method to allow a Docuware field to have multiple values assigned to it?

Thanks to everybody

Actually I'm on 6.12 release.

Sabino
Publicado Thu, 02 May 2019 17:41:33 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas
You need to create a field type of "Keyword".


Phil Robson
Senior Director Support Americas
 
Publicado Fri, 03 May 2019 05:25:58 GMT por Sabino Civita
Hello Phil, I explain better my problem.
I have to archive an invoice. This invoice belongs to two different dossiers. I use StorageRobot a third party software to do massive archiving. For match exactly the invoice I do a sql select with an AS400 view. In my cabinet I have only one field 'dossier', so how to archive correctly invoice putting the two references ? My aim is that when I search using 'dossier' field I find this invoice in both cases.

I hope now it's more clear.

Sabino
Publicado Fri, 03 May 2019 10:08:20 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas
Sabino,
I still think that a keyword field is the best method. When you search in DocuWare for a value in a keyword field it will return all documents that have that value in the list.
So for example, you store Invoice 123456. This invoice belongs to Dossiers ABCD and WXYZ.
Store the invoice adding the 2 dossier numbers to the keyword field (which you call Dossier).
Now you when you search the Dossier field, you can search on either dossier id and it will return the invoice. The good thing is that you can have an invoice that belongs to many dossiers and searching for any of the dossier id's will return the correct invoice.

There is no other method in today's databases available to create a 1 to many relationship.
The only other alternative is to store the dossier id's in a single text field as one string and then use wild cards to search. This is not a good method.

Phil Robson
Senior Director Support Americas

 
Publicado Fri, 03 May 2019 12:35:28 GMT por Sabino Civita
Hello Phil, thanks a lot!
But, as I said, I use Docuscan StorageRobot to do massive archiving matching an AS400 view. How to store dossier numbers in keyword field ?? I have to create a new field in the view that is a concatenate of the dossiers ?? Separating the dossier numbers in the field with a space ? Or how ?

Thank you so much in advance

Sabino
Publicado Fri, 03 May 2019 13:13:28 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas
Sabino,
I can only speak for storing documents with DocuWare. I do not know StorageRobot, so I cannot assist you further. At some point DocuWare must be storing the documents. How you address the keyword field with your 3rd party application is a question for Docuscan.

Now, I suggest that you create a small test file cabinet with 2 fields. Invoice Number (Text field), and Dossier (Keyword field). Store a few documents manually entering multiple dossier number in the dossier field. Then look at the database. You will have a main table, and a table with the name of the keyword field.
The documents are related via the DWDOCID.
For example you have DWDOCID 100. With 2 dossiers ABCDE and WXYZ.

Main table:
DWDOCID         INVOICE
100                    1234567

The keyword table is structured:
DWDOCID    DWKEYWORD
100               ABCDE
100               WXYZ

So a query to retrieve the invoice for dossier ABCDE:

SELECT * FROM [maintable] WHERE DWDOCID IN (SELECT DWDOCID FROM [keywordtable] WHERE DOSSIER = 'ABCDE')

At least this will show you the structure and how it works. Perhaps you can resolve the issue from there.


Phil Robson
Senior Director Support Americas
 

You must be signed in to post in this forum.