• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 37 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

    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

  • $organization in reply to Bryan Evans

    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!

Reply
  • $organization in reply to Bryan Evans

    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!

Children
No Data