Unable to filter Contacts by Campaign?

[chiefnt]

I have a new install of 5.2.0e. I have added the Campaign field to both the Basic and Advanced search layout in Contacts, however, when I try to search my Contacts by Campaign no results show up. I have only two contacts, one with a Campaign associated with it and one without, I don’t understand why there are no search results for my contacts when I filter by campaign.

Am I missing something obvious? Please help me get this working.

Thanks.

[SamuelAugy]

Hello,

Your new field are with a select button ?
If it is not the case, try to go in a campaign and take some characters behind the parameter "record=" in the URL.
Paste these characters into your new field. If that work it's because your field use the id and not the name of your campaign.

Could you try that ?

[chiefnt]

Thanks for the reply.

The Campaign search field does have an associated Select button, which pulls up the Campaign name.

I also tried to search on the campaign id as you suggested but there were still no results shown.

Any other suggestions?

Thanks!

[chiefnt]

I got this working.

In the Contacts, SearchFields.php I changed the code from 'db_field"=>array('campaign_id') to what is below.





'campaign_name'=> array(
'query_type'=>'default',
'operator' => 'subquery',
'subquery' => 'SELECT campaigns.id FROM campaigns WHERE campaigns.deleted=0 and campaigns.name LIKE',
'db_field'=>array('campaigns.id')),
);