In current (2.8) dev.
How to reproduce:
* Add field Workflow history: State name (if that matters: on a relation)
On view preview we get an error of:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'workflow_node_history.entity_type' in 'on clause'
Analysis
This join shows
LEFT JOIN {workflow_node_history} node_field_data_field_opencsa_delivery__workflow_node_history ON node_field_data_field_opencsa_delivery.nid = node_field_data_field_opencsa_delivery__workflow_node_history.nid AND workflow_node_history.entity_type = 'node'
that workflow_node_history is used when the alias node_field_data_field_opencsa_delivery__workflow_node_history should have been.
Comments
Comment #2
johnvComment #3
johnvPerhaps it is fixed here: #2074859: Views displaying wrong data when using references/revisions/multiple fields