Answers.Body: <p>This works for me - add</p>
  <ul>
  <li>The username of the content author</li>
  <li>Relate CiviCRM contact to the user</li>
  </ul>
  <p>the latter is grouped under 'user' not 'civicrm' in the offerings. HTH</p>
  <p><a href="https://i.sstatic.net/pzwo0Rrf.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pzwo0Rrf.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.sstatic.net/xFDPo37i.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xFDPo37i.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-06-27T01:08:41.720Z
Answers.Text: Thanks for the reply. I've updated my post with a screenshot of relationship categories. User is not one of them even after adding the username field.
Answers.UserDisplayName: Justin Moore
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-06-28T20:33:30.090Z
Answers.Text: Are your civi tables in a separate DB?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-06-26T23:00:10.877Z
Answers.LastActivityDate: 2024-06-26T23:00:10.877Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Drupal 10 - CiviCRM 5.74.4</p>
  <p>Using webform, authenticated users can create Drupal content of type 'Post'. The 'authored by' field is of course the logged in Drupal user.</p>
  <p>I am using a view to display 'Post' content. I need to be able display CiviCRM user data alongside the Drupal user data. For example, I may want display City, State for the author.</p>
  <p>When I try to add a relationship, there are no CiviCRM options.</p>
  <p><a href="https://i.sstatic.net/nSUcxgJP.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nSUcxgJP.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-06-26T22:08:18.453Z
Comments.Text: I do have configured Entity installed and configured and Contacts are enabled.
Comments.UserDisplayName: Justin Moore
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-06-27T20:16:18.030Z
Comments.Text: What version of civicrm_entity are you using?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-06-27T20:18:35.987Z
Comments.Text: FYI i have nothing set in CiviCRM Entity settings, as those settings are not required just for getting civi data in to Views. Only other thought is whether your civi data is in same or different database. if in different then there are extra steps which i can't quickly summarise as we have ours in a single DB
Comments.UserDisplayName: petednz - fuzion
Tags: <drupal><drupal-views>
Title: Display CiviCRM user data alongside Drupal user data
ThreadText: # Display CiviCRM user data alongside Drupal user data
  
  (Asked by: username_0 on 2024-06-26)
  
  Drupal 10 - CiviCRM 5.74.4
  
  Using webform, authenticated users can create Drupal content of type 'Post'. The 'authored by' field is of course the logged in Drupal user.
  
  I am using a view to display 'Post' content. I need to be able display CiviCRM user data alongside the Drupal user data. For example, I may want display City, State for the author.
  
  When I try to add a relationship, there are no CiviCRM options.
  
  [![enter image description here](https://i.sstatic.net/nSUcxgJP.png)](https://i.sstatic.net/nSUcxgJP.png)
  
  **Tags:** drupal, drupal-views
  
  > **Comments:**
  > **username_0**: I do have configured Entity installed and configured and Contacts are enabled.  
  > **username_1**: What version of civicrm_entity are you using?  
  > **username_1**: FYI i have nothing set in CiviCRM Entity settings, as those settings are not required just for getting civi data in to Views. Only other thought is whether your civi data is in same or different database. if in different then there are extra steps which i can't quickly summarise as we have ours in a single DB  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-06-26. Score: 1
  
  This works for me - add
  
  * The username of the content author
  * Relate CiviCRM contact to the user
  
  the latter is grouped under 'user' not 'civicrm' in the offerings. HTH
  
  [![enter image description here](https://i.sstatic.net/pzwo0Rrf.png)](https://i.sstatic.net/pzwo0Rrf.png)
  
  [![enter image description here](https://i.sstatic.net/xFDPo37i.png)](https://i.sstatic.net/xFDPo37i.png)
  
  > **Comments:**
  > **username_0**: Thanks for the reply. I've updated my post with a screenshot of relationship categories. User is not one of them even after adding the username field.  
  > **username_1**: Are your civi tables in a separate DB?  
  
  ---
  
  