• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 135 views
  • Users 0 members are here
Related

Pulling Last Name and First Name

Leah Anglum
$organization

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.

Parents
  • $organization

    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

    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.




    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!

  • $organization in reply to Leah Anglum

    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:

     

    • customer_no (of the household)
    • lname (of the household)
    • customer_no1 (for the constituent marked as A1 - or the constituent marked as A2 if A1 is either inactive or deceased)
    • fname1
    • lname1
    • customer_no2
    • fname2
    • lname2

     

     

    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



    [edited by: Martin Keen at 7:13 PM (GMT -6) on 15 Nov 2016]
Reply
  • $organization in reply to Leah Anglum

    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:

     

    • customer_no (of the household)
    • lname (of the household)
    • customer_no1 (for the constituent marked as A1 - or the constituent marked as A2 if A1 is either inactive or deceased)
    • fname1
    • lname1
    • customer_no2
    • fname2
    • lname2

     

     

    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



    [edited by: Martin Keen at 7:13 PM (GMT -6) on 15 Nov 2016]
Children
No Data