Posted Tue, 16 Oct 2018 08:26:08 GMT by Hameed Ogbara - left 05.2022 Technical Support

Good Morning,

How do i get the list of all indexed entries in an index field? For example, I have an index field called "Document Type". I want to have all the list of the index entries on the Document Type Field in an Excel format.

Regards.

 

Posted Fri, 19 Oct 2018 09:42:55 GMT by Simon H. Hellmann Wedderhoff IT GmbH Systemadministrator

Hello Hameed,

the easiest way is probably a simple SQL Statement to get the info from your dwdata.

SELECT DOCTYPE FROM archive GROUP BY DOCTYPE

This should give back a list of all the values stored in the index field "DOCTYPE" from your archive. You can then export that list to excel, depending on what Software you use to access the database.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

You must be signed in to post in this forum.