Answers.Body: <p>Updated Civi to latest version.</p>
  
  <p>Updated views related modules in Drupal to latest versions.</p>
  
  <p>Rebuilt view.</p>
  
  <p>Original view was based on case contact id, and pulled in case details and case contact details.</p>
  
  <p>Rebuilt as a case view, and then added single relationship to Case Contact.</p>
  
  <p>So either
  1) upgrading modules
  or
  2) not building complicated queries in views in the first place</p>
  
  <p>Worked.</p>
  
  <p>Massive thanks to Pete from Fuzion for help and support.</p>
  
  <p>And to everyone  else who chipped in</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-21T13:30:07.340Z
Answers.LastActivityDate: 2018-12-21T21:36:41.437Z
Answers.LastEditDate: 2018-12-21T21:36:41.437Z
Answers.UserDisplayName: Craig Almond
Answers.Body: <p>It sounds like it is missing from your Drupal settings.php file. Here's where you get the information to add to it:</p>
  
  <p><a href="https://www.yourdomain.com/civicrm/admin/setting/uf?reset=1" rel="nofollow noreferrer">https://www.yourdomain.com/civicrm/admin/setting/uf?reset=1</a></p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-09T17:10:19.827Z
Answers.Text: Thanks Jenni, I had already done that. I've editted original post to make that more explicit.
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-09T17:50:07.910Z
Answers.Text: 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.
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-12T11:20:15.293Z
Answers.Text: Hi Jenni, I've updated the ticket with screen grabs.
  
  Please let me know if you need more info
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-12T17:15:36.407Z
Answers.Text: 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...
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-13T10:26:28.083Z
Answers.Text: Thanks Jenni, I don't even get the dialog box to set  the hide if empty options. Thanks for looking.
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-13T12:06:01.173Z
Answers.Text: Ah, it's inside Views when you click on the fields you're using. There's a list of options, including one that allows you to tell it what to do if it's empty.
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-25T09:44:30.607Z
Answers.Text: I don't know if this relates, but you can see https://civicrm.stackexchange.com/questions/27466/how-to-display-individual-custom-fields-in-a-participants-view for more explanations (not solutions)
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-09T13:56:27.833Z
Answers.LastActivityDate: 2018-11-09T13:56:27.833Z
Answers.UserDisplayName: Jenni Simonis
Body: <p>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)</p>
  
  <p>From add fields- all the data sets I need are visible</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Anyone seen anything like this? Anything else I should be looking at? </p>
  
  <p>(Drupal 7.60, civi 5.3.1)</p>
  
  <p>settings.php file has been updated</p>
  
  <p>The views cache, drupal cache and civicrm cache have been cleared several times</p>
  
  <p>One of the custom field sets in question
  <a href="https://i.sstatic.net/txSvu.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/txSvu.png" alt="Custom Field Set"></a></p>
  
  <p>Selecting fields to include in view
  <a href="https://i.sstatic.net/2wqdK.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/2wqdK.png" alt="views interface"></a></p>
  
  <p>Only 2 fields out of 7 end up in views table (end columns)
  Other Details and Project</p>
  
  <p><a href="https://i.sstatic.net/vmP9M.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vmP9M.png" alt="table headers"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-09T12:47:12.577Z
