Export contacts from a Target List

[alexvf]

Hi,

I need to export contact details from a specific Target List but apparently I can't do that using SugarCRM.

To solve this I want to query the database for those results. I already found the tables I need (prospects and prospect_lists) but I don't know how to relate them. There doesn't seem to be a common field between them and I don't know Sugar's database model.

Can you please help me?

Thank you in advance for your help.

Regards,
Alexvf

[andopes]

Hi Alexvf

The tables:

prospect_lists.id = prospect_lists_prospects.prospect_list_id
prospect_lists_prospects.related_id = contacts.id
prospect_lists_prospects.related_type = 'Contacts'

Regards

[alexvf]

Hi André,

That is it. You saved me! :-)

The tables:

prospect_lists.id = prospect_lists_prospects.prospect_list_id
prospect_lists_prospects.related_id = contacts.id
prospect_lists_prospects.related_type = 'Contacts'

I needed this:

prospect_lists.id = prospect_lists_prospects.prospect_list_id
prospect_lists_prospects.related_id = prospects.id
prospect_lists_prospects.related_type = 'Prospects'

But the info I needed was all in your answer.

Muito obrigado!

Regards,
---
Alexandre