CiviCRM Community Forums (archive)

Check Profile if you want it to be used as the default search and listings screens for the civicrm/profile path.

This refers to Profile forms and listings - not the built-in "Find Contacts" and "Advanced Search" screens.

You can modify the Advanced Search results columns by marking a Profile as "Used For" => "Search Results" and then selectin g that profile in the Advanced Search form.

Changing the display columns on CiviMember and CiviEvent pages is probably non-trivial unless the data you want is already being "delivered" to the page templates. You can enable Debugging and then add &smartyDebug=1 to see what data is available in each row.

This would involve considerable amount of changes to Membership search.
You will have to modify following files:
CRM/Member/Selector/Search.php
templates/CRM/Member/Form/Selector.tpl

Ping us on #civicrm if you get stuck.

Kurund

can u add custom_2 to the properties array in:

CRM/Member/BAO/Query.php, function defaultReturnProperties( ) (line 289 or so)

is custom_2 a custom field of type Membership or Contact/Individual?

lobo

in that case, u'll need to start digging a bit through the code and figure out what needs to change for the query to return custom_2

ping me on irc later this week and i can help out (a bit busy first part of the week with the 2.2 deadline)

lobo

GOT IT PEOPLE. This is excellent. So the whole process is as follows:

- As Kurund mentioned, I needed to modify these files:
CRM/Member/Selector/Search.php
templates/CRM/Member/Form/Selector.tpl

and add my 'custom_2' to the $properties array, $columnHeaders and the tpl file row (see my above post on how I did all that)

- As Lobo mentioned, I needed to modify CRM/Member/BAO/Query.php, function defaultReturnProperties( ) to include my custom_2 field

Then, in fact it is returning what I needed. But since it's a multi-select field, the display formatting was all funky and I needed to use CRM/Core/BAO/CustomField.php
function getDisplayValue

to properly format it. This function looks like this (just including it to show the parameters it needs):
  /**
     * Given a custom field value, its id and the set of options
     * find the display value for this field
     *
     * @param mixed  $value     the custom field value
     * @param int    $id        the custom field id
     * @param int    $options   the assoc array of option name/value pairs
     *
     * @return  string   the display value
     *
     * @static
     * @access public
     */
    static function getDisplayValue( $value, $id, &$options, $contactID = null )
So then I was trying to call this function on my field directly from CRM/Member/BAO/Query.php but couldn't get the third parameter to work. Lobo directed me back to CRM/Member/Selector/Search.php and told me that the query object I needed was available in the getRows function (would have been stuck for hours without this pointer). Once in there, it was very easy to access what I needed as Lobo had also previously mentioned to me that query objects are usually supposed to have _options associated with it. So I simply added the following line (any $row modification just needs to be within the while loop around line 326):

             $row['custom_2'] = CRM_Core_BAO_CustomField::getDisplayValue($row['custom_2'], 2, $this->_query->_options);

Voila! Beautiful displaying custom fields on my membership dashboard. This is VERY exciting! hopefully it will help someone else. Thanks so much Kurund and Lobo for all the help.

there is an error in your sql clause. firebug is your friend to detect such errrors. A valid version of the clause is:

$sql = "SELECT members_town_2
FROM civicrm_value_member_town_1 mt
LEFT JOIN civicrm_membership m ON (m.id = mt.entity_id)
WHERE m.contact_id = {$dao->contact_id}";


two more questions and i think this will be solved. first -- lobo i don't see where in firebug this would come up. there are no errors in the error console related to this file. am i looking in the wrong place?

second, yes, that query change resolved and now i'm getting my results, which brings me back to the need to format it. I am again having trouble with the third $options parameter CRM_Core_BAO_CustomField::getDisplayValue. How do I set options on my custom query? I don't understand exactly how this works or what it does. Is it built in somehow? Ideally my final code would look like this except the result is not formatting correctly:
$sql = "SELECT members_town_2
FROM civicrm_value_member_town_1 mt
LEFT JOIN civicrm_membership m ON (m.id = mt.entity_id)
WHERE m.contact_id = '{$dao->contact_id}'";
       
        $dao_cus = CRM_Core_DAO::executeQuery( $sql,
                                           CRM_Core_DAO::$_nullArray );
       
        while ( $dao_cus->fetch( ) ){     
          $membership[$dao->id]['custom_2'] =  CRM_Core_BAO_CustomField::getDisplayValue($dao_cus->members_town_2, 2, $dao_cus->_options);
        }
peterd - posting a screenshot of my membership dashboard. yes, it's working as you suggest.