Tags used for Cases, Activities or Attachments in Drupal Views?

Question

We are trying to achieve a hierarchical approach to some of our case types by using case tags.

It works great on the back-end, but if I try to filter a view by the case tag, I get no results.

In the View UI, I add a filter of CiviCRM tags, see the case tags in the list, but if I select any of them, I get no results.

I've tried with tags attached to contacts, cases, attachments and activities. The only one that appears to work is when the tag is attached to a contact.

Since Smart Groups don't appear to function correctly in Views either, this functionality would be very useful.

Tables look good, view appears to be set up correctly. Tags is available as a field and I can see the correct Case Tags in the list of available tags.

I brought this issue up before, but have no resolution yet.

Here is a link to the old issue: Case Tags in View

Answer 1

On a development server, I edited sites/all/modules/civicrm/drupal/modules/views/components/civicrm.core.inc.

In the Tag section, I added:

$data['civicrm_tag']['table']['join']['civicrm_case'] = array(
    'left_table' => 'civicrm_entity_tag',
    'left_field' => 'tag_id',
    'field' => 'id',
  );

and

 $data['civicrm_entity_tag']['table']['join']['civicrm_case'] = array(
    // Directly links to tag table
    'left_field' => 'id',
    'field' => 'entity_id',
    'extra' => array(
      array(
        'field' => 'entity_table',
        'value' => 'civicrm_case',
        'numeric' => FALSE,
      ),
    ),
  );

After that, I was able to filter by case tags.

Would this have any unforeseen ramifications? Does this cover all of my bases?

Would this be best put into a separate custom module?