I'm using CiviCRM 4.6.9, if it makes a difference.
I want to use Drupal Views to display only CiviCase cases that do not have case managers.
I feel as though I'm close... so close, but I'm not quite there yet. This is what I have set up.
I have a view that displays cases in a table format. I've add a subject field and a contact field to the view. I then added CiviCRM Case Contact: Case Contact's ID as a relationship, and to that I've added CiviCRM Contacts: CiviCRM Relationship (starting from contact A) which is set to use only the case manager relationship type, but is not required.
For filters, I've added (CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Case ID (empty).
This almost works as I want it to. However, if a single client has multiple cases, and any one of those cases is assigned a case manager, none of their other cases will show up. I think this happens because the relationship is fetched via the clients ID number and not via the case ID, though as far as I can see, there are no views relationships that will allow me to fetch a case relationship via the case ID.
I can supply more information if needed.
Any help is greatly appreciated.