Search for Leads by Campaign returns no results

[rfsvicki]

When I do an Advanced Search of Leads and enter the Campaign name via the popup the search returns 0 results. However, when I select any lead that was sent the campaign, I do see it listed in the Campaigns subpanel.

I've seen other threads from early last year that indicate this might be a bug, but I think it would have been fixed by now if it was.

Anyone else having this problem, or know a fix? Version 6.0.2 CE

[andopes]

This error is due some issue building the campaign_name where clause.
Follow my tips here and let us know the sql query.

Cheers

[rfsvicki]

Thanks. Here's the query (the campaign name I'm searching on is Emylist90):

SELECT leads.id ,leads_cstm.categories_c, leads.status , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.account_name , leads.account_id , leads.primary_address_state , leads.lead_source , jt0.name campaign_name , jt0.assigned_user_id campaign_name_owner , 'Campaigns' campaign_name_mod, leads.campaign_id , leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN campaigns jt0 ON jt0.id= leads.campaign_id AND jt0.deleted=0 AND jt0.deleted=0 where ((leads.campaign_id like '2dfae141-83d3-747b-2386-4cb1ff7f9d1f%' ) AND ( jt0.name like 'Emylist90%')) AND leads.deleted=0 ORDER BY leads.status ASC

[rfsvicki]

Thanks for offering to take a look at this query andopes. Just thought I'd bump this in case it got lost.