I wanted to pull the Notes Field from the Research Tab in Tessitura and I can't seem to find the actual notes (the verbiage) I just get numbers and so forth. The table I'm using is VXS_CUST_NOTES. Has anyone run into this and can you point me in the right direction?
The actual table that the notes are stored in is TX_CUST_NOTES_EXT, which is serialized into 255 character chunks. We have a helper scalar function (FS_GET_CUST_NOTES()) to eliminate the need to do any concatenation for you. Here’s a sample query to get you started:
Select notes = dbo.FS_GET_CUST_NOTES(a.cust_notes_no), a.*
From TX_CUST_NOTES a
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Triland McConicoSent: Tuesday, October 30, 2012 7:02 PMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Format Value for Notes
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!
This is good information, but my problem is I have a few dozen notes that one of my Development contacts want updated. So, basically I'm sort of going in the opposite direction. How exactly would I accomplish that on the back end to keep her from having to edit everything by hand?
Thanks!