I'm trying to create a view to show both CiviEvents and Drupal Events filtered by dates.
I can create a Drupal view to show Drupal Events fields and I can create a view to show CiviEvent fields but I can't create a view to show both. Am I missing something obvious here or is it not possible due to the two databases.
We are using Drupal 7 and civicrm 4.7.24. We have seperate databases and have the CiviCRM Entity module installed.