Query results display wrong Name on Card

Membership Queries can be used to gather information on members.  When including Other Members/Card Holders > Name on Card in the output, the primary member is listed as the Name on Card for other members if the other member is also a constituent. 

This functionality occurs in Query because the Editable flag of the Name On Card field is set to 'No' in the database so the Query results will display the linked salutation in place of Name On Card. If the Editable field is set to True for the Name On Card field the results will display the same name which is displayed in Name On Card field of the membership Card. Query functionality is designed to be a grouping tool in Raiser's Edge. To report on this field users should attempt the following alternate options.

Alternate workarounds
Use a Constituent Query with the same filters

OR

Include your existing query of members in a Constituent Export. Select the desired fields in Output, including Membership > Cards > Name on Card. Be sure to enter an appropriate value (more than 3) in the field "For each Membership, enter the number of Cards to export.

As long as a large enough number is selected, all of the "Name on Card" information will be listed in the export spreadsheet correctly.

Environment

 Raiser's Edge
 7.94
 7.91.5056
 7.93.5782

Was this article helpful?