query Contacts based on date field in Opportunities module?

[TedErnst]

I would like to create a target list of Contacts (I'll export and then import back as Targets, unless you have a better idea.) based on a date field in the Opportunities module. Can this be done? If not, how can I get at a sub-list of my Contacts based on when something happened with their Opportunity?

Thanks!
Ted

[andopes]

Hi Ted.

At first create a Target List, take the id generated for that Target List and after substitute it in this query:

INSERT INTO prospect_lists_prospects (id, prospect_list_id, relate_id, relate_type, date_modified)
SELECT UUID(), 'prospect_list_id', c.id, 'Contacts', NOW()
FROM contacts c
INNER JOIN opportunities o ON xxxx
WHERE xxxx

Obviously substitute the xxxx for the appropriate clauses.

Best regards

[TedErnst]

Thank you, Andre. I'll see if I can find someone in my company that understands what you wrote. Hopefully they will!