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
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:
/**first, find the fee id numbers**/
select * from t_fee
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!