I'm trying to build a drupal view and pull in rm custom data For both contact (client) and case (view for case contact, relationships include case contact id-case id, and case contact id- contact id)

From add fields- all the data sets I need are visible

After selecting fields and clicking add, I'm taken back to the views edit screen without the option to edit the field label etc. And the field does not appear in the field list.

This is not consistent... for example from data set "x" fields, a, b c, d and e are all available to choose. Fields b and d, can be added to the view. Fields a,c and e fail to materialise.

Anyone seen anything like this? Anything else I should be looking at?

(Drupal 7.60, civi 5.3.1)

settings.php file has been updated

The views cache, drupal cache and civicrm cache have been cleared several times

One of the custom field sets in question Custom Field Set

Selecting fields to include in view views interface

Only 2 fields out of 7 end up in views table (end columns) Other Details and Project

table headers

  • 1
    Are you sure settings.php is up to date? If so, try clearing Views cache, which is on Settings/Advanced in Views.
    – Andy Clark
    Nov 9, 2018 at 12:47
  • Updated settings.php Civi, drupal and views cache cleared multiple times Still no dice Nov 9, 2018 at 14:48
  • Check the custom field is searchable? Nov 9, 2018 at 21:21
  • @TonyHorrocks fields are set as searchable- see screengrabs added to post Nov 12, 2018 at 11:18
  • happy to look over your shoulder on a screenshare (skype peter.davis59 / hangout [email protected] etc) if you think it might help. seems a bit mysterious
    – petednz - fuzion
    Nov 12, 2018 at 19:12

2 Answers 2


It sounds like it is missing from your Drupal settings.php file. Here's where you get the information to add to it:


That will give you all the information that needs to be added. Each time you add custom fields/profiles to CiviCRM, it is a good idea to update that listing in your settings.php file.

  • 1
    Thanks Jenni, I had already done that. I've editted original post to make that more explicit. Nov 9, 2018 at 17:10
  • Would you be able to give us a screenshot of the list of fields from the custom fields page? Maybe there is something specific about those fields that is causing it since you're getting access to some, but not all. Nov 9, 2018 at 17:50
  • Hi Jenni, I've updated the ticket with screen grabs. Please let me know if you need more info Nov 12, 2018 at 11:20
  • Hmmm. Is there content in all those fields? Maybe you've got them set to hide if empty? If not, I think we've all mentioned about all the troubleshooting I can think of... Nov 12, 2018 at 17:15
  • Thanks Jenni, I don't even get the dialog box to set the hide if empty options. Thanks for looking. Nov 13, 2018 at 10:26

Updated Civi to latest version.

Updated views related modules in Drupal to latest versions.

Rebuilt view.

Original view was based on case contact id, and pulled in case details and case contact details.

Rebuilt as a case view, and then added single relationship to Case Contact.

So either 1) upgrading modules or 2) not building complicated queries in views in the first place


Massive thanks to Pete from Fuzion for help and support.

And to everyone else who chipped in

Your Answer

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

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