Answers.Body: <p><a href="https://www.drupal.org/project/views_civicrm_expose_tables" rel="nofollow noreferrer">Views CiviCRM Expose Tables</a> might work for you.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-21T11:36:31.700Z
Answers.LastActivityDate: 2020-05-21T11:36:31.700Z
Answers.UserDisplayName: Aidan
Body: <p>I'd like to extract contacts who have been added to a certain group for a given date or date range. This information is in table civicrm_subscription_history which is included in my Drupal settings file, along with every other CiviCRM table.  But this table doesn't appear in Views - it seems that only a selection of CiviCRM tables appear, and I don't understand why this is. How can I access this table in Views? (I know this is perhaps more of a Views question but hopefully it's also enough of a CiviCRM question!) Using Civi 5.24.5 &amp; Drupal 7.69</p>
  
Tags: <drupal><drupal-views>
Title: How to access civicrm_subscription_history in Views?
ThreadText: # How to access civicrm_subscription_history in Views?
  
  (Asked by: username_0 on 2020-05-19)
  
  I'd like to extract contacts who have been added to a certain group for a given date or date range. This information is in table civicrm\_subscription\_history which is included in my Drupal settings file, along with every other CiviCRM table. But this table doesn't appear in Views - it seems that only a selection of CiviCRM tables appear, and I don't understand why this is. How can I access this table in Views? (I know this is perhaps more of a Views question but hopefully it's also enough of a CiviCRM question!) Using Civi 5.24.5 & Drupal 7.69
  
  **Tags:** drupal, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-05-21. Score: 2
  
  [Views CiviCRM Expose Tables](https://www.drupal.org/project/views_civicrm_expose_tables) might work for you.
  
  
  ---
  
  