Answers.Body: <p>A CMS-agnostic way to accomplish this is with SearchKit.  It ships with CiviCRM 5.42 but is disabled.  Enable it at <strong>Administer menu » System Settings » Extensions</strong>.  You'll also want to enable the Afform extensions.</p>
  <p>Then, go to <strong>Search menu » SearchKit</strong> and start a new search.  It's very SQL-like.  Start with contacts, join address and membership, and at the bottom you can select which fields you'd like to appear.  Ignore filters for now, unless you have some &quot;non-exposed&quot; filters.</p>
  <p>Once you've got the basic search down, save the search, and create a new display of type &quot;Table&quot; based on the search.  On this screen you can add exposed filters, rewrite any URLs you need, and make fields inline editable.</p>
  <p>This is a broad overview because what you want to do has several moving parts, but if you're comfortable with Views and you watch the SearchKit videos on the CiviCRM YouTube channel you should have no problem.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-08T21:11:12.557Z
Answers.Text: Is the Afform extention a must? link says, archived repo: https://lab.civicrm.org/extensions/afform
Answers.UserDisplayName: salah-1
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-08T21:17:27.253Z
Answers.Text: In search kit membership data not showing up when try to use "where" to join it with contacts
Answers.UserDisplayName: salah-1
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-09T16:46:50.320Z
Answers.Text: @salah-1 afform ships with CiviCRM now.  If you edit your question to include the URL generated by SearchKit I can look at it on my local machine.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-07T22:54:20.507Z
Answers.LastActivityDate: 2021-12-07T22:54:20.507Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>You can build this with CiviCRM Entity <a href="https://www.drupal.org/project/civicrm_entity" rel="nofollow noreferrer">https://www.drupal.org/project/civicrm_entity</a></p>
  <p>Enable the &quot;CiviCRM Contact&quot; entity type at the settings page, /admin/structure/civicrm-entity/settings</p>
  <p>You can start with a list of contacts, and add a Views Relationship to CiviCRM Addresses to get the state / zip</p>
  <p>Use Views field rewrites to make one of the fields linkable to /civicrm-contact/[contact-id]</p>
  <p>You can manage what fields show for the contact page at:
  /admin/structure/civicrm-entity/civicrm-contact/display</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-07T22:20:06.370Z
Answers.LastActivityDate: 2021-12-07T22:20:06.370Z
Answers.UserDisplayName: jackrabbithanna
Body: <p>I want to list all members by zip-code or city. Then the resulting page to be editable &amp; linkable.</p>
  <p>Also, want the resulting page to have &quot;exposed filter&quot; where someone can choose a city from dropdown filter and only list items for that city etc.</p>
  <p>By all members i mean: display: [name, membershp status, zipcode and city].</p>
  <p>I tried Drupal views, but then couldn't get the address data (zipcode and city) to show up and also couldn't get the resulting page to be editable/linkable (i.e when you click on a contact, to be taken to page where you can edit membership info (set expired to something else etc).</p>
  <p>I have done : advanced search -&gt; made it smart group, but couldn't get the resulting page to be linkable. In addition, the results were too much (I just want name, membership status, zip and city).</p>
  <p>By &quot;be linkable&quot; i mean i want access the final page as : <a href="http://myDomain.com/civicrm/some-link" rel="nofollow noreferrer">http://myDomain.com/civicrm/some-link</a>.</p>
  <p>Using Drupal 8/9 and civicrm 5.42</p>
  <p>Thanks for the directions</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-08T03:58:06.300Z
Comments.Text: Answers below are good, but you should be able to just do using Views, use Relationships to get the Addresses in, then build your link to go to the civi record itself, or a webform if you want less options shown to the user
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-08T05:31:03.793Z
Comments.Text: That's exactly how I would do it.
Comments.UserDisplayName: Jenni Simonis
Tags: <civimember><civicrm-entity>
Title: List all members by zipcode or city
ThreadText: # List all members by zipcode or city
  
  (Asked by: username_0 on 2021-12-07)
  
  I want to list all members by zip-code or city. Then the resulting page to be editable & linkable.
  
  Also, want the resulting page to have "exposed filter" where someone can choose a city from dropdown filter and only list items for that city etc.
  
  By all members i mean: display: [name, membershp status, zipcode and city].
  
  I tried Drupal views, but then couldn't get the address data (zipcode and city) to show up and also couldn't get the resulting page to be editable/linkable (i.e when you click on a contact, to be taken to page where you can edit membership info (set expired to something else etc).
  
  I have done : advanced search -> made it smart group, but couldn't get the resulting page to be linkable. In addition, the results were too much (I just want name, membership status, zip and city).
  
  By "be linkable" i mean i want access the final page as : <http://myDomain.com/civicrm/some-link>.
  
  Using Drupal 8/9 and civicrm 5.42
  
  Thanks for the directions
  
  **Tags:** civimember, civicrm-entity
  
  > **Comments:**
  > **username_1**: Answers below are good, but you should be able to just do using Views, use Relationships to get the Addresses in, then build your link to go to the civi record itself, or a webform if you want less options shown to the user  
  > **username_2**: That's exactly how I would do it.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_4 on 2021-12-07. Score: 3 | Accepted answer
  
  You can build this with CiviCRM Entity <https://www.drupal.org/project/civicrm_entity>
  
  Enable the "CiviCRM Contact" entity type at the settings page, /admin/structure/civicrm-entity/settings
  
  You can start with a list of contacts, and add a Views Relationship to CiviCRM Addresses to get the state / zip
  
  Use Views field rewrites to make one of the fields linkable to /civicrm-contact/[contact-id]
  
  You can manage what fields show for the contact page at:
  /admin/structure/civicrm-entity/civicrm-contact/display
  
  
  ---
  
  ### Answer by username_3 on 2021-12-07. Score: 3
  
  A CMS-agnostic way to accomplish this is with SearchKit. It ships with CiviCRM 5.42 but is disabled. Enable it at **Administer menu » System Settings » Extensions**. You'll also want to enable the Afform extensions.
  
  Then, go to **Search menu » SearchKit** and start a new search. It's very SQL-like. Start with contacts, join address and membership, and at the bottom you can select which fields you'd like to appear. Ignore filters for now, unless you have some "non-exposed" filters.
  
  Once you've got the basic search down, save the search, and create a new display of type "Table" based on the search. On this screen you can add exposed filters, rewrite any URLs you need, and make fields inline editable.
  
  This is a broad overview because what you want to do has several moving parts, but if you're comfortable with Views and you watch the SearchKit videos on the CiviCRM YouTube channel you should have no problem.
  
  > **Comments:**
  > **username_0**: Is the Afform extention a must? link says, archived repo: https://lab.civicrm.org/extensions/afform  
  > **username_0**: In search kit membership data not showing up when try to use "where" to join it with contacts  
  > **username_3**: @username_0 afform ships with CiviCRM now.  If you edit your question to include the URL generated by SearchKit I can look at it on my local machine.  
  
  ---
  
  