Hello,
I just have deployed EDocman 1.22.0 for a web document management solution that uses quite a lot of
Document Extra Fields
. I have edited the proper document.xml file in <root>/administrator/components/com_edocman/model/forms/ location.
Then I activated EDocman search module on the website. Much to my dismay, it turned out EDocman search module can only search document title and description, but not document extra fields.
But then I found this
post
, where an EDocman user modified the EDocman search plugin (/plugins/search/edocman/edocman.php), to make it able to search indexed content, by modifying the SQL query inside that file. His codes are as follows:
Code:
// /joomla/plugins/search/edocman/edocman.php : 101 - 103// replace with
$query = '
SELECT
a.id,
0 AS cat_id,
a.title AS title,
a.short_description,
a.description AS text,
a.indexed_content,
created_time AS `created`,
' . $db->Quote($section) . ' AS section,
"1" AS browsernav
FROM
#__edocman_documents AS a
WHERE
(' . $where . ') AND
(a.user_ids = "") AND
a.published = 1
ORDER BY ' . $order ;
So, the questions are:
- What file such I edit to modify EDocman search module instead of the search plugin?
- What database columns should I include in the modified SQL to include documents extra fields in the search?
- Are there better, simpler ways to achieve what I want?
To be honest this is my very first experience with EDocman, but I like to tinker.
Thank you very much.
