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
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!