Hello all,
I recently set up a Fee to sell merchandise while troubleshooting a ticketing issue, with a view to overriding the Fees later, and adding in the merchandise performances. Now I am up to that stage, I realize I do not have a simple way to narrow down the effected orders, doh!
Does anyone have a custom List Manager criteria to manage Constituents who paid a certain Fee, or any other way to isolate Orders or Constituents by a certain Fee?
Best,Nicholas
Hello all, I recently set up a Fee to sell merchandise while troubleshooting a ticketing issue, with a view to overriding the Fees later, and adding in the merchandise performances. Now I am up to that stage, I realize I do not have a simple way to narrow down the effected orders, doh! Does anyone have a custom List Manager criteria to manage Constituents who paid a certain Fee, or any other way to isolate Orders or Constituents by a certain Fee? Best, Nicholas This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Best, Nicholas
Hi, Nicholas:
Get your friendly neighborhood DBA to run the following queries for you:
/**first, find the fee id numbers**/
select * from t_fee
where season = ## the fee id from the first query
______________________________Lucie SpielerIT Development and Training Manager
Both very good suggestions, thank you so much Catherine and Lucie!
Lucie
I tried to post the code twice, and it was garbled twice, so now I'm typing directly into the forum at www.tessituranetwork.com:
where season = ## --put your season number here
/**now, get the order number and customer number of anyone who has a transaction involving a particular fee**/
select b.customer_no, a.trn_amt, a.order_no
from T_TRANSACTION a
join T_ORDER b on b.order_no = a.order_no
where a.fee_no = ### --the fee id from the first query
Hello!
Where would one find the Fee ID? Or what query should be run to find it?
Thanks!
Hi, Mary:
The code is in the copy you forwarded with your message. I don’t know of a place in the Tessitura client where you can see the fee number. The first and second columns of the T_FEE table are fee_no and season. The fee id I was referring to is the fee_no value.
Florida Grand Opera
Thanks very much! I was able to run a query to get the ID as you suggested.