Adding Appeal column in Contribution Report

Maybe someday we can just select the fields we want to include in reports rather than having to write SQL scripts!  I will be waiting for someone’s successful reply.  Thank you for including the script in your email.

Laura Chaney

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Eric Lazaro
Sent: Tuesday, May 26, 2015 3:02 PM
To: Laura Chaney
Subject: [Tessitura Development Forum] Adding Appeal column in Contribution Report

Hi Everyone,

Our development team is looking to include the Appeal column on their report. I tried to modify the TR_Query_Element with a query of

(select a.*,appeal_desc = b.description,camp_desc = c.description from T_APPEAL a JOIN VS_APPEAL b ON a.appeal_no = b.appeal_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)

It works when I run it in MS Studio but it does not work when Execute an Output Set.

Is there anyone including  the Appeal on their report with Output Set??

Thanks

Eric Lazaro

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!

Hi Ann,

You are right, your query is correct. I just bump again into a road block with sql error Ambiguous column name ‘cont_dt’.

Thanks for the correction on my query.

Eric

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ann True
Sent: Wednesday, May 27, 2015 12:46 PM
To: Eric Lazaro
Subject: Re: [Tessitura Development Forum] Adding Appeal column in Contribution Report

Hi Eric,

I'm assuming you're pulling a list of gifts, and not the appeal attached to the extraction. Your query isn't pulling anything from t_contribution to give you what's attached to the gift. I think this may be what you want:

(select a.*,appeal_desc = b.description,camp_desc = c.description from t_contribution a JOIN vs_APPEAL b ON a.appeal_no = b.appeal_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)

Hope that helps,

Ann