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

axel.rutz created an issue. See original summary.

johnv’s picture

johnv
Primary language Dutch
commented
Title: SQL error: Unknown column 'workflow_node_history.entity_type' » SQL error: Unknown column 'workflow_node_history.entity_type' on a relation
johnv’s picture

johnv
Primary language Dutch
commented
Related issues: +#2074859: Views displaying wrong data when using references/revisions/multiple fields

Perhaps it is fixed here: #2074859: Views displaying wrong data when using references/revisions/multiple fields

johnv’s picture

johnv
Primary language Dutch
commented
Status: Active » Closed (outdated)

I guess this issue can be closed.

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.