Answers.Body: <p>Now that the <a href="https://www.drupal.org/project/views_migration" rel="nofollow noreferrer">Drupal Views Migration</a> has been released it would be worth trying that, especially if you have several.</p>
  <p>In terms of your actual question, I think the answer is No.</p>
  <p>We have just started converting some d7 Views to D9 and as expected the 'relationship' (as in Views 'join') needs some manual intervention, especially for fields like Email, Address, Phone where those had been hard-coded in the d7 Views integration. But apart from that they came through in better shape than I expected.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-10-14T19:40:21.007Z
Answers.LastActivityDate: 2022-10-14T19:40:21.007Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>We are converting a number of D7 views (for reports) to D9 version.  Is it possible to copy the sql query from a D7 view to use in a D9 view.  The fields in Civi are the same.</p>
  
Tags: <drupal-views><sql><drupal-9>
Title: Transfer a D7 view sql query to a D9 view
ThreadText: # Transfer a D7 view sql query to a D9 view
  
  (Asked by: username_0 on 2022-10-13)
  
  We are converting a number of D7 views (for reports) to D9 version. Is it possible to copy the sql query from a D7 view to use in a D9 view. The fields in Civi are the same.
  
  **Tags:** drupal-views, sql, drupal-9
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-10-14. Score: 1
  
  Now that the [Drupal Views Migration](https://www.drupal.org/project/views_migration) has been released it would be worth trying that, especially if you have several.
  
  In terms of your actual question, I think the answer is No.
  
  We have just started converting some d7 Views to D9 and as expected the 'relationship' (as in Views 'join') needs some manual intervention, especially for fields like Email, Address, Phone where those had been hard-coded in the d7 Views integration. But apart from that they came through in better shape than I expected.
  
  
  ---
  
  