4

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

Improve this question
11
  • 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
    Commented Nov 9, 2018 at 12:47
  • Updated settings.php Civi, drupal and views cache cleared multiple times Still no dice
    – Craig Almond
    Commented Nov 9, 2018 at 14:48
  • Check the custom field is searchable?
    – Tony Horrocks
    Commented Nov 9, 2018 at 21:21
  • @TonyHorrocks fields are set as searchable- see screengrabs added to post
    – Craig Almond
    Commented 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 ♦
    Commented Nov 12, 2018 at 19:12

2 Answers 2

Reset to default
1

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

https://www.yourdomain.com/civicrm/admin/setting/uf?reset=1

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.

Improve this answer
7
  • 1
    Thanks Jenni, I had already done that. I've editted original post to make that more explicit.
    – Craig Almond
    Commented 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.
    – Jenni Simonis
    Commented 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
    – Craig Almond
    Commented 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...
    – Jenni Simonis
    Commented 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.
    – Craig Almond
    Commented Nov 13, 2018 at 10:26
1

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

Worked.

Massive thanks to Pete from Fuzion for help and support.

And to everyone else who chipped in

Improve this answer

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.