Campaign Goals are not showing in query

Within CRM, it is possible to add Campaign Goals.  After creating a Campaign with an associated Goal, you may notice that the Goal does not show up when attempting to output it using a Campaign query.  
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Steps to Duplicate

1.  Log-in to 4.0.  
2.  Go to Fundraising and click Add a campaign.  Save.
3.  On the Goals tab, add a Goal.  Save.
4.  Go to Analysis, Information Library, and add a Campaign Ad-hoc Query.
Filter on your Campaign from step 2.  
Output:   
Name
Goals\Amount
Goals\Name
Goals\Start date 
5.  Run your query and notice it returns no results for the Goal output fields.  

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 9

Was this article helpful?