1

I'm trying to use the Drupal module civicrm entity in views to render a custom field (Image) I created in contacts in civicrm 4.7.13, I did the views integration through settings.php and in views when I add the field provided by CIVICRM Entity I get the error:

Column not found: 1054 Unknown column 'civicrm_contact.custom_4' in 'field list'

The field provided as "Custom Data Field" in views works but it only displays a link to the uploaded image and I need it as an entity to apply image styles on it, etc..

Improve this question
1
  • As of CiviCRM Entity Beta 8, CiviCRM Entity no longer exposes the custom fields to views. You should use the handlers that come with the stock CiviCRM module.
    – jackrabbithanna
    Jun 3, 2017 at 17:48

1 Answer 1

Reset to default
1

If you have the link to the image file in the view then I would try rewriting the results of that field. Set it up as an <img src=[token that has path to image] />.

Then you can add a class to it and style it as you wish.

Improve this answer
2
  • Hi. I have a similar problem i.e. I am using a single civicrm and drupal database for an older site and any custom data is not showing in the views. We have added a few custom fields in cases which we want to expose as views but the custom fields don't show up. I get the error. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_case.custom_27' in 'field list'. How can I resolve this?
    – Sohal Khatwani
    Dec 8, 2016 at 7:01
  • As of CiviCRM Entity Beta 8, CiviCRM Entity no longer exposes the custom fields to views. You should use the handlers that come with the stock CiviCRM module.
    – jackrabbithanna
    Jun 3, 2017 at 17:49

Your Answer

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

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