CiviCRM Community Forums (archive)

I have built a view which works fine.  I can view it no problem, getting a list of contacts and their addresses just fine

I then added contact->tags to the view and get this error message

Column not found: Unknown column 'civicrm_contact.tag' in 'field list'I am using Drupal 7.9 and Civicrm 4.0.7

When I add Tags->tag it adds one tag just fine. But the whole address then repeats for every diff tag - not what I want.

I looked through civicrm.views.inc and I can't see anywhere obvious to fix it. Nothing in the bugs list either.

Anyone with any suggestions?
Thanks

Amazingly sweet workaround:

Prep a view block containing the data you want, then use:

<?php      
$block = module_invoke('views', 'block_view', 'primary_member_block-block');
print render($block);
?>

In your template. This is actually easier than working with $row and $field in the tpls, dont know about performance though.

Just looking at the views code, I fail to see how Tag(s) ever worked (as well as Note(s) and Group(s)).

All three of these are being exported in CRM/Contact/BAO/Contact.php by the static method exportableFields().

The 'fix' right now would be to exclude these fields from being added to views, and this should be done by either:

1. fixing the exportableFields() method from exporting tags, notes and groups OR
2. adding tags, groups and notes to the 'skipfields' array in line ~562 of drupal/modules/views/components/civicrm.core.inc

Can a core Civicrm developer please indicate which of these to do (I don't understand what else exportableFields() is being used for) and then I can work up a patch.

Did this ever get fixed? I ran into the same problem today. Is it just currently impossible to show contact tags in a Drupal view? How hard would it be to add this functionality?