CiviCRM Community Forums (archive)

Looking at the sample module and the various functions I couldn't figure out a function that would retrieve the data out of custom data fields but there must be something I'm missing!

The best way I could come up with to return all the values in the (only) (multiple) customField belonging to customGroup 18 was this.


  $tableName = CRM_Core_DAO::getFieldValue( 'CRM_Core_DAO_CustomGroup',  18,'table_name' );
  $fieldName = CRM_Core_DAO::getFieldValue( 'CRM_Core_DAO_CustomField',  18,'column_name','custom_group_id' );
   
    $sql = "
SELECT *
FROM $tableName
WHERE  entity_id = $fields[current_employer]
"; 
   

  $dao = CRM_Core_DAO::executeQuery( $sql,CRM_Core_DAO::$_nullArray );
     while ( $dao->fetch( ) ) {
                $emaildomains[] = $dao->$fieldName;
            }