3

A site I'm working on has recently been upgraded to version 4.6.32. Since this upgrade the client is no longer able to see data from some of the custom fields in the Activity Report.

Custom fields of type 'text' display fine, but fields of type 'select' are blank even though there is data stored in this field.

The site is running CiviCRM 4.6.32 on Drupal 7.

Improve this question
4
  • The patch noted below did not work for my issue. I'm still digging around to find the culprit, as mentioned it only check box, radio displays without issue.
    – Keith Webb
    Nov 21, 2017 at 15:22
  • Thanks for the update Keith. Let us know what you discover.
    – William Mortada
    Nov 21, 2017 at 16:08
  • The patch didn't work for me. The if statement in the patch is never true because $value always contains a square character at either end. And they don't exist in $cf_values['value'] (at least not for my data).
    – Michael Chaplin
    Feb 28, 2018 at 16:02
  • Just updated to 4.6.36 and the bug has been resolved! Thank you
    – Keith Webb
    Mar 18, 2018 at 12:07

3 Answers 3

Reset to default
2

This appears to be a regression in CiviCRM 4.6.32. (It doesn't appear to affect CiviCRM 4.7.28.)

I have recreated this on the sandbox site.

I have raised this as a bug in the CiviCRM issue queue:

Custom fields of type select not displaying in Activity Report

UPDATE

It was subsequently raised as a bug by Martin Castle:

Custom data fails to pull through to reports

And a fix has been released by VangelisP:

Resolves regression issue with non-dynamic custom fields

This will hopefully be included in a future release of CiviCRM 4.6

Improve this answer
1
  • I see the same issue after upgrading Drupal installation to 4.6.32, just installed 4.6.33 and the issue remains. I have two custom fields in the same report, the radio type appears normally but the check box type does not show the field value that is stored in the database.
    – Keith Webb
    Nov 3, 2017 at 1:23
1

Just updated to 4.6.36 and the bug has been resolved! Thank you

Improve this answer
0

Did you check the in_selector column in the civicrm_custom_field table? I seem to recollect I had to set those to 1 but I am not sure...

Improve this answer
1
  • Thanks Eric, I don't actually have access to the database for this site but I've managed to recreate the issue on the sandbox site so I don't think it is about any specific database settings.
    – William Mortada
    Oct 20, 2017 at 12:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.