Answers.Body: <p>You need to add it in settings.php not civicrm.settings.php. once you add them in settings file clear Drupal cache</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-11T04:23:46.160Z
Answers.Text: Thank you very much for your fast answer. This served the problem with the different databases,
Answers.UserDisplayName: paul77
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-11T04:27:52.060Z
Answers.Text: What remains is my starting problem. I now can display the structure of custom fields in Views but I haven't found a way to display its contents. What I want is to have a view that display the content of several custom fields that belongs to a certain Durpal user. Can anybody help here?
Answers.UserDisplayName: paul77
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-14T19:01:21.447Z
Answers.Text: There was probably I misconfiguration of civicrm, not everything works as expected.
Answers.UserDisplayName: paul77
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-09T21:58:59.047Z
Answers.LastActivityDate: 2020-09-09T21:58:59.047Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I've been not very experienced with CiviCRM. I try to get CiviCRM custom fields displayed in Views.
  I've installed Drupal 8.9.3., CiviCRM 5.28.3, CiviCRM Entity 8.x-3.0-beta1.</p>
  <p>Drupal and CiviCRM run on different databases on the same server with the same database user.
  In added the array with the links to the correct database to civicrm.settings.php as described in <a href="https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/</a>.</p>
  <p>In Drupal 7, when I created a view(user) I was offered different CiviCRM fields. This doesn't happen in my Drupal 8 installation.</p>
  <p>Besides when In try to create a view(contacts) I get the following error message:</p>
  <pre><code>SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_p550866_1.civicrm_contact' doesn't exist: SELECT civicrm_contact.id AS id FROM {civicrm_contact} civicrm_contact LIMIT 11 OFFSET 0; Array ( ) 
  </code></pre>
  <p>(usr_p550866_1 is the database for Drupal)</p>
  <p>Is this a problem with Drupal 8 or do I anything wrong?</p>
  <p>Your help would be appreciated very much.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-09T20:03:18.390Z
Comments.Text: Hi Paul - this might get marked as a Duplicate Question - does the answer here help? https://civicrm.stackexchange.com/a/31146/96
Comments.UserDisplayName: petednz - fuzion
Tags: <drupal-views><drupal-8>
Title: How to display CiviCRM Custom Fields in a Drupal 8 View
ThreadText: # How to display CiviCRM Custom Fields in a Drupal 8 View
  
  (Asked by: username_0 on 2020-09-09)
  
  I've been not very experienced with CiviCRM. I try to get CiviCRM custom fields displayed in Views.
  I've installed Drupal 8.9.3., CiviCRM 5.28.3, CiviCRM Entity 8.x-3.0-beta1.
  Drupal and CiviCRM run on different databases on the same server with the same database user.
  In added the array with the links to the correct database to civicrm.settings.php as described in https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/.
  In Drupal 7, when I created a view(user) I was offered different CiviCRM fields. This doesn't happen in my Drupal 8 installation.
  Besides when In try to create a view(contacts) I get the following error message:
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_p550866_1.civicrm_contact' doesn't exist: SELECT civicrm_contact.id AS id FROM {civicrm_contact} civicrm_contact LIMIT 11 OFFSET 0; Array ( ) 
  
  (usr_p550866_1 is the database for Drupal)
  Is this a problem with Drupal 8 or do I anything wrong?
  Your help would be appreciated very much.
  
  **Tags:** drupal-views, drupal-8
  
  > **Comments:**
  > **username_1**: Hi Paul - this might get marked as a Duplicate Question - does the answer here help? https://civicrm.stackexchange.com/a/31146/96  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-09-09. Score: 1
  
  You need to add it in settings.php not civicrm.settings.php. once you add them in settings file clear Drupal cache
  
  > **Comments:**
  > **username_0**: Thank you very much for your fast answer. This served the problem with the different databases,  
  > **username_0**: What remains is my starting problem. I now can display the structure of custom fields in Views but I haven't found a way to display its contents. What I want is to have a view that display the content of several custom fields that belongs to a certain Durpal user. Can anybody help here?  
  > **username_0**: There was probably I misconfiguration of civicrm, not everything works as expected.  
  
  ---
  
  