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.
Do you have a screen shot of what this looks like? We don’t exactly have an IT Department or DBA for Tessitura. Thanks so much.
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 7:19 PM To: Leah Anglum Subject: RE: [Tessitura Technical Forum] Pulling Last Name and First Name
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!
Martin
(Please visit the site to view this media)
From: Leah Anglum <bounce-leahanglum9843@tessituranetwork.com> Sent: 11/15/2016 10:09:16 PM
Lastname1 = Smith
Firstname1 = John 2
Lastname2 = Smith
Firstname2 = 2 Ann
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?
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!
Sorry to sound like a dunce but a screen shot of what? If it's examples of the output, I've attached a few in the spreadsheet.
Who maintains your Tessitura database? Whoever this is will be able to run the script to create the view.
When this is done, you can then create the entries in TR_QUERY_ELEMENT - here's an example:
If you have any questions, feel free to email me at martin.keen@nida.edu.au