Posted Fri, 28 Feb 2020 16:52:51 GMT by Steve Shriver Application Specialist
In this small screen snippet of the bottom left corner of the viewer in the client, after the original file name there is a date. I assume this is the file date on disk (Date modified column in Windows Explorer), before it was imported into a document tray. Is that correct? 

Since it is displayed in the viewer I also assume it is stored in the DW database. Can anyone tell me where?

I would like to be able to report on the number of days between when a document actually came into the system and when it was finally processed, as opposed to when it was stored (DWStoreDate) and processed.

Many thanks,
Posted Fri, 28 Feb 2020 17:07:39 GMT by Steve Shriver Application Specialist
In this small screen snippet of the bottom left corner of the viewer in the client, after the original file name there is a date. I assume this is the file date on disk (Date modified column in Windows Explorer), before it was imported into a document tray. Is that correct? 

Since it is displayed in the viewer I also assume it is stored in the DW database. Can anyone tell me where?

I would like to be able to report on the number of days between when a document actually came into the system and when it was finally processed, as opposed to when it was stored (DWStoreDate) and processed.

Many thanks,
Posted Fri, 28 Feb 2020 17:35:10 GMT by Joe Kaufman Bell Laboratories Inc Application Development Manager
Steve,

That's a really good question.

I could not find that date anywhere in the DocuWare database. I checked the base dwdata table, the related _SECT table, and the related _PAGE table. Didn't find anything that matched.

So, I found the root document as stored in the file system on the DocuWare server. DocuWare stores the actual document in a defined hierarchy, and the file will always have an XML file beside it. In the XML file is a modification time that matches, and it matches the last modification time on the file itself. Since the viewer obviously pulls the document in from it's file-based location, it must get the information from the document as it does so, and displays the last time the document itself was modified/created when it was just a regular old file on disk.

I am not sure if that date resides anywhere else, and I am not sure if it comes back in the document information class when using the Platform SDK. That means I am not at all sure as to how you could easily pull that date on your own. Hopefully someone more in the know responds with a more thorough answer...

Thanks,
Joe Kaufman
Posted Fri, 20 Mar 2020 15:54:49 GMT by Tobias Getz DocuWare GmbH Director Product
Hi Steve, hi Joe,
this date is file specific, so if you have a document with several files, each file has its specific date.
Until version 6.12 file specific data was stored in the XML files mentioned by Joe. Since version 7.0 DocuWare stores this data in the database for newly stored documents. If you have the option "Backup index data to storage location" enabled, then this data is again in a file near the document, but with a different structure.

You can access this data with the DocuWare platform with this URL: https://[ServerURL]/DocuWare/Platform/FileCabinets/[FileCabinetGUID]/Sections?docid=[DocID]
So this would be the consistent way to get this property from DocuWare as this works across versions and also on premises and Cloud

You must be signed in to post in this forum.