Answers.Body: <p>Searchkit looks like it can pull in related contact data</p>
  <p><a href="https://civicrm.stackexchange.com/questions/40990/search-view-that-shows-the-mutual-relationships-between-two-contacts">Search view that shows the mutual relationships between two contacts</a></p>
  <p>There's a bit of a learning curve, but I found this overview from a recent CiviCRM meetup really helpful</p>
  <p><a href="https://youtu.be/-YJyRt02vvw" rel="nofollow noreferrer">https://youtu.be/-YJyRt02vvw</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-11T11:42:55.223Z
Answers.LastActivityDate: 2022-05-11T11:42:55.223Z
Answers.UserDisplayName: Craig Almond
Answers.Body: <p>Partly depends who needs to see the report but we tend to build all such results in Drupal Views.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-28T08:15:58.690Z
Answers.Text: Hi Pete,
  Right now I want to list all members, which is fine, almost - my view doesn't show the club they are member of, even though they are in relationship with the club in their contact panel.
  Also, I've got trouble building a filter to show a dropdown of all clubs so the list can be limited.
  Thnx
Answers.UserDisplayName: Ralph
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-19T04:41:39.340Z
Answers.Text: using views 'relationships' you should be able to join to the required tables and get the required. v overdue reply. apologies
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-28T03:13:06.553Z
Answers.LastActivityDate: 2018-12-28T03:13:06.553Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I have my organisation split between local sport clubs.
  I'm looking for a best way to list all members of particular clubs - should I use Drupal Views or Civi search'es or reports?
  Thnx
  R.</p>
  
Tags: <drupal-views>
Title: List members of organisation belonging to sub-types
ThreadText: # List members of organisation belonging to sub-types
  
  (Asked by: username_0 on 2018-12-27)
  
  I have my organisation split between local sport clubs.
  I'm looking for a best way to list all members of particular clubs - should I use Drupal Views or Civi search'es or reports?
  Thnx
  R.
  
  **Tags:** drupal-views
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-05-11. Score: 2
  
  Searchkit looks like it can pull in related contact data
  
  [Search view that shows the mutual relationships between two contacts](https://civicrm.stackexchange.com/questions/40990/search-view-that-shows-the-mutual-relationships-between-two-contacts)
  
  There's a bit of a learning curve, but I found this overview from a recent CiviCRM meetup really helpful
  
  <https://youtu.be/-YJyRt02vvw>
  
  
  ---
  
  ### Answer by username_2 on 2018-12-28. Score: 1
  
  Partly depends who needs to see the report but we tend to build all such results in Drupal Views.
  
  > **Comments:**
  > **username_0**: Hi Pete, Right now I want to list all members, which is fine, almost - my view doesn't show the club they are member of, even though they are in relationship with the club in their contact panel. Also, I've got trouble building a filter to show a dropdown of all clubs so the list can be limited. Thnx  
  > **username_2**: using views 'relationships' you should be able to join to the required tables and get the required. v overdue reply. apologies  
  
  ---
  
  