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?
Output sets pull data for whoever is on the list you use when you run the output set. So to get data for recipients on camp orders, you need to make a list of recipients on camp orders. To do that you would use the role criteria, but first you need to make sure you are either using the new, standard ticket history or have updated your custom ticket history to include role data. Does that make sense?
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
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
Hi Dale,
I'm not Kevin, but happened across this and had an answer for you.Here are the List Manager role criteria options that I think you are looking for.
Contribution Constituent RolePackage History RoleTicket History Role
Is there a table that stores the codes for Roles/Initator? I cannot find one.
Thanks.