Setting default filters for multiple dashlets

[marclangston]

I am creating a default homepage for my users. Among other things, the homepage will have two instances of the "My Leads" dashlet. One instance will show "open/new leads created in the past 30 days". (I can't remember if it's part of some previous customization or if it's built in to Sugar, but I already have the "in the past 30 days" logic.) The second instance will show "unconverted leads that were created more then 30 days ago". (Again, I already have the ">30 days" filter).

So far I have been able to force the homepage to show the two instances of the Leads dashlet, and I can get those instances to have different titles and displayed columns. The code is in custom\modules\Home\index.php and looks like this:

         $dashlets[create_guid()] = array('className' => 'MyLeadsDashlet',
                                         'module' => 'Leads',
                                         'forceColumn' => 0,
                                         'fileLocation' => $dashletsFiles['MyLeadsDashlet']['file'],
                                         'options' => array('title' => translate('OPEN LEADS created in the last 30 days','Leads'),
                                                            'displayColumns' => array('account_name',
                                                                                'name',
                                                                                'title',
                                                                                'phone_work')
                                             ));
 
        $dashlets[create_guid()] = array('className' => 'MyLeadsDashlet',
                                         'module' => 'Leads',
                                         'forceColumn' => 1,
                                         'fileLocation' => $dashletsFiles['MyLeadsDashlet']['file'],
                                         'options' => array('title' => translate('UNCONVERTED LEADS created >30 days ago','Leads'),
                                                            'displayColumns' => array('date_entered',
                                                                                'account_name',
                                                                                'name',
                                                                                'phone_work')
                                             )); 
  

I can't figure out how to specify which filter criteria each of the dashlets should be using. If I wanted to have the same filters on both of them I think I could change something in the dashlet.data.php file, but then both instances of the dashlet would filter on the same criteria.

Can somebody tell me what the code looks like that can specify the filters on a per-dashlet basis? I've been thinking it would be in an "options" section but so far I haven't figured out exactly what the syntax might be.

Thanks.
marc

[marclangston]

Update: I've figured out how to filter on the 'name' field. It goes below the 'displayColumn' code like this:

 $dashlets[create_guid()] = ...
.
'displayColumns' => array('account_name',
                             'name',
                              'title',
                              'phone_work'),
'filters' => array('name' => 'John Smith')
)); 
  

That would allow me to set the default filter for this instance of the dashlet to show only those Leads with the name 'John Smith' (which is of limited value but at least shows I can do some sort of filtering). I've tried some variations of the array statement to set a date range but so far haven't cracked that code.

Does anybody know how I can set filter on a date, date range, or a status (like all 'New' or 'Assigned' leads)?
Thanks.
marc