Search by date range

[jkuchta]

Is it possible to search by a date range for the leads module? As far as I can tell it appears the only way to search is based on a specific date.

[andopes]

To change by a date range you need to:
1. Create a new class which extends the default Lead class;
2. Create a custom controller for Leads and implement the method action_listview;
3. Inside this method you need to override the attribute $this->bean as an instance of the new class;
4. Implement into new Lead class the method create_new_list_query to override the array $ret_array according to your needs. This method is defined into data/SugarBean.php
5. Create an extended vardefs for Leads to add two non-db date fields;
6. Add these two new fields into searchdefs.php
7. Modify the create_new_list_query into new Lead class to consider the sql query based on the two fields;

Cheers

[christianknoll]

Alternatively you can use the lucene integration I posted on Sugarforge http://www.sugarforge.org/projects/kinamulucene/ and search for leads (include object_name:Lead in the search and then the resp date field ... the link to the lucene search syntax will tell you how to search for date ranges.

In addition you can also add any other query you might want in that ...

... christian.

PS: you will only need to make sure that the respective date field get's indexed by the search engine.

To change by a date range you need to:
1. Create a new class which extends the default Lead class;
2. Create a custom controller for Leads and implement the method action_listview;
3. Inside this method you need to override the attribute $this->bean as an instance of the new class;
4. Implement into new Lead class the method create_new_list_query to override the array $ret_array according to your needs. This method is defined into data/SugarBean.php
5. Create an extended vardefs for Leads to add two non-db date fields;
6. Add these two new fields into searchdefs.php
7. Modify the create_new_list_query into new Lead class to consider the sql query based on the two fields;

Cheers

[jkuchta]

Sounds good, thanks for the replies.

[work77]

I've run into a snag using Andopes's Date Range solution above. Any suggestions?

http://www.sugarcrm.com/forums/showthread.php?p=237511

[Cedric K]

I've run into a snag using Andopes's Date Range solution above. Any suggestions?

http://www.sugarcrm.com/forums/showthread.php?p=237511

Hi,

I think there is a mistake in the regex. The pattern does not match the WHERE clause for all the situations, according to the order the fields are organized. I could make this customization working by using the following regex. It's working for me in all the situations :

  $ret_array['where'] = preg_replace('/\(\s?leads\.create_start_date[^)]+\)/', '1', $ret_array['where']);
$ret_array['where'] = preg_replace('/\(\s?leads\.create_end_date[^)]+\)/', '1', $ret_array['where']); 
  

Hope this could help help someone in the future.