Does anybody have a report (or something else) that would give me the information from a particular note type in Research>Notes for all the constituents on a particular list?
Hoping this makes sense…
Thanks!
-p.
PATRICK SCHLEY | Marketing & Sales Manager | Milwaukee Repertory Theater Patty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202 414.290.0710 tel | 414.224.9097 fax | pschley@milwaukeerep.com Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep
Hi Patrick,
We have created an Output Set Element to return the contents of a particular Research > Note. In our case it’s a Note that we use to store the constituent’s full Business Title, where it exceeds the length of the Bus. Title field on the General Tab.
In TR_QUERY_ELEMENT, we have entered the following:
Description: Title Note
Category: Constituent
Data_select: !.notes
Data_from: (select a.customer_no, b.notes from tx_cust_notes as a join tx_cust_notes_ext as b on a.cust_notes_no = b.cust_notes_no where a.note_type = 53)
**53 is the corresponding id number from TR_CUST_NOTES_TYPE for our Title Note**
Data_where: null
Users then add the Title Note element to their Output Set, and use the Execute an Output Set report to return this information for all the Constituents in a List.
Cheers
Kim
Kim Lee Application support Analyst
KIMLEE@SYDNEYOPERAHOUSE.COM
T+61 2 9250 7679 F+61 2 9251 7821
SYDNEY OPERA HOUSE BENNELONG POINT
GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA
SYDNEYOPERAHOUSE.COM
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Patrick Schley Sent: Friday, 25 June 2010 00:37 To: Kim Lee Subject: [Tessitura Technical Forum] Research Notes Export
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!
Please consider the environment before printing this email.=====This message is intended for the addressee(s) named and may contain confidential information.If you are not the intended recipient, please delete it and notify the sender.Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
One thing to note on Kim's suggestion is that long notes (I believe over 255 characters) and carriage returns (not sure if that is the correct term to use) do not translate well when saving to a file so if the notes being requested were originally pasted from other documents, emails etc. they might be a formatting nightmare.
If this is not an issue then to expand on Kim's suggestion you will want to remove the "where" clause in her "data from" code and add "a.note_type". (edit: corrected b.note_type to be a.note_type)
Updated Data From(select a.customer_no, b.notes, a.note_type from tx_cust_notes as a join tx_cust_notes_ext as b on a.cust_notes_no = b.cust_notes_no)
Add into "data where"note_type IN (<<p?>>)Where "?" equals the id number of the tr_query_element_parameter you create using these entries.
Description: Note TypeData Type: StringEnd Of Day: UncheckedMulti Select: Checked (optional)Ref Tbl: tr_cust_notes_typeRef id: idRef Desc: DescriptionRef Sort: Description