• Replies 13 replies
  • Subscribers 417 subscribers
  • Views 207 views
  • Users 0 members are here
Related

Research Notes

Melissa Harty
$organization

I'm wondering if anyone knows/has designed a report that prints out Research/Notes by Note Type?

 

 

Parents
  • $organization

    Beth, thanks for getting back to me. We are a small organization without a tech department and without the additional SQL Studio. I can just work from whatever the standard Tess reports are. At this point I am trying to get the Full Bio report to save in excel so that I can then manipulate it quickly but the notes fields refuse to come over (probably because of too much text).

    I tried to just print out portions of the report from what I see on screen but no luck again, I keep on getting the first page!

     

    Any ideas?

    Thanks again,

    George

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Thursday, June 21, 2012 11:31 AM
    To: George Syrigos
    Subject: RE: [Tessitura Development Forum] Research Notes

     

    Hey George,

    Not sure if this is helpful or not. We're working on a massive clean up of notes imported from our old ticketing system. In order to isolate these notes I've just been using pulling the info from SQL Server Management Studio using this script:

    select n.customer_no,e.notes from TX_CUST_NOTES n
    join TX_CUST_NOTES_EXT e on e.cust_notes_no=n.cust_notes_no
    where n.note_type=<enter note type number here>

    This gives you every customer and the note details for a specified note type.
    But if you're looking for a specific list of people you could easily add a list element in there:

    select n.customer_no,e.notes from TX_CUST_NOTES n
    join TX_CUST_NOTES_EXT e on e.cust_notes_no=n.cust_notes_no
    join T_LIST_CONTENTS l on l.customer_no=n.customer_no
    where n.note_type=<enter note type number here>
    and l.list_no=<enter list number here>

    I don't know of a report that will run for a specific type of note so this is the work around I've found.

    Hope it helps!

    From: George Syrigos <bounce-georgesyrigos8715@tessituranetwork.com>
    Sent: 6/21/2012 9:31:16 AM

    Ryan, thanks fo the info. I got the notes to print by getting into the system tables like you suggested. I am trying though to use the Full Bio report to just print a specific note type only. Is that possible or is there a different "canned" report that we could use for that purpose?

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Reply
  • $organization

    Beth, thanks for getting back to me. We are a small organization without a tech department and without the additional SQL Studio. I can just work from whatever the standard Tess reports are. At this point I am trying to get the Full Bio report to save in excel so that I can then manipulate it quickly but the notes fields refuse to come over (probably because of too much text).

    I tried to just print out portions of the report from what I see on screen but no luck again, I keep on getting the first page!

     

    Any ideas?

    Thanks again,

    George

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Thursday, June 21, 2012 11:31 AM
    To: George Syrigos
    Subject: RE: [Tessitura Development Forum] Research Notes

     

    Hey George,

    Not sure if this is helpful or not. We're working on a massive clean up of notes imported from our old ticketing system. In order to isolate these notes I've just been using pulling the info from SQL Server Management Studio using this script:

    select n.customer_no,e.notes from TX_CUST_NOTES n
    join TX_CUST_NOTES_EXT e on e.cust_notes_no=n.cust_notes_no
    where n.note_type=<enter note type number here>

    This gives you every customer and the note details for a specified note type.
    But if you're looking for a specific list of people you could easily add a list element in there:

    select n.customer_no,e.notes from TX_CUST_NOTES n
    join TX_CUST_NOTES_EXT e on e.cust_notes_no=n.cust_notes_no
    join T_LIST_CONTENTS l on l.customer_no=n.customer_no
    where n.note_type=<enter note type number here>
    and l.list_no=<enter list number here>

    I don't know of a report that will run for a specific type of note so this is the work around I've found.

    Hope it helps!

    From: George Syrigos <bounce-georgesyrigos8715@tessituranetwork.com>
    Sent: 6/21/2012 9:31:16 AM

    Ryan, thanks fo the info. I got the notes to print by getting into the system tables like you suggested. I am trying though to use the Full Bio report to just print a specific note type only. Is that possible or is there a different "canned" report that we could use for that purpose?

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Children
  • $organization in reply to George Syrigos

    Hmmm..... Do you have access to system tables? If so you could create an output set for notes with a parameter to select specific note types.

    I just tried setting this up in my test system and it seems to do the job. The only thing that is weird on my end is that many of our imported notes from our old system do not actually display the entire note in Tessitura for some reason. When I export the note using SQL I can see the whole note but doing this output set I can only see what Tessitura displays. So there may be an issue with truncating... I'm not sure. I would recommend testing it out before accepting it as a solution.

    I came up with this from reading a few other forum posts as well as checking out the Output Set Builder Cookbook. So if anyone sees something wrong with this please feel free to chime in and fix it!

    In TR_QUERY_ELEMENT:

    Description = Research Notes
    Category = Constituent
    Data Select = !.notes
    Data From = (select a.customer_no, a.note_type, notes = dbo.FS_GET_CUST_NOTES(a.cust_notes_no) from vxs_cust_notes a)
    Data Where = note_type IN(<<p#>>) --> replace the # with the id number from tr_query_element_parameter once it is built
    Control Group = (leave blank)
    Single Row = (leave unchecked)

     

    In TR_QUERY_ELEMENT_PARAMETER:

    Description = Notes Type
    Data Type = String
    End of Day = (leave unchecked)
    Multi Select = (check this box)
    Ref Tbl = vrs_cust_notes_type
    Ref Id = id
    Ref Desc = description
    Ref Where = (leave blank)
    Ref Sort = description

     

    I hope that actually works! I'm not the best at building output sets. :)