Comments.Text: Are you sure settings.php is up to date? If so, try clearing Views cache, which is on Settings/Advanced in Views.
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-09T14:48:53.907Z
Comments.Text: Updated settings.php
  
  Civi, drupal and views cache cleared multiple times
  
  Still no dice
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-09T21:21:04.460Z
Comments.Text: Check the custom field is searchable?
Comments.UserDisplayName: Tony Horrocks
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-12T11:18:17.307Z
Comments.Text: @TonyHorrocks fields are set as searchable- see screengrabs added to post
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-12T19:12:29.343Z
Comments.Text: 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
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-13T10:30:35.320Z
Comments.Text: @petednz-fuzion If you're free to do that it would be a great help. When would be the best time for you? I'm happy to log in late evening (9-10pm uk) if that's easiest?
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-13T18:23:25.353Z
Comments.Text: anytime in next 12 or so hours
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-14T12:17:41.667Z
Comments.Text: Sorry. Didn't log back in last night to check.  
  
  I'm unavailable this evening (tomorrow morning for you?)
  
  If I tried to reach you on Friday Morning (your time) would that be ok?
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-20T21:09:41.107Z
Comments.Text: And none of the fields are inadvertently set to 'exclude from display' in the field set up of the view?
Comments.UserDisplayName: RayWright
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-12T19:44:49.477Z
Comments.Text: craig did you get a resolution - can you add your own answer perhaps so this question doesn't have zero accepted answers
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-19T15:58:08.287Z
Comments.Text: I've not got anywhere near to fixing this.
  
  I've asked a colleague to update drupal views related modules all to latest and then I'm going to try and re-build the view from scratch, but struggling to find time to do this at the moment.
Comments.UserDisplayName: Craig Almond
Tags: <custom-fields><drupal-views>
Title: custom fields not adding to Drupal views
ThreadText: # custom fields not adding to Drupal views
  
  (Asked by: username_0 on 2018-11-09)
  
  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](https://i.sstatic.net/txSvu.png)](https://i.sstatic.net/txSvu.png)
  
  Selecting fields to include in view
  [![views interface](https://i.sstatic.net/2wqdK.png)](https://i.sstatic.net/2wqdK.png)
  
  Only 2 fields out of 7 end up in views table (end columns)
  Other Details and Project
  
  [![table headers](https://i.sstatic.net/vmP9M.png)](https://i.sstatic.net/vmP9M.png)
  
  **Tags:** custom-fields, drupal-views
  
  > **Comments:**
  > **username_1**: Are you sure settings.php is up to date? If so, try clearing Views cache, which is on Settings/Advanced in Views.  
  > **username_0**: Updated settings.php  Civi, drupal and views cache cleared multiple times  Still no dice  
  > **username_2**: Check the custom field is searchable?  
  > **username_0**: @TonyHorrocks fields are set as searchable- see screengrabs added to post  
  > **username_3**: 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  
  > **username_0**: @petednz-fuzion If you're free to do that it would be a great help. When would be the best time for you? I'm happy to log in late evening (9-10pm uk) if that's easiest?  
  > **username_3**: anytime in next 12 or so hours  
  > **username_0**: Sorry. Didn't log back in last night to check.    I'm unavailable this evening (tomorrow morning for you?)  If I tried to reach you on Friday Morning (your time) would that be ok?  
  > **username_4**: And none of the fields are inadvertently set to 'exclude from display' in the field set up of the view?  
  > **username_3**: craig did you get a resolution - can you add your own answer perhaps so this question doesn't have zero accepted answers  
  > **username_0**: I've not got anywhere near to fixing this.  I've asked a colleague to update drupal views related modules all to latest and then I'm going to try and re-build the view from scratch, but struggling to find time to do this at the moment.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2018-12-21. Score: 1 | Accepted answer
  
  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
  
  
  ---
  
  ### Answer by username_5 on 2018-11-09. Score: 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.
  
  > **Comments:**
  > **username_0**: Thanks Jenni, I had already done that. I've editted original post to make that more explicit.  
  > **username_5**: 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.  
  > **username_0**: Hi Jenni, I've updated the ticket with screen grabs.  Please let me know if you need more info  
  > **username_5**: 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...  
  > **username_0**: Thanks Jenni, I don't even get the dialog box to set  the hide if empty options. Thanks for looking.  
  > **username_5**: Ah, it's inside Views when you click on the fields you're using. There's a list of options, including one that allows you to tell it what to do if it's empty.  
  > **username_6**: I don't know if this relates, but you can see https://civicrm.stackexchange.com/questions/27466/how-to-display-individual-custom-fields-in-a-participants-view for more explanations (not solutions)  
  
  ---
  
  