Answers.Body: <p>Can't you go to Advanced Search &amp; select the memberships you want - you can select which statuses you want, too - the results show status and date of membership if you select to <strong>Display Results As</strong> Membership - unless I don't understand your question.</p>
  
  <p>Note: For v4.5 and below, <strong>Display Results As</strong> is in the top right of the Basic Criteria frame in an Advanced Search.</p>
  
  <p>In 4.6 <strong>Display Results As</strong> is in the "Search Settings" grouping at the bottom of the Basic Criteria frame in an Advanced Search.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-19T01:03:12.867Z
Answers.Text: Lesley - my apologies for not reading your answer more carefully. Selecting Display Results as Memberships does show the selected Membership(s) for each contact in that Group (I chose only Current and Expired). So if I could select Display Results as Contacts (using my custom Search View), showing *all* contacts in that Group, members and non-members, and any associated membership(s) for that contact (if any exist), that would be ideal.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-18T20:55:18.473Z
Answers.LastActivityDate: 2015-07-20T03:01:00.477Z
Answers.LastEditDate: 2015-07-20T03:01:00.477Z
Answers.UserDisplayName: Lesley Evensen
Answers.Body: <p>Joe - I think a View is probably a good approach for you to take. If you do so, pls consider attaching it here so others can try it out.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-28T03:27:05.977Z
Answers.Text: Peter, thx, will do that
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-20T03:37:01.217Z
Answers.LastActivityDate: 2015-07-20T03:37:01.217Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>With regard to finding people who have aren't members, if you can't do this via a view I think you will need a smart group of people in your Group who have a membership and then use the include/exclude custom search (or perhaps Search Builder) to find people in the Group but not in the smart group.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-19T00:28:07.383Z
Answers.LastActivityDate: 2015-07-19T00:28:07.383Z
Answers.UserDisplayName: JoAnne
Body: <p>What can be done to make Membership - Membership Status in particular - a Result Column for profile searches? I want to be able to show Status in a Search View.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-17T00:03:29.987Z
Comments.Text: Joe - what does the outcome need to be here - who is it for? is it something Views does more easily perhaps?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T17:01:53.103Z
Comments.Text: Peter, one goal is to be able to have a Search View which shows the members of a Group and the Membership Status(es) for each member of that Group, with other fields - for example, in the Leadership Ladder profile/search view in our Citizen Action production site. I'll try doing it in Views but having the ability to easily add Membership Status as a Results Column directly in Civi - whether in a Search View or a Report - whether one is on Drupal, Wordpress or Joomla - seems pretty basic and essential for a CRM.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T20:53:59.480Z
Comments.Text: Can't you go to Advanced Search & select the memberships you want - you can select which statuses you want, too - the results show status and date of membership if you select to show results as Membership - unless I don't understand your question
Comments.UserDisplayName: Lesley Evensen
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T21:43:40.730Z
Comments.Text: Joe - if someone has multiple memberships (eg old ones and current ones) do you want a single row per contact, or will you accept multiple rows? The thing with memberships to contacts is that it is not a 1-1 relationship. Is the 'Search View' meant to be for Contacts or for Memberships?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T23:41:09.867Z
Comments.Text: Pete- I would like to see all membership statuses for any contact in any Group via Profiles/ Search Views in Civi - or at least the latest/last membership status - and if that contact has never had a membership, for the contact name to still appear, especially, because we need to sign them up as a member.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T23:42:18.490Z
Comments.Text: Lesley - here's why Search Builder and Advanced Search don't (yet) work for this. Say I have group of contacts, and I select that Group in Search Builder ( Group(s) = group_name ) and select Membership Status(s) Not Empty. I get a result of  just those group member names who have a membership status - but not result showing status - so I have to click through each record individually to see the membership status. This also will not show any members of the Group with no status - because they are not members.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T23:43:09.037Z
Comments.Text: Lesley - this is part 2 of the above comment. Using Advanced Search, I can choose the same group, and Membership Status of Current, Expired or Terminated and I get the same thing - a list of names only, and again I have to click through each individual record, and again, members of that Group who have never been members do not appear in the result anyway. So - a Profile/Search View that would show all, or at least latest, Membership Status would be very useful.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-18T23:43:34.647Z
Comments.Text: Lesley - this is part 3 of the above comment. And for the fields selected through Search Builder or Advanced Search to show in the result list - rather than just the contact name - would be very useful.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-19T00:38:32.483Z
Comments.Text: Lesley - my apologies for not reading your answer more carefully. Selecting Display Results as Memberships does show the selected Membership(s) for each contact in that Group (I chose only Current and Expired). So if I could select Display Results as Contacts (using my custom Search View) *and* any associated membership(s) for that contact (if any exist), that would be ideal.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-19T20:28:13.653Z
Comments.Text: Joe - still sounds like a View might be simplest
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-19T22:15:24.923Z
Comments.Text: Petednz, yeah working on a view.
Comments.UserDisplayName: Joe McLaughlin
Tags: <civimember><profile><search><user><ui>
Title: "Membership can not be used as a Result Column for profile searches" - why not?
ThreadText: # "Membership can not be used as a Result Column for profile searches" - why not?
  
  (Asked by: username_0 on 2015-07-16)
  
  What can be done to make Membership - Membership Status in particular - a Result Column for profile searches? I want to be able to show Status in a Search View.
  
  **Tags:** civimember, profile, search, user, ui
  
  > **Comments:**
  > **username_1**: Joe - what does the outcome need to be here - who is it for? is it something Views does more easily perhaps?  
  > **username_0**: Peter, one goal is to be able to have a Search View which shows the members of a Group and the Membership Status(es) for each member of that Group, with other fields - for example, in the Leadership Ladder profile/search view in our Citizen Action production site. I'll try doing it in Views but having the ability to easily add Membership Status as a Results Column directly in Civi - whether in a Search View or a Report - whether one is on Drupal, Wordpress or Joomla - seems pretty basic and essential for a CRM.  
  > **username_2**: Can't you go to Advanced Search & select the memberships you want - you can select which statuses you want, too - the results show status and date of membership if you select to show results as Membership - unless I don't understand your question  
  > **username_1**: Joe - if someone has multiple memberships (eg old ones and current ones) do you want a single row per contact, or will you accept multiple rows? The thing with memberships to contacts is that it is not a 1-1 relationship. Is the 'Search View' meant to be for Contacts or for Memberships?  
  > **username_0**: Pete- I would like to see all membership statuses for any contact in any Group via Profiles/ Search Views in Civi - or at least the latest/last membership status - and if that contact has never had a membership, for the contact name to still appear, especially, because we need to sign them up as a member.  
  > **username_0**: Lesley - here's why Search Builder and Advanced Search don't (yet) work for this. Say I have group of contacts, and I select that Group in Search Builder ( Group(s) = group_name ) and select Membership Status(s) Not Empty. I get a result of  just those group member names who have a membership status - but not result showing status - so I have to click through each record individually to see the membership status. This also will not show any members of the Group with no status - because they are not members.  
  > **username_0**: Lesley - this is part 2 of the above comment. Using Advanced Search, I can choose the same group, and Membership Status of Current, Expired or Terminated and I get the same thing - a list of names only, and again I have to click through each individual record, and again, members of that Group who have never been members do not appear in the result anyway. So - a Profile/Search View that would show all, or at least latest, Membership Status would be very useful.  
  > **username_0**: Lesley - this is part 3 of the above comment. And for the fields selected through Search Builder or Advanced Search to show in the result list - rather than just the contact name - would be very useful.  
  > **username_0**: Lesley - my apologies for not reading your answer more carefully. Selecting Display Results as Memberships does show the selected Membership(s) for each contact in that Group (I chose only Current and Expired). So if I could select Display Results as Contacts (using my custom Search View) *and* any associated membership(s) for that contact (if any exist), that would be ideal.  
  > **username_1**: Joe - still sounds like a View might be simplest  
  > **username_0**: Petednz, yeah working on a view.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2015-07-18. Score: 2
  
  Can't you go to Advanced Search & select the memberships you want - you can select which statuses you want, too - the results show status and date of membership if you select to **Display Results As** Membership - unless I don't understand your question.
  
  Note: For v4.5 and below, **Display Results As** is in the top right of the Basic Criteria frame in an Advanced Search.
  
  In 4.6 **Display Results As** is in the "Search Settings" grouping at the bottom of the Basic Criteria frame in an Advanced Search.
  
  > **Comments:**
  > **username_0**: Lesley - my apologies for not reading your answer more carefully. Selecting Display Results as Memberships does show the selected Membership(s) for each contact in that Group (I chose only Current and Expired). So if I could select Display Results as Contacts (using my custom Search View), showing *all* contacts in that Group, members and non-members, and any associated membership(s) for that contact (if any exist), that would be ideal.  
  
  ---
  
  ### Answer by username_1 on 2015-07-20. Score: 1
  
  Joe - I think a View is probably a good approach for you to take. If you do so, pls consider attaching it here so others can try it out.
  
  > **Comments:**
  > **username_0**: Peter, thx, will do that  
  
  ---
  
  ### Answer by username_3 on 2015-07-19. Score: 1
  
  With regard to finding people who have aren't members, if you can't do this via a view I think you will need a smart group of people in your Group who have a membership and then use the include/exclude custom search (or perhaps Search Builder) to find people in the Group but not in the smart group.
  
  
  ---
  
  