select by campaign

[raynor]

we just imported a big list of contacts, and used the campaign field during the import.
eg i set the campaign field to "mar 2010 import".

the accounts added correctly.
if i display an account it shows the campaign field as a link to "mar 2010 import".
if i click that link it shows me a campaign, but there is nothing under the campaign.

if i try to do an advanced contact search, I can use the Campaign Select, and it shows my campaign. But the actual search returns no contacts at all.

If I try to build a report that filters by non-empty campaign ID, the report actually fails:
Error executing query Query Failed:SELECT contacts.id primaryid ,contacts.first_name contacts_first_name ,contacts.last_name contacts_last_name ,contacts.date_entered contacts_date_entered ,campaign_contacts.campaign_id campaign_contacts_campaign_i FROM contacts INNER JOIN campaigns l1 ON l1.id= contacts.campaign_id AND l1.deleted=0 WHERE ((( campaign_contacts.campaign_id IS NOT NULL AND campaign_contacts.campaign_id<>'' ) )) AND contacts.deleted=0 LIMIT 0,100::MySQL error 1054: Unknown column 'campaign_contacts.campaign_id' in 'field list'

This is on a report built by the report wizard!

If I do an advanced contacts search by date created, it shows all the contacts I added.
If I export that list of contacts, I can see that the campaignid field is non-blank - it shows the key.

Yet a report on the same criteria crashes.

Is there something really screwed up in campaigns?

Can anyone suggest a way to find all those contacts?

I even tried a simple report, filtering by creation date instead of campaign id, but i did try to display the campaign id. Again, another error:
Error executing query Query Failed:SELECT contacts.id primaryid ,contacts.first_name contacts_first_name ,contacts.last_name contacts_last_name ,contacts.date_entered contacts_date_entered ,campaign_contacts.campaign_id campaign_contacts_campaign_i FROM contacts WHERE ((contacts.date_entered>='2010-02-28 13:00:00' AND contacts.date_entered<='2010-03-31 13:59:59' )) AND contacts.deleted=0 LIMIT 0,100::MySQL error 1054: Unknown column 'campaign_contacts.campaign_id' in 'field list'

It really is sick when you mention campaigns.

[salesagility]

create a target list called mar 2010 import

search for all contacts assigned to the campaign mar 2010 import

Mass update them to the target list mar 2010 import

[itscope]

We have exactly the same problem. Some campaigns are attached manually to contacts, some are filled by conversion from leads. But no matter which way, contacts cannot be filtered by campaign even if the field is available as filter in the extended search.

Is there a bug report for this? I have not found anything...
salesagility, i don't understand your answer: how could I add the contacts to a target list if I cannot filter them by campaign?
Thank you for your help!
stefan

[itscope]

Fixed:

Contacts/metadata/SearchFields.php

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

[kbrill]

Reported as bug #36603, marked as urgent.