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?
Kim
I just tried what you have done in my local Tessitura and it definitely only limits it to outputting the selected relationship description.
I did alter yours a little, but not enough to change the results I would have thought.
TR_QUERY_ELEMENT
data_where: !.relationship_type_id = <<p8>> (as it’s not a multiselect parameter no need for IN)
single_row: N (potentially could have the same type of affiliation to more than one account)
TR_QUERY_ELEMENT_PARAMETER
data_type: Number (as it’s not a multiselect parameter)
Hope that helps
Sandra
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kim Lee Sent: Thursday, October 13, 2016 4:38 PM To: Sandra Ashby <sashby@tessituranetwork.com> Subject: RE: [Tessitura Ticketing Forum] Employee/Employer Output
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:
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
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
From: Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com> Sent: 5/1/2013 3:00:54 PM
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
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
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!
Hi Sandra,
I replicated your setup, plus I removed other multi-row elements from the Output Set and I'm now able to return only the Affiliations selected in the parameter.
FYI I'm selecting a specific Contact Point Purpose and Salutation when running Execute An Output Set to return the desired email address and business details.
Thanks for your help!