Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-19637

Showing Custom data options in report criteria problem - Part #2

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.21
    • Fix Version/s: 4.6.32
    • Component/s: CiviReport
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      Hi

      I've fallen on issue https://issues.civicrm.org/jira/browse/CRM-15695 .

      However, I think it's still obsolete. Calling a report with a CustomField as type 'Select' which has dynamic data inside, does not render it at all (renders empty), even though the value is properly stored inside the DB. Basically, query returns the results but CRM/Report/Form is unable to translate this into a label, thus returning null.

      The problem exists in CRM/Report/Form.php on line 2061. I have added this:
      ===========================================
      else

      { $customField['options'] = CRM_Core_BAO_CustomOption::getCustomOption($customField['id']); $retValue = $customField['options'][$value]['label']; break; }

      ===========================================
      I am not quite sure if this is the proper way to deal with it but it looks like it's working ok.

      Steps to replicate/reproduce:

      1) Create a new customfield as alphanumeric select and do not create optionvalues (leave it empty)
      2) Using the function myextension_civicrm_customFieldOptions($fieldID, &$options, $detailedFormat = false) populate the customfield values.
      In my example I wanted to populate it with Campaigns.

      3) Store some values inside
      4) Call a report that this customfield is assigned and display it.
      It will display empty.

      I am attaching a patch for 4.6.21 version.

      PS. Did not want to raise that ticket again (leaving this option to you actually).

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              VangelisP Vangelis Pantazis
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: