CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Adding Membership Status to Advanced search output
Pages: [1]

Author Topic: Adding Membership Status to Advanced search output  (Read 271 times)

groston

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.34
  • PHP version: 5.3.27
Adding Membership Status to Advanced search output
July 04, 2014, 08:15:13 am
I just learned how to customize the output of an Advanced Search: http://wiki.civicrm.org/confluence/display/CRMDOC/Format+Advanced+Search+Result+Columns. This is very helpful.

My custom search profile currently contains a single field: field Individual::Current Employer

I would like to add one additional field to the output of this report: Membership::Membership Status. However, when I select Membership from the dropdown list for Field Name (in CiviCRM Profile Fields), the following error message is displayed: Membership can not be used as a Result Column for profile searches.

Is there a way to work around this?

Thank you.

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Adding Membership Status to Advanced search output
July 04, 2014, 09:54:35 am
The reason this can't be done is because someone can have multiple memberships, but advanced search output should only have one line per contact.

You could do it with some custom coding, but you might be better served by using a membership report.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Adding Membership Status to Advanced search output

This forum was archived on 2017-11-26.