Posted Thu, 15 Mar 2018 22:16:30 GMT by Vinny Johnson Consultant

I am doing a migration from Fortis to DocuWare without the tool.  I need to capture the folder values from the FTBContainer tables and possibly import them as index entries in DocuWare.  I have 30+ databases with multiple doctypes in each database.  I guess what i'm looking for is the most efficient way to query each database that will show all folder values in columns associated with the F_documentID that describe the heirarchy  (top level, level1, level2, level3, etc....) of the folders as well as the index values.   

See poorly written query attached in screenshot.



Posted Thu, 15 Mar 2018 22:32:52 GMT by Ryan Ciszkowski Software Support Analyst

Good Evening Vinny, 

Are you on Fortis 6.11 SP1 or 6.12? 
Given the topic, would you be able to please create a Support Request through the Support Portal and we can take it further from there.

Ryan Ciszkowski
Software Support Specialist
Support Team Fortis – America

You must be signed in to post in this forum.