Answers.Body: <p>I spent some time on the setup of the Views and it does actually work. However, what is missing is the relationship in the View. It is subject to the type of view you try to create and the relationships. Also remember to choose the CiviCRM Custom: [Field_name] instead of the one provided by CiviCRM Entities. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-12T00:10:48.267Z
Answers.LastActivityDate: 2017-01-12T00:10:48.267Z
Answers.UserDisplayName: Sohal Khatwani
Body: <p>I have correctly setup views to work for civicrm fields and am also using the civicrm entity module for Drupal to expose fields. In my testing it seems like the custom fields work for certain types of civicrm components. For example, if i use a custom field for All Contact Types then it works correctly and even the dropdown shows CiviCRM:Custom - Field name. However, for a custom field for Cases it does not work and has the same issue i.e. refers to SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_case.custom_3' in 'field list'. Has anyone had any success in using custom civicrm case fields in Drupal views? </p>
  
Tags: <civicase><drupal-views>
Title: Custom Case Fields do not work in Drupal Views
ThreadText: # Custom Case Fields do not work in Drupal Views
  
  (Asked by: username_0 on 2017-01-09)
  
  I have correctly setup views to work for civicrm fields and am also using the civicrm entity module for Drupal to expose fields. In my testing it seems like the custom fields work for certain types of civicrm components. For example, if i use a custom field for All Contact Types then it works correctly and even the dropdown shows CiviCRM:Custom - Field name. However, for a custom field for Cases it does not work and has the same issue i.e. refers to SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm\_case.custom\_3' in 'field list'. Has anyone had any success in using custom civicrm case fields in Drupal views?
  
  **Tags:** civicase, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-01-12. Score: 1
  
  I spent some time on the setup of the Views and it does actually work. However, what is missing is the relationship in the View. It is subject to the type of view you try to create and the relationships. Also remember to choose the CiviCRM Custom: [Field\_name] instead of the one provided by CiviCRM Entities.
  
  
  ---
  
  