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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.