How to setup an autoindex to mark duplicate documents.

I need to be able to find all documents that have a duplicated field in a file cabinet, I've heard that this can be done with Autoindex, but so far, I haven't been able to get it to find the right documents. Does anyone know how to have an autoindex find a document and mark all additional documents that match a specified field. I have a field called "duplicate" so when the documents are found, I want the word "duplicated" in this field

Dear Rhys Woolley! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-165633-N7H4C for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team

I was able to do this for a recent migration.  I setup the criteria for Autoindex to search then in the match data tab I did a match on an external database.  This database was just the file cabinet database using the following SQL statement:

select count(DOCUMENT_ID) as counts, DOCUMENT_ID
from DWRPSTPA_ACTIVE.dbo.RPS_TPA
group by DOCUMENT_ID
having count(document_id) > 1

In the above SQL statement, DWRPSTPA_ACTIVE.dbo.RPS_TPA is the file cabinet's database and DOCUMENT_ID is actually an ID from another system used during the migration (not the DWDOCID).  It totals up the ID numbers and when the count is > 1 in the assign data tab I assigned the duplicate index a fixed value if yes for all matches

 

Dear Rhys Woolley, Dear Forum-Users,
Thank you for opening this thread. I have checked your question and can provide you with the following description:
KBA-36518 - How to flag duplicate documents already stored in the file cabinet
Within our Knowledge Base, we have several How-tos and other interesting guides and content that can help you with using DocuWare.
I hope the description will help you to evaluate all duplicate documents.
Kind regards
DocuWare Support