I want to create a drupal view that pulls in information from different activities stored on a CiviCase and information about the case and case client.
List of fields to include would be something like this:
Case ID
Case status
Case Client
Case Client Phone
Notes from phone call with client (from activity phone call)
Form received (from activity Approval sought)
Assignee of Approval sought activity
Teacher assigned (assignee of the class allocated activity)
Is it possible to do just from views and where would I start? Is the view based on case, contact or activity?