products dashlet - filter by category

[raynor]

i built my first Products dashlet today, that shows products, with category and type.

however the business would really like to filter by category.

they also would have like to filter by a custom field, maintenance_enddate_c.

I tried adding a filter for these, but they filtered out every single record, so I'm doing something wrong.

Here's my code (with no filters at all). (And btw, is there a way to stop it automatically filtering by current user?)

  
global $current_user;
 
$dashletData['ProductTypeDashlet']['searchFields'] = array( 
                                                                
                                                            
                                                      
                                                              );
                                                                                           
$dashletData['ProductTypeDashlet']['columns'] = array('name' => array('width'   => '30', 
                                                                          'label'   => 'LBL_NAME',
                                                                          'link'    => true,
                                                                          'default' => true 
                                                                          ), 
                                                      'account_name' => array('width'  => '29', 
                                                                                  'label'   => 'LBL_ACCOUNT_NAME',
                                                                                  'default' => true,
                                                                                  'link' => true,
                                                                                  'id' => 'account_id',
                                                                                  'ACLTag' => 'ACCOUNT'),
                                                      
                                                    
                                                       'category_name' => array('width'  => '20', 
                                                                                  'label'   => 'Category',
                                                                                  'default' => true,
                                                                                  'link' => false,
                                                                                  'id' => 'category_id',
                                                                                  'ACLTag' => 'PRODUCTCATEGORY'),
                                    
                                                        'type_name' => array('width'  => '15', 
                                                                                  'label'   => 'Product Type',
                                                                                  'default' => true,
                                                                                  'link' => false,
                                                                                  'id' => 'type_id',
                                                                                  'ACLTag' => 'PRODUCTTYPE'),
                                    
                                                       'support_status_c' => array('width'   => '15', 
                                                                                   'default' => true,
                                                                                      'label'   => 'LBL_SUPPORT_STATUS'),
                                                       
                                                       'list_usdollar' => array('width'   => '15', 
                                                                            'label'   => 'LBL_LIST_USDOLLAR',
                                                                            'default' => true,
                                                                            'currency_format' => true),
                                                       
                                                        'maintenance_startdate_c' => array('width'   => '15', 
                                                                              'label'   => 'LBL_MAINTENANCE_STARTDATE',
                                                                              'default'        => true,
                                                                              'defaultOrderColumn' => array('sortOrder' => 'ASC')),                         
                                                                                                                             
                                                       
                                                       'maintenance_enddate_c' => array('width'   => '15', 
                                                                              'label'   => 'LBL_MAINTENANCE_ENDDATE',
                                                                              'default'        => true,
                                                                              'defaultOrderColumn' => array('sortOrder' => 'ASC')),  
 
                                                      
                                                       
 
                                                           );
?>