Multifield Contributed Module - https://www.drupal.org/project/multifield

Company Content Type has multifield

1) Company Division - Entity reference
2) Company Categroy - list

While adding relationship as entity reference node company division in views an error is thrown.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_fieldname_node.id' in 'on clause'

1 Answer 1


It looks like your issue is because of the Multifield issue Add Views API integration for the multifield field type. And that the patch attached to comment nr 96 of this issue solves it.

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.