Hi there,
I am trying to find a report or create a list of contributions that come through the web and have a Web MOS.
List manager with that criteria will give me constituents that have given to the chosen campaign with contributions with that MOS and ticket purchases with the MOS.
Contributions through Web are processed through a ticket batch (even if a ticket is not purchased) with MOS Web. Contributions below a specified dollar amount are auto processed and do not go through a gift processor
We are not on TNEW. We do not use channels.
Based on this, Is there a way to find only those constituents who have only given with the MOS web.
Hi Michelle,
Why not create a View which list criteria can reference such as:
select o.MOS, c.* from T_CONTRIBUTION c
join T_TRANSACTION t on c.ref_no = t.ref_no
join T_ORDER o on t.order_no = o.order_no
where o.MOS in (5, 11, 12, 24)
and if you just want contributions only (with no ticket purchase), you could add:
and o.tot_contribution_paid_amt = o.tot_paid_amt
cheers,
Kevin
There is a better table the t_transaction for joining orders to contributions
select o.MOS,c.* from T_CONTRIBUTION c (NOLOCK)join T_ORDER_CONTRIBUTION oc (NOLOCK) on c.ref_no = oc.ref_nojoin T_ORDER o (NOLOCK) on oc.order_no = o.order_nowhere o.MOS in (5, 11, 12, 24)
Mark