Inscrutable Interests Information

The interests themselves are ticketing keywords and are stored in the TR_TKW table.  The selected interests for the customer can be found in TX_CUST_TKW.

Gregg Stickney

Application Support Specialist

Tessitura Network

www.tessituranetwork.com

gstickney@tessituranetwork.com

Office  +1 888-643-5778 x318

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Tuesday, January 17, 2012 12:22 PM
To: Gregg Stickney
Subject: [Tessitura Technical Forum] Inscrutable Interests Information

Quick question: The Interests radial button on the Attributes tab contains entries that are populated (if I'm not mistaken) by the machinations of our web programmers based on user feedback on our website - mostly for contact method information and the like.  What table does that point to, assuming they didn't contrive some custom setup?

Thanks, Tessiturians.

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!

What, you didn’t think to look at TX_CUST_TKW?

It’s a JOIN table between Constituent (T_CUSTOMER) and TR_TKW (Ticketing Keywords) with additional data.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Tuesday, January 17, 2012 12:22 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Inscrutable Interests Information

Quick question: The Interests radial button on the Attributes tab contains entries that are populated (if I'm not mistaken) by the machinations of our web programmers based on user feedback on our website - mostly for contact method information and the like.  What table does that point to, assuming they didn't contrive some custom setup?

Thanks, Tessiturians.

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!

Assuming no inscrutable custom setup, these populate from TR_TKW. Entries here are used both in constituent interests and/or production element keywords (there’s a dropdown to indicate which, or both).

Quick question: The Interests radial button on the Attributes tab contains entries that are populated (if I'm not mistaken) by the machinations of our web programmers based on user feedback on our website - mostly for contact method information and the like.  What table does that point to, assuming they didn't contrive some custom setup?

Thanks, Tessiturians.

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!