Employee/Employer Output

Former Member
Former Member $organization

I am trying to pull information from the relationship tab, but only for certain types (employee/employer). I would like to be able to select the type from tr_affiliation and have it give me the affiliated name. (Example: Name: Joe Smith - Employer: Tessitura Network)

I am trying to run it through an output set and have already set up a query element for the affiliation, but can't seem to get the name that is affiliated with the specific type. Does anyone have a query element for this or suggestions on how to get the information?

Parents
  • Hi – the Output Set Builder Cookbook has an element that outputs the Household or Group Name for an individual. You may be able to use that?

     

    If that doesn’t work for you, perhaps adding a parameter to your element might help so you can limit the output to a specific type of affiliation?

     

    Regards

    Sandra

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Taylor Clark
    Sent: Tuesday, 30 April 2013 3:52 AM
    To: Sandra Ashby
    Subject: [Tessitura Ticketing Forum] Employee/Employer Output

     

    I am trying to pull information from the relationship tab, but only for certain types (employee/employer). I would like to be able to select the type from tr_affiliation and have it give me the affiliated name. (Example: Name: Joe Smith - Employer: Tessitura Network)

    I am trying to run it through an output set and have already set up a query element for the affiliation, but can't seem to get the name that is affiliated with the specific type. Does anyone have a query element for this or suggestions on how to get the information?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 – the Output Set Builder Cookbook has an element that outputs the Household or Group Name for an individual. You may be able to use that?

     

    If that doesn’t work for you, perhaps adding a parameter to your element might help so you can limit the output to a specific type of affiliation?

     

    Regards

    Sandra

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Taylor Clark
    Sent: Tuesday, 30 April 2013 3:52 AM
    To: Sandra Ashby
    Subject: [Tessitura Ticketing Forum] Employee/Employer Output

     

    I am trying to pull information from the relationship tab, but only for certain types (employee/employer). I would like to be able to select the type from tr_affiliation and have it give me the affiliated name. (Example: Name: Joe Smith - Employer: Tessitura Network)

    I am trying to run it through an output set and have already set up a query element for the affiliation, but can't seem to get the name that is affiliated with the specific type. Does anyone have a query element for this or suggestions on how to get the information?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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
  • Hi,

     

    I am wondering if anyone has successfully created a Query Element Parameter that limits an Output to a specific Affiliation/Association Type?

     

    I've tried to do this, but am still getting other Affiliation/Association Types in my Output.

     

    Here is how I've set it up:

     

    TR_QUERY_ELEMENT

    description: Relationship Description

    data_select: !.relationship_type_description

    data_from: vs_relationship

    data_where: !.relationship_type_id in (<<p8>>)

    single_row: Y

    primary_group_default: N

     

    TR_QUERY_ELEMENT_PARAMETER

    id: 8

    description: Relationship Type

    data_type: string

    end_of_day: N

    multi_select: N

    ref_tbl: VR_RELATIONSHIP_TYPE

    ref_id: id

    ref_desc: description

    ref_where: NULL

    ref_sort: description

     

    Thanks

     

    Kim