• Replies 5 replies
  • Subscribers 412 subscribers
  • Views 56 views
  • Users 0 members are here
Related

Contributions with MOS

Michelle Wohlers
$organization

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.

Parents
  • $organization

    Thank you Kevin,

     

    I am not a sql guru, but I understand how to manipulate some of the information if I am given the language. I am  crating a manual entry in list manager?

     

    How/where do I define a particular campaign or date range?  I can find the id codes for them?

     

    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 Kevin Madeira
    Sent: Wednesday, April 29, 2015 5:17 PM
    To: Michelle Wohlers
    Subject: Re: [Tessitura Development Forum] Contributions with MOS

     

    Hi Michelle,

    Why not create a View which list criteria can reference to reference it 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

    From: Michelle Wohlers <bounce-michellewohlers7363@tessituranetwork.com>
    Sent: 4/29/2015 7:28:30 PM

    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.




    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!

Reply
  • $organization

    Thank you Kevin,

     

    I am not a sql guru, but I understand how to manipulate some of the information if I am given the language. I am  crating a manual entry in list manager?

     

    How/where do I define a particular campaign or date range?  I can find the id codes for them?

     

    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 Kevin Madeira
    Sent: Wednesday, April 29, 2015 5:17 PM
    To: Michelle Wohlers
    Subject: Re: [Tessitura Development Forum] Contributions with MOS

     

    Hi Michelle,

    Why not create a View which list criteria can reference to reference it 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

    From: Michelle Wohlers <bounce-michellewohlers7363@tessituranetwork.com>
    Sent: 4/29/2015 7:28:30 PM

    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.




    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!

Children
No Data