Output Sets V12 and Recipient, Initiator information

Now that we have the initiator and the recipient, how can I export that information.   Example we have an event for education and we sell to the school and have the recipient as the teacher ( so we know what teacher this group order is for) or we have a household purchase a camp but we have the recipient as the child.

My goal would be to pull a list of those who purchased for "Camp" and then on the output set to create a roster so to speak.  So I could see me selecting F_Name, L_Name, Recipient_Name, Recipient_No.   

I found how I can pull a list on Role but not how I can get a list of  the Owner and the Recipient for seats.  I tried to create a query but my SQL isn't strong.  So I got an error.   

How would I get this information?  Any other ways?

Parents
  • Hi thanks Ryan.  Seattle Rep is always a reliable backup help desk (say Hi to Heather for me). 

     

    I’ve found the Contribution one, but I don’t seem to have the other 2.  We must have missed a step in our upgrade or perhaps our re-customisation of the ticket history has mucked this up.

     

    Cheers

    .

    Dale Bradbury | Director CRM and Ticketing
    Melbourne Theatre Company | 252 Sturt Street, Southbank VIC 3006 | mtc.com.au

    T: +61 3 8688 0980 | M: +61 413 938 886 | F: +61 3 8688 0901 | E: d.bradbury@mtc.com.au




     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Friday, 4 April 2014 6:14 AM
    To: Dale Bradbury
    Subject: RE: [Tessitura Marketing Forum] Output Sets V12 and Recipient, Initiator information

     

    Hi Dale,

    I'm not Kevin, but happened across this and had an answer for you.
    Here are the role criteria options that I think you are looking for.

    Contribution Constituent Role
    Package History Role
    Ticket History Role

    From: Dale Bradbury <bounce-dalebradbury6800@tessituranetwork.com>
    Sent: 4/3/2014 4:03:55 AM

    Hi Kevin,

    What is the Role called in List Manager Elements?  I can't see anything that appears to be covering Role, but surely it must be standard in v12?  Please cure me of my blindness.

    Thanks

    Dale




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Hi thanks Ryan.  Seattle Rep is always a reliable backup help desk (say Hi to Heather for me). 

     

    I’ve found the Contribution one, but I don’t seem to have the other 2.  We must have missed a step in our upgrade or perhaps our re-customisation of the ticket history has mucked this up.

     

    Cheers

    .

    Dale Bradbury | Director CRM and Ticketing
    Melbourne Theatre Company | 252 Sturt Street, Southbank VIC 3006 | mtc.com.au

    T: +61 3 8688 0980 | M: +61 413 938 886 | F: +61 3 8688 0901 | E: d.bradbury@mtc.com.au




     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Friday, 4 April 2014 6:14 AM
    To: Dale Bradbury
    Subject: RE: [Tessitura Marketing Forum] Output Sets V12 and Recipient, Initiator information

     

    Hi Dale,

    I'm not Kevin, but happened across this and had an answer for you.
    Here are the role criteria options that I think you are looking for.

    Contribution Constituent Role
    Package History Role
    Ticket History Role

    From: Dale Bradbury <bounce-dalebradbury6800@tessituranetwork.com>
    Sent: 4/3/2014 4:03:55 AM

    Hi Kevin,

    What is the Role called in List Manager Elements?  I can't see anything that appears to be covering Role, but surely it must be standard in v12?  Please cure me of my blindness.

    Thanks

    Dale




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data