Answers.Body: <p>Actually you'll need to start with a CiviCRM Relationships View.</p>
  
  <p>If you start with a view of CiviCRM Cases, you may get bad data if they have multiple open case types with different case managers.</p>
  
  <p>So create a new view of CiviCRM Relationships, then in the advanced section add the Case ID relationship, then add the Contact A (the client) relationship and finally the Contact B (the case manager) relationship.<p>
  <a href="https://i.sstatic.net/OYFFD.png" rel="noreferrer"><img src="https://i.sstatic.net/OYFFD.png" alt="enter image description here"></a></p>
  
  <p>Add a Display Name field using relationship Contact A, then add another Display Name field using Contact B.</p>
  
  <p>Here are all of the fields I eventually added:<p>
  <a href="https://i.sstatic.net/y2S6q.png" rel="noreferrer"><img src="https://i.sstatic.net/y2S6q.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-02T00:19:38.307Z
Answers.Text: This is very thorough response. Thank you very much!
Answers.UserDisplayName: Kristine
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-09-12T23:27:38.040Z
Answers.Text: I +1'ed this answer, but I wonder if there could/should be the ability to start from cases and then pull in the the Roles. My scenario is for a Union dealing with Cases involving the Employer, but some part-timers have multiple employers, so I am adding the Employer as an 'Other Party' role. And of course one person may have multiple cases open so in Views we want to show summary of each Case, Status and which of their Employers it involved with links to webforms to then trigger an 'update' action
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-09-14T19:51:08.060Z
Answers.Text: I think there "should " be Pete but I don't think there is. I've tried multiple times to start from something other than a relationship view and it has always caused incorrect data to be displayed. Case roles seem to not be ironed out totally. They are challenging to say the least.
Answers.UserDisplayName: pmoz
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-22T17:16:02.180Z
Answers.Text: I don't know what version pmoz used but I repeated this in Drupal 9.
Answers.UserDisplayName: Tony Horrocks
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-24T14:37:40.057Z
Answers.Text: I have had exactly the same issue starting from Cases - I just could not pull it all in.  My Use Case was for a view that filtered by logged in User as the Case Manager, so I used a Contextual Filter.  The only way I could get it to work was to start with the Relationships view.  No idea why...!
Answers.UserDisplayName: ChumKui
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-01T00:39:02.080Z
Answers.LastActivityDate: 2015-10-01T00:39:02.080Z
Answers.UserDisplayName: pmoz
Body: <p>I have created a CiviCRM Cases View. How would I add a column for "Case Manager" role to the Views? I am unable to find the field where that can be displayed.</p>
  
Tags: <civicase><drupal-views><roles>
Title: Adding Case Role to CiviCRM Cases Views
ThreadText: # Adding Case Role to CiviCRM Cases Views
  
  (Asked by: username_0 on 2015-09-30)
  
  I have created a CiviCRM Cases View. How would I add a column for "Case Manager" role to the Views? I am unable to find the field where that can be displayed.
  
  **Tags:** civicase, drupal-views, roles
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-10-01. Score: 6 | Accepted answer
  
  Actually you'll need to start with a CiviCRM Relationships View.
  
  If you start with a view of CiviCRM Cases, you may get bad data if they have multiple open case types with different case managers.
  
  So create a new view of CiviCRM Relationships, then in the advanced section add the Case ID relationship, then add the Contact A (the client) relationship and finally the Contact B (the case manager) relationship.
  
  [![enter image description here](https://i.sstatic.net/OYFFD.png)](https://i.sstatic.net/OYFFD.png)
  
  Add a Display Name field using relationship Contact A, then add another Display Name field using Contact B.
  
  Here are all of the fields I eventually added:
  
  [![enter image description here](https://i.sstatic.net/y2S6q.png)](https://i.sstatic.net/y2S6q.png)
  
  > **Comments:**
  > **username_0**: This is very thorough response. Thank you very much!  
  > **username_2**: I +1'ed this answer, but I wonder if there could/should be the ability to start from cases and then pull in the the Roles. My scenario is for a Union dealing with Cases involving the Employer, but some part-timers have multiple employers, so I am adding the Employer as an 'Other Party' role. And of course one person may have multiple cases open so in Views we want to show summary of each Case, Status and which of their Employers it involved with links to webforms to then trigger an 'update' action  
  > **username_1**: I think there "should " be Pete but I don't think there is. I've tried multiple times to start from something other than a relationship view and it has always caused incorrect data to be displayed. Case roles seem to not be ironed out totally. They are challenging to say the least.  
  > **username_3**: I don't know what version username_1 used but I repeated this in Drupal 9.  
  > **username_4**: I have had exactly the same issue starting from Cases - I just could not pull it all in.  My Use Case was for a view that filtered by logged in User as the Case Manager, so I used a Contextual Filter.  The only way I could get it to work was to start with the Relationships view.  No idea why...!  
  
  ---
  
  