Answers.Body: <p>Suggestion made on MM was that the Description field is available in Views and may be useful for folks in similar situations.</p>
  
  <p>To get custom fields on Relationships available in Views will require some additional code in the 'civi views' module.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-07T21:14:45.597Z
Answers.Text: Yes - thanks Pete - we ended up revising the field mapping to go into Description instead.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-07T18:22:10.157Z
Answers.LastActivityDate: 2016-12-07T18:22:10.157Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Relationship is e.g. Board Member - custom data on that Relationship is e.g. Treasurer (or President). </p>
  
  <p>We can pull the Relationship into a View but even using CiviCRM Relationships as a base table - we can't seem to add the Custom data as Fields.</p>
  
  <p>We double checked that the specific table got copied into the settings.php:
    'civicrm_value_committee_relationship_data_7' => '<code>civicrm_project_org</code>.',</p>
  
  <p>Curious if anyone has any ideas on how to get this working!</p>
  
  <p>On 4.6 LTS for this project; </p>
  
Tags: <drupal><drupal-views>
Title: How can we get Custom data Used For: Relationships to display in a Drupal View?
ThreadText: # How can we get Custom data Used For: Relationships to display in a Drupal View?
  
  (Asked by: username_0 on 2016-12-07)
  
  Relationship is e.g. Board Member - custom data on that Relationship is e.g. Treasurer (or President).
  
  We can pull the Relationship into a View but even using CiviCRM Relationships as a base table - we can't seem to add the Custom data as Fields.
  
  We double checked that the specific table got copied into the settings.php:
  'civicrm\_value\_committee\_relationship\_data\_7' => '`civicrm_project_org`.',
  
  Curious if anyone has any ideas on how to get this working!
  
  On 4.6 LTS for this project;
  
  **Tags:** drupal, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-12-07. Score: 1 | Accepted answer
  
  Suggestion made on MM was that the Description field is available in Views and may be useful for folks in similar situations.
  
  To get custom fields on Relationships available in Views will require some additional code in the 'civi views' module.
  
  > **Comments:**
  > **username_0**: Yes - thanks Pete - we ended up revising the field mapping to go into Description instead.  
  
  ---
  
  