CiviCRM Community Forums (archive)

Think that's a good idea.

Without me hacking the CiviCRM code to the extent that we pull the project out of any chance of future upgrades, are their any suggestions on how this can be achieved?

Financial contributions are a good way of increasing the odds of a feature to get implemented. Could you go down that road ?

If code changes are the only option, I think I'll need a few pointers to making the necessary modifications.

The easiest might be to develop a custom search, copy/reuse most of the interface and function from the participants' search and add a inner join on the tag table.

X+

In my custom template at CRM/Event/Form/Selector.tpl I have inserted a row into the table;
    <td>{$row.tags}</td>

Now I've found CRM/Event/Selector/Search.php and in my custom copy I have added;

into the function &getColumnHeaders
array(
    'name'      => ts('Tags'),
    'sort'      => 'tags',
    'direction' => CRM_Utils_Sort::DONTCARE,
),

into the function &getRows at line 326
$row['tags'] = 'test' ;

And the result is a display of a column with the header 'Tags' and each cell containing 'test'. Woohoo  

The next part is trying to find how to get the tag data. What function in what file?  

Part of this is that they want a column in the search results form where they can sort by Tags.

So, from my previous post, is there any help that can be provided by indicating where I can get the tag data? What function in what file?

Well, I now have the correct Tag names displayed in a column in the search results, via a bit of editing of the custom copies of;

CRM/Event/Form/Selector.tpl
and
CRM/Event/Selector/Search.php

What I'm wrestling with now is how to make the Search results able to be sorted via the Tags column header.

After many hours of searching and attempting to make sense of the vast cobweb of code which is CiviCRM, I finally ended up with something which is probably a bit of a brutish approach, but it works. I created some custom files (PHP and Templates) which are slightly modified from the originals.


custom/templates/CRM/Event/Form/Selector.tpl
Line 40: insert <!--Line 52: insert -->
    <td>{$row.tags}</td>

custom/PHP/CRM/Event/Selector/Search.php
Line 88: append , 'tags'Line 291: insert require_once 'CRM/Core/PseudoConstant.php';Line 294: insert $tagNames =& CRM_Core_PseudoConstant::tag( );Line 297: insert $names = array() ;Line 328: insert require_once 'CRM/Core/BAO/Tag.php';
require_once 'CRM/Core/BAO/EntityTag.php';
$tagIDs = CRM_Core_BAO_EntityTag::getTag($result->contact_id);
foreach ( $tagIDs as $id => $dontCare ) {
    if (array_key_exists($id, $tagNames)) {
         $names[] = $tagNames[$id];
     }
}
$row['tags'] = implode(', ', $names);Comment out Lines 392-396
Line 399: insert array(
    'name'      => ts('Tags'),
    'sort'      => 'tags',
    'direction' => CRM_Utils_Sort::DONTCARE,
    ),

custom/PHP/CRM/Contact/BAO/Query.php
Line 622: insert if (!array_key_exists('tags', $this->_select)) {
    $this->_useGroupBy  = true;
    $this->_select['tags'              ] = "GROUP_CONCAT(DISTINCT(civicrm_tag.name)) AS tags";
    $this->_element['tags'             ] = 1;
    $this->_tables['civicrm_tag'       ] = 1;
    $this->_tables['civicrm_entity_tag'] = 1;
}
If there is a more elegant/refined approach (something more specific to the requirement) I'd like to know.

If this seems like a hack which people would like to see added to the general repository, then I'll come up with some diff files.

hmm, i dont think we should add it to core, a few reasons:

1. Query should return only what its asked for. If tags has not been requested it should not be returned

2. GROUP_CONCAT has a limitation with regard to how many tags / length. We prefer not using it (we've been bitten a few times using that).

lobo

After thinking about it over the weekend and reading your comments, I have been able to reduce the changes to custom/PHP/CRM/Event/Selector/Search.php as follows;

Line 88: append , 'tags'
Line 325: insert $row['tags'] = $result->tags ;
Comment out Lines 381-385

Line 386: insert array(
    'name'      => ts('Tags'),
    'sort'      => 'tags',
    'direction' => CRM_Utils_Sort::DONTCARE,
    ),
This is due to selecting the Tags in the Query.php

The other two files remain as per my previous post.