• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 35 views
  • Users 0 members are here
Related

Contribution_cont_amt

Beth Hawryluk
$organization

Hello Tessiturians!

We're trying to make an output set for our telefunding campaign that will give us all the necessary constituent info as well as their donation history (amount, date, and fund).

We've found the various criteria segments that we want but when we run it it doesn't give us the information we are expecting according to what we see on the constituent record.

I suspect the culprit is contribution_cont_amt. When we add that segment it asks for a start and end date as well as a fund.

The result of our output set is the constituent info (which is correct), a column with all of their contribution dates (which is also correct), a column with the funds associated to the contribution dates (also correct), and a column where the contribution amount is supposed to be... but that column is a nightmare.
If they made a contribution to the particular fund we selected then it says that same amount beside all of their funds. If they didn't make a contribution to that fund we get nothing.

Our telefunding campaign will be covering many different funds. Is there a way to fix this? Help!

Parents
  • $organization

    Beth

     

    Rather than deleting the where clause in that element, why not create another element without the where clause and use it. You never know, sometime down the track you may want the element to have the where clause again.

     

    Cheers

    Sandra

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Thursday, 10 November 2011 3:02 AM
    To: Sandra Ashby
    Subject: Re: [Tessitura Technical Forum] Contribution_cont_amt

     

    Hi Bryan,

    Yes I am being prompted for parameters. In TR_QUERY_ELEMENT these are my contents:

    Description: Contribution_cont_amt
    Category: Contribution
    Data Select: !.cont_amt
    Data From: (select a.*,fund_desc = b.description,camp_desc = c.description from t_contribution a JOIN vs_fund b ON a.fund_no = b.fund_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)
    Data Where: cont_dt between <<p1>> and <<p2>> and fund_no in (<<p3>>)

    Just taking a wild guess here, but I'm assuming my problem is the Data Where column? If so, can I just delete that info and then stop getting prompted for parameters?

     

    Thanks!

    From: Bryan Evans <bounce-bryanevans4162@tessituranetwork.com>
    Sent: 11/9/2011 9:19:14

    Hi Beth,

    You say you are prompted for start and end dates as well as a fund when using contribution_cont_amt?  From what I can tell, there are no parameters associated with this element out of the box.  Can you please post the contents of the contribution_cont_amt from your TR_QUERY_ELEMENT table?

    Thanks,

    Bryan Evans
    Manager of Data Analysis
    Cincinnati Symphony and Pops Orchestras
    513.744.3283
    bevans@cincinnatisymphony.org
    www.cincinnatisymphony.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

  • $organization in reply to Sandra Ashby

    Hi Sandra!

    Excellent idea! Thanks very much for that suggestion.

Reply Children
No Data