Event Sponsor Query

Kylee Hamilton

Help!!


I am trying to pull an event query of all Corporate Sponsors and the participant contact information (Name, phone and e-mail)

Everything pulls with the exception of the contacts phone and e-mail.  The query only seems to pull the corporation contact information, which in this case is not helpful as I need the sponsorship contact information. 


Can anyone help with this? 


Thanks, 

Kylee ?

Karen Diener

This is a little hard to say for sure because it depends on a few things.  But I'll start with the most obvious (to me):


Are your participants linked to constituent records?  If they have their own constituent record, you should be able to pull the info.  If they are non-constituent relationships on the corporate sponsor's record, I'm not sure you can.


If your participants are NOT linked to constituent records, then it should be easy to pull directly from their participant record.


Karen