Hi Everyone,
Our development team is looking to include/use the Appeal column through extraction and output set. 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 extraction/Output Set?
Thanks
Eric Lazaro
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