When our DocuWare was originally set up, the company that did the work didn't set the users document trays correctly. I ran the following query
SELECT U.name, U.email, CAST(U.settings.value('(/DWUser/@defaultWebBasket)[1]', 'VARCHAR(50)') AS UNIQUEIDENTIFIER) AS defaultWebBasket, C.NAME
FROM
dwsystem.dbo.dwuser AS U
LEFT JOIN dwbaskets.dbo.DWCABINETS AS C
ON CAST(U.settings.value('(/DWUser/@defaultWebBasket)[1]', 'VARCHAR(50)') AS UNIQUEIDENTIFIER) = C.GUID
to determine which basket tray is the user's default. Example, for John Doe - when I look at the document trays, I don't see his. Looking at this query he has "WEB_BASKET_BUFFER_90". If I go into configurations and look for "WEB_BASKET_BUFFER_90" - it is not listed. How do I go about fixing this so I can do configurations for Outlook Email so the user can upload to their tray before they store it to a file cabinet?
