11-06-2011, 11:09 PM
(11-06-2011, 03:12 AM)dgbaker Wrote: Hi there, thanks for the reply.
Our installation has actual rewritten/customized Core files and everything. We've turned it into a Case Management System. The issue we are having is that our Folder tables now have 6 added columns which houses information regarding the documents within that folder. For example: Say all the documents are related to Case #1234, the folder is actually named 1234 with other information added. So when a user searches they want to search for 1234 which would bring up all documents within a folder that has 1234 within it's name/data/information.
I've reviewed the search functions and seen the SQL calls, but when we try to expand this to include other tables, we get undefined errors regarding the added tables. I think if we could figure out where to define the the extra tables it would work.
Without having tested it, a left join on tblFolder and searching in the fields of tblFolder should do. You will only be able to search those folders which are direct parents of the documents.
Uwe