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.
Thanks Mark,
I responded to Kevin’s email a few minutes ago, but the same questions would apply here.
We do not have someone on site that has access to the SQL Studio. Can this be done through a manual edit in list manager?
Gratefully,
Michelle
Michelle Wohlers
Tessitura and Data Services Manager
San Diego Opera 233 A Street, Suite 500
San Diego, CA 92101
Phone: (619) 232-7636
Fax: (619) 231-6915
www.sdopera.com
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mark Ridley Sent: Thursday, April 30, 2015 2:50 AM To: Michelle Wohlers Subject: Re: [Tessitura Development Forum] Contributions with MOS
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_no join T_ORDER o (NOLOCK) on oc.order_no = o.order_no where o.MOS in (5, 11, 12, 24)
Mark
From: Kevin Madeira <bounce-kevinmadeira9286@tessituranetwork.com> Sent: 4/29/2015 8:12:07 PM
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
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!
Try this query based on Mark's suggestion in Manual Edit, changing to your MOS IDs, Contribution Date range and Campaign Nos.
MOS IDs are found in MOS Set up (scroll to the very right of the screen) while Campaign No is found in in Campaign Set up.
Select Distinct a.customer_no
From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)
JOIN VS_CONTRIBUTION c (Nolock) ON c.customer_no = a.customer_no
JOIN T_ORDER_CONTRIBUTION oc (NOLOCK) on c.ref_no = oc.ref_no
JOIN T_ORDER o (NOLOCK) on oc.order_no = o.order_no
WHERE 1 = 1
AND o.MOS in (5, 11, 12, 24)
AND c.cont_dt between '2014/01/01' AND '2015/04/30 23:59:59'
AND c.campaign_no in (357, 369)