Format Value for Notes

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 McConico
Sent: Tuesday, October 30, 2012 7:02 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Format Value for Notes

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?

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 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!

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 McConico
Sent: Tuesday, October 30, 2012 7:02 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Format Value for Notes

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?

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 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!