Mail Preferences\Address\Address line 1 is blank in Query Results

When using the Primary Address of constituents in a mail preference, the query results of the field Mail Preferences\Address\Address fields are blank. 
Output the primary address from the 'Primary Address' node within the query

Steps to Duplicate

  1.  Go to the Communications tab of a constituent record that has a mail preference added
  2.  Edit the mail preference and assure that the Selected address is Primary Address
  3. Then go to the Analysis tab in CRM and click Information Library to create a new ad-hoc query 
  4. Create a constituent query to search for the constituent mentioned in step 1, and add the Mail Preferences\Address\Address line 1 as an output
  5. Preview the results of the query and notice that the  Mail Preferences\Address\Address line 1 is blank. 


 Blackbaud CRM

Was this article helpful?