Search folder name, comment etc...

[dgbaker]

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

Hi thanks for the reply. Will try that as that should do cause we only need the folder/document relationships for each.

David