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

  • 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 '18 at 12:47
  • Updated settings.php Civi, drupal and views cache cleared multiple times Still no dice – Craig Almond Nov 9 '18 at 14:48
  • Check the custom field is searchable? – Tony Horrocks Nov 9 '18 at 21:21
  • @TonyHorrocks fields are set as searchable- see screengrabs added to post – Craig Almond Nov 12 '18 at 11:18
  • happy to look over your shoulder on a screenshare (skype peter.davis59 / hangout peter.davis@fuzion.co.nz etc) if you think it might help. seems a bit mysterious – petednz - fuzion Nov 12 '18 at 19:12
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.

  • 1
    Thanks Jenni, I had already done that. I've editted original post to make that more explicit. – Craig Almond Nov 9 '18 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 Nov 9 '18 at 17:50
  • Hi Jenni, I've updated the ticket with screen grabs. Please let me know if you need more info – Craig Almond Nov 12 '18 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 Nov 12 '18 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 Nov 13 '18 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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