• Replies 2 replies
  • Subscribers 412 subscribers
  • Views 62 views
  • Users 0 members are here
Related

Missing Acknowledgements

Mary French
$organization

So looks like we missed a few acknowledgment setups for the fiscal year...that were then addedbut now we have gifts with no acknowledgment selected...

 anyone know a good way to find contributions with no acknowledgment selected????

 

Parents
  • $organization

    I think you can find them with something like this

    select a.* from T_CONTRIBUTION a
    where not exists (select * from T_ACK_EXT where cont_ref_no = a.ref_no)
    order by a.ref_no

    You'll want to add in something like cont_dt or campaign_no/appeal_no to limit the output though.

     

    Edit - Didn't see your followup until after I posted. Nice to know it can be done so quickly and easily!



    [edited by: Ryan Rowell at 3:29 PM (GMT -6) on 30 May 2013]
Reply
  • $organization

    I think you can find them with something like this

    select a.* from T_CONTRIBUTION a
    where not exists (select * from T_ACK_EXT where cont_ref_no = a.ref_no)
    order by a.ref_no

    You'll want to add in something like cont_dt or campaign_no/appeal_no to limit the output though.

     

    Edit - Didn't see your followup until after I posted. Nice to know it can be done so quickly and easily!



    [edited by: Ryan Rowell at 3:29 PM (GMT -6) on 30 May 2013]
Children
No Data