Gift by Membership Field is blank in my query

When creating a constituent query the gift by field is blank in the Results fields to display, however it is not blank on the membership record.
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Go to analysis > information library > click add ad-hoc query > choose constituent
  2. On the left expand member > select membership > in the middle drag membership status to Include records where and set equal to active
  3. On the left expand member > expand memberships > expand membership transaction > expand given by
  4. In the middle > select name and drag to results fields to display
  5. Preview results and see only minimal fields are populated

Environment

 Altru Arts & Cultural

Was this article helpful?