Can someone tell me which table stores a customer’s constituencies? I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no. Which table will show me that customer_no 19996 has constituency ID of 18?
Thanks in advance!
Penny Tabor
IT Manager
Midland Center for the Arts
Midland, MI 48640
You're looking for tx_const_cust.
It's TX_CONST_CUST.
select * from tx_const_cust
where customer_no = 19996 and constituency = 18
Hi Penny,
It’s TX_CONST_CUST . Or you can use the view VX_CONST_CUST_ACTIVE which selects only accounts with active constituencies.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor Sent: Monday, October 04, 2010 2:08 PM To: Hoffmann, Tanya Subject: [Tessitura Technical Forum] Constituencies
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!
Thanks everyone! Amanda – the vx suggestion is perfect since what I want to do is show an icon in the header of a person has a certain constituency. Using the view eliminates the need to add code to pull only active constituencies. Excellent help – thanks!
Penny
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tanya Hoffmann Sent: Monday, October 04, 2010 2:13 PM To: Tabor, Penny Subject: RE: [Tessitura Technical Forum] Constituencies
This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.