• Replies 1 reply
  • Subscribers 961 subscribers
  • Views 74 views
  • Users 0 members are here
Related

Notes Report List in Tessitura

Yeside Talabi
$organization

Please who knows how I can pull a list of notes under all constituents in Tessitrura

  • $organization

    For Research notes on the constituent module you can get all of them from VS_ELEMENTS_NOTES in SSMS.

    However without breaking out SQL the easiest way is

    1. LIST: Create a list of everyone with a Research note using criteria Note Type (in the Research category) and select all
    2. OUTPUT SET: Depending on what other data you want (like Salutation so you can see who they are) the crucial one is in the Research - Notes category called Research Note.  Note_Type_Desc is also helpful.