I am trying to pull last names and first names from an output set and am running into a problem. For households, there is no first name and the last name comes out John and Ann Smith Household. I know we've had this problem before and it is the TR_Query_Element set up but I don't remember what the Data From field is supposed to be to fix it, right now it is T_CUSTOMER.
Lastname1 = Smith
Firstname1 = John 2
Lastname2 = Smith
Firstname2 = 2 Ann
Leah J. Anglum
Manager of Patron Relations & Development Operations State Theatre New Jersey
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Martin Keen Sent: Tuesday, November 15, 2016 5:07 PM To: Leah Anglum Subject: Re: [Tessitura Technical Forum] Pulling Last Name and First Name
What are you looking for the output to be? Just guessing you're looking for
Lastname = Smith
Firstname = John and Ann
Would that be correct?
Martin
From: Leah Anglum <bounce-leahanglum9843@tessituranetwork.com> Sent: 11/15/2016 4:40:17 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Try this - I have a view (which your IT department/DBA will need to add to your Tessitura database) which you can use to add values into TR_QUERY_ELEMENT. It's limited to household type constituents and will return the following fields:
Constituent details for the A1 or A2 affiliates are not included in the output if either is marked as deceased or inactive.
Hope this helps!