Views:

Scenario:
There may be several reasons why you need to know where the documents of a specific Document Tray (Web Basket) are stored in the file system.
One reason could be that a user accidentally deletes some documents from their tray and they must be recovered from backup. DocuWare does not provide a restore workflow for Document Trays at this time.

Solution:
In the DocuWare System database (DWSYSTEM) execute this query:


MySQL
SELECT NAME, TYPE, SETTINGS FROM DWFCSETTINGS WHERE TYPE LIKE "‘%WebBasket%";

MSSQL
SELECT NAME, TYPE, SETTINGS FROM DWFCSETTINGS WHERE TYPE LIKE ‘%WebBasket%’

Find the name of the Tray in the list and then look at the settings field. You can see the logical disk number of the basket that is assigned to the user.

Now you can browse the backup of the logical disk to find the documents. Note, that the documents must be manually re-imported to the Document Tray.