Search folder name, comment etc...

[dgbaker]

We have are running 3.1.0-RC1 which has been heavily customized so upgrading to a newer version is not possible.

The issue we are facing is the ability to have the search facility also search the folder information and show the folder/data. Example below:

Our folders now have 8 fields of information on them. We use this to determine where documents get uploaded to based on that information. Our documents don't have those field data information associated with them, only the containing folder has it.

We've tried to expand the current search query to include the tblFolders table but never works.

Any ideas how we can expand to include other tables in the search? We can then take the info in the array and sort it out.

Thanks
Dave

[dgbaker]

Nobody has any insight on how to achieve this??

---

Nobody has any insight on how to achieve this??

[administrator]

Nobody has any insight on how to achieve this??

---

Nobody has any insight on how to achieve this??

hi DGBaker

First of all we wanna thank you for using LetoDMS as your Document Management System. now for you question are you trying to expand your search capabilities? what are you trying to achieve here? or because you can search for folder name, comment as long they are in the keyword area ... or you can use our new version which uses Lucene i know your version is customized for your use but i am pretty sure you only customized the configuration files or template file to see different names ? so you can use still our new version and don't update does file or folder is that way you can install our version on a different folder and with the same database and see if it works for you? or you can export the database you have and make a new database so u don't mistakenly mass up your old version.

Thanks

LetoDMS Admin

[dgbaker]

Nobody has any insight on how to achieve this??

---

Nobody has any insight on how to achieve this??

hi DGBaker

First of all we wanna thank you for using LetoDMS as your Document Management System. now for you question are you trying to expand your search capabilities? what are you trying to achieve here? or because you can search for folder name, comment as long they are in the keyword area ... or you can use our new version which uses Lucene i know your version is customized for your use but i am pretty sure you only customized the configuration files or template file to see different names ? so you can use still our new version and don't update does file or folder is that way you can install our version on a different folder and with the same database and see if it works for you? or you can export the database you have and make a new database so u don't mistakenly mass up your old version.

Thanks

LetoDMS Admin

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.

Thanks very much for your help.

David

[steinm]

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

[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

[dgbaker]

Nobody has any insight on how to achieve this??

---

Nobody has any insight on how to achieve this??

hi DGBaker

First of all we wanna thank you for using LetoDMS as your Document Management System. now for you question are you trying to expand your search capabilities? what are you trying to achieve here? or because you can search for folder name, comment as long they are in the keyword area ... or you can use our new version which uses Lucene i know your version is customized for your use but i am pretty sure you only customized the configuration files or template file to see different names ? so you can use still our new version and don't update does file or folder is that way you can install our version on a different folder and with the same database and see if it works for you? or you can export the database you have and make a new database so u don't mistakenly mass up your old version.

Thanks

LetoDMS Admin

Hi Admin - I did try the new version using our database and noticed that the fulltext search does not search for folders either. For example, a folder named Case1234 with documents in it, if I search for 1234 I do not get any hits even though there is a folder containing that string. I can search for the documents as using but not the folder.

So, I guess for either version, what is the best way to exand the search to include the searching folder name and comments. I'm trying the LEFT JOIN with tblFolder but continually get the unknown column errror for tblFolder.name etc..

Thanks

David

[steinm]

Nobody has any insight on how to achieve this??

---

Nobody has any insight on how to achieve this??

hi DGBaker

First of all we wanna thank you for using LetoDMS as your Document Management System. now for you question are you trying to expand your search capabilities? what are you trying to achieve here? or because you can search for folder name, comment as long they are in the keyword area ... or you can use our new version which uses Lucene i know your version is customized for your use but i am pretty sure you only customized the configuration files or template file to see different names ? so you can use still our new version and don't update does file or folder is that way you can install our version on a different folder and with the same database and see if it works for you? or you can export the database you have and make a new database so u don't mistakenly mass up your old version.

Thanks

LetoDMS Admin

Hi Admin - I did try the new version using our database and noticed that the fulltext search does not search for folders either. For example, a folder named Case1234 with documents in it, if I search for 1234 I do not get any hits even though there is a folder containing that string. I can search for the documents as using but not the folder.

So, I guess for either version, what is the best way to exand the search to include the searching folder name and comments. I'm trying the LEFT JOIN with tblFolder but continually get the unknown column errror for tblFolder.name etc..

The fulltext search doesn't search folders because it is for indexing the content of documents. Folder search should be better implemented by searching in the database. The reason for the failure of your sql statements sounds quite obvious. You are trying to access a column that doesn't exist.

Uwe