Campaign field to search popup doesn't work?

[chiefnt]

I have added the Campaign field to the Lead search popup but it doesn't filter at all (no result show up). I have added the Campaign field to both the basic and advance Lead search and both filter correctly. I have also added the Campaign field to the Contact search popup using similar code found below.

Why does my Campaign filter not work for Leads? I'm running 5.2.0f.

                         'whereClauses' => 
                            array('first_name' => 'leads.first_name', 
                                    'last_name' => 'leads.last_name',
                                    'lead_source' => 'leads.lead_source',
                                                                        'campaign_name' => 'campaigns.name',
                                                                        'campaign_id' => 'campaigns.id',
                                                                        'status' => 'leads.status'),
                    

                                
                        'searchInputs' =>
                            array('first_name', 'last_name', 'lead_source', 'campaign_name', 'status'),
                        
                        'searchdefs'   => array(
                                             'first_name',
                                             'last_name', 
                                            'lead_source', 
                                            'status',
                                                                                        array('name' => 'campaign_name', 'displayParams' => array('hideButtons'=>'true', 'size'=>30, 'class'=>'sqsEnabled sqsNoAutofill')),
                                            array('name' => 'assigned_user_id', 'type' => 'enum', 'label' => 'LBL_ASSIGNED_TO', 'function' => array('name' => 'get_user_array', 'params' => array(false))), 
  

[andopes]

It happens probably because the campaign field on Leads has no all required information to let Sugar retrieve data from its properly.
To make sure that do the following:
Edit the file include/ListView/ListViewData.php and add this line:

 echo "<LI>$main_query</LI>"; 
  

just after the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Try to search for some campaign on Popup.
Let us know the query.

Best regards

[chiefnt]

Thanks for the reply, Andre. Unfortunately, it didn't solve the problem.

I inserted the code as such, in the include/ListView/ListViewData.php file:

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];  
               echo "<LI>$main_query</LI>"; 
  

Now when I use the Lead select button to open the search popup the following text is displayed in the popup window:

[I] SELECT leads.id ,leads_cstm.current_title_c,leads_cstm.resume_c,le ads_cstm.quick_notes_c,leads_cstm.lead_type_c,lead s_cstm.req_code_c,leads_cstm.current_employer_c,le ads_cstm.screen_notes_c,leads_cstm.education_c,lea ds_cstm.salary_expectations_c,leads_cstm.position_ c, CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.lead_source , leads.status , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id ,leads.account_name FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON jt0.id= leads.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where (campaigns.name like 'Test Web to Lead for full Resume%') AND leads.deleted=0 ORDER BY name ASC[/

I]

And when searching for a Campaign, there are still no results.

NOTE: the page for Lead- Advanced Search also shows the above text on that page. Filtering for a Campaign in the Lead Advance search displays the correct results.

Any other suggestions?

Thanks!

[maloner]

Hi There,

Did you ever get a resolution on this?

Regards,

James