I would like to build a drupal view that shows information from a case including who holds each of the case roles. For example the view would show
Case Id: 1234
Case Status: Scheluled
Role 1 contact: Bob
Role 2 contact: Mary
Role 3 contact: School
Case Client: James
How would I go about doing this?