In current (2.8) dev.

How to reproduce

* Using workflow_field, not workflow_node
* Add field Workflow current: State name on a relation(!)

Result: Erroneously empty field content.

Analysis

This SQL join

LEFT JOIN workflow_node_history node_field_data_field_opencsa_delivery_workflow_node_current ON ( SELECT max(hid) FROM workflow_node_history
                            where nid = node.nid
                            and   sid != old_sid ) = node_field_data_field_opencsa_delivery_workflow_node_current.hid

uses node.nid where something like relation_node.nid should have been.

Comments

axel.rutz created an issue. See original summary.

geek-merlin’s picture

Issue summary: View changes
johnv’s picture

Title: Views field broken with rleation: Workflow current: State name » Views field broken with relation: Workflow current: State name

Just to be sure. Did this work before? Or did you discover the error when teying out something new?

geek-merlin’s picture

Never saw this work before (it reasonably can not, see description ;-).
Walked a bit into the code, and i think this needs a join handler.
(I did it another way then, so not an issue for me anymore.)

johnv’s picture

Title: Views field broken with relation: Workflow current: State name » SQL error: Views field broken with relation: Workflow current: State name
semiaddict’s picture

axel.rutz, could you please tell us what work around you used ?
I am experiencing the same issue with 7.x-2.8 and would like to find a fix for it.
Thank you in advance.

jtjones23’s picture

+1 As far as hearing about the workaround

Thanks

geek-merlin’s picture

Afaicr i did my view completely different. Not possible for everyone is suppose.