Enhanced Search Plugin

[kenshiro]

This thread is intended to gather requests and suggestions about the Enhanced Search project.

First of all a brief description:
Enhanced Search project has drawn inspiration from the need of some specific search options that aren’t included in the SugarCRM CE version (take a look at this page for further details about project's history, awards, author and more).

Enhanced Search helps the user to customize searches with a friendly interface by providing :

- the OR / NOT search options (as well as the default AND query operator) ;
- the To-Date and From-Date search capability;
- the EMPTY field search option (NEW in the 2.0 version);
- the OPERATOR option that lets the user choose among :

1. An exact text match
2. A match using sql wildchars
3. A match of an element in a list
4. A match using MySQL regular expression syntax.

Everything is fully integrated with SugarCRM so that the user can

1. find the last Enhanced option choices on every module;
2. save the Enhanced option choices on his favourite searches;
3. use them in a mass update.

The user can reach a high level of customization in his search by combining the Enhanced Search options, as explained in the TIPS 'N' TRICKS section of README V. 2.0 .

Enhanced Search is multilanguage : English, French, German and Italian are currently supported.
The plugin is compatible with all the SugarCRM 5 versions and all the SugarCRM flavours (Community, Professional and Enterprise Editions).

Enhanced Search DEMO is available with the date, OR, NOT and OPERATOR options applied to the basic search fields, while the FULL version includes the EMPTY field search option, and extends all the Enhanced Search options to almost all the types of search fields.
Refer to the README file for a more detailed usage description , tips ‘n’ tricks and a comparison ot the 2.0 DEMO vs. FULL features.

Visit the SugarExchange project's page to download the DEMO versions and purchase the FULL versions.
Visit the SugarForge page to view the project's page and download the DEMO versions.

[kenshiro]

I have installed the new Enhanced Search, for test date-to-date function. My question is: Ce 5.00 Demo is free or not? What the (legal) difference between various version?

(from http://www.sugarcrm.com/forums/showthread.php?p=113482)

I didn't point out that FULL version is a PAID version and you have to subscribe an EULA to purchase it,

while DEMO version is absolutely FREE and it's released under SugarCRM Public License

[Jessipants]

Hi! I'm looking at customizing the search feature myself, but I think Enhanced Search might suit my needs perfectly. However, I was wondering if enhanced search changed ALL the modules? When I was investigating changing the search, certain modules (such as Employees, ProjectTasks, Users) used a different search. Does enhanced search modify these search forms also?

Thanks a ton!

[kenshiro]

Hi! I'm looking at customizing the search feature myself, but I think Enhanced Search might suit my needs perfectly. However, I was wondering if enhanced search changed ALL the modules? When I was investigating changing the search, certain modules (such as Employees, ProjectTasks, Users) used a different search. Does enhanced search modify these search forms also?

Hi,

Enhanced Search options affects the Advanced Search page of the modules (and sub-modules) that you can find on Sugar top bar.

To answer to your question : it modifies ProjectTasks, not Employees and neither Users.

[mikesolomon]

I have just installed the enhanced search - enhancedSearch-2_0-500-CE-demo.zip

While being delighted with how it works it has mucked up date & datetime fields in detail view

They now display as an editable field with the calendar alongside them

How can I get round this?

[kenshiro]

I have just installed the enhanced search - enhancedSearch-2_0-500-CE-demo.zip

While being delighted with how it works it has mucked up date & datetime fields in detail view

They now display as an editable field with the calendar alongside them

How can I get round this?

Hi,

you can fix it yourself by copying the file
<SugarRootDir>/include/SugarFields/Fields/Base/DetailView.tpl
into <SugarRootDir>/include/SugarFields/Fields/Datetime/DetailView.tpl .

Otherwise you can wait for the upcoming Enhanced Search release where it will be fixed once and for all.

Thank you

[mikesolomon]

I have found a problem with datetime fields

The issue arises because the SQL statement produced is:

WHERE date_field >= date1 AND <= date2

This is fine for date fields but fails on datetime fields because a record with the value 2008-06-01 12:00 would not appear where date2 is 2008-06-01

I have got round this by editing include/SearchForm/SearchForm2.php to include the following line

$db_field = "date($db_field)";

I have put this in at line 578 underneath if($type == 'date' || $type == 'datetime') {

Hopefully this is of help

[kenshiro]

I have found a problem with datetime fields

The issue arises because the SQL statement produced is:

WHERE date_field >= date1 AND <= date2

This is fine for date fields but fails on datetime fields because a record with the value 2008-06-01 12:00 would not appear where date2 is 2008-06-01

I have got round this by editing include/SearchForm/SearchForm2.php to include the following line

$db_field = "date($db_field)";

I have put this in at line 578 underneath if($type == 'date' || $type == 'datetime') {

Hopefully this is of help

Hi Mike,

your patch may work on MySQL db, but it's not compatible with MsSQL and Oracle.

It works this way because it follows the rule that the date "2008-03-31" is equal to "2008-03-31 00:00", so if
you want to search for a datetime field you should search for "2008-04-01" to include the "2008-03-31" time slice .

But I can modify it on the next release so as to include it by default.

Thank you

[mikesolomon]

Hi Mike,

your patch may work on MySQL db, but it's not compatible with MsSQL and Oracle.

It works this way because it follows the rule that the date "2008-03-31" is equal to "2008-03-31 00:00", so if
you want to search for a datetime field you should search for "2008-04-01" to include the "2008-03-31" time slice .

But I can modify it on the next release so as to include it by default.

Thank you

Thanks - The enhanced search is fab

[Desperados]

wow - thanks !