Page 1 of 8 12345 ... LastLast
Results 1 to 10 of 72

Thread: Enhanced Search Plugin

  1. #1
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Enhanced Search Plugin

    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.

  2. #2
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Enhanced Search DEMO is FREE

    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
    Last edited by kenshiro; 2008-05-20 at 10:11 AM.

  3. #3
    Jessipants is offline Junior Member
    Join Date
    May 2008
    Posts
    4

    Default Re: Enhanced Search Plugin

    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!

  4. #4
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Re: Enhanced Search Plugin

    Quote Originally Posted by 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?
    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.

  5. #5
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Enhanced Search Plugin

    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?

  6. #6
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Re: Enhanced Search Plugin

    Quote Originally Posted by 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?
    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

  7. #7
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Enhanced Search Plugin

    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

  8. #8
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Re: Enhanced Search Plugin

    Quote Originally Posted by 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
    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

  9. #9
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Enhanced Search Plugin

    Quote Originally Posted by kenshiro
    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

  10. #10
    Desperados Guest

    Default Re: Enhanced Search Plugin

    wow - thanks !

Page 1 of 8 12345 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Enhanced Search project downloads do not work...
    By kazkawamura in forum Downloads
    Replies: 4
    Last Post: 2008-03-20, 07:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •