Search for a range?

[gerald29]

Hello all,
is there a way to search for a range of results? For instance, i have a field called employee count, can i search for all companies with a range of 50-100 employees? is there a syntax i can use for this? i have tried a few with no luck

[roblaus]

Check this out: http://www.sugarforge.org/projects/enhancedsearch/

If this isn't what you're after you may want to look at Jasper or smthg similar.

rgds

[dlorenzetti]

Hi gerald29,

You can do that in modules/<MODULE_NAME>/ListView.php, after Sugar defines the $where_clauses.
Folow is an example:

  
    if (isset($_REQUEST['date_begin'])) $date_begin = $_REQUEST['date_begin'];
    if (isset($_REQUEST['date_end'])) $date_end = $_REQUEST['date_end'];
 
 
    $where_clauses = generate_search_where($searchFields,$_REQUEST,$seedProposal,true,"Proposals");
    
    if(isset($date_begin) && $date_begin != ""){ 
        $date_begin_dbformat = $timedate->swap_formats($date_begin, $timedate->get_date_format(), $timedate->dbDayFormat);
        array_push($where_clauses, "proposals.date >= '".PearDatabase::quote($date_begin_dbformat)."'");
    }
    if(isset($date_end) && $date_end != ""){ 
        $date_end_dbformat = $timedate->swap_formats($date_end, $timedate->get_date_format(), $timedate->dbDayFormat);
        array_push($where_clauses, "proposals.date <= '".PearDatabase::quote($date_end_dbformat)."'");
    } 
  

In this case I do the range search for date field in Proposal Module. you going to do for your module.employees.

I hope this helps.