System fields are missing from the Social Media Accounts node in a constituent ad-hoc query

Although the CRM database table SOCIALMEDIAACCOUNT has the system fields, the Social Media Accounts node in a constituent Ad-hoc query, does not have the fields: Added by application, Added by user, Changed by application, Changed by user, Date added, and Date changed.
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1) In CRM, go to Analysis > Information Library > Add an Ad-hoc query > Constituent
2) Select the Social Media Accounts node and notice the the only System field is System record ID. The following fields are missing: Added by application, Added by user, Changed by application, Changed by user, Date added, and Date changed.

Environment

 Blackbaud CRM
 4.0
 4.0.180.1604

Was this article helpful?