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

geek-merlin
Primary language German
Location Freiburg, Germany
commented
Issue summary: View changes
johnv’s picture

johnv
Primary language Dutch
commented
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

geek-merlin
Primary language German
Location Freiburg, Germany
commented

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

johnv
Primary language Dutch
commented
Title: Views field broken with relation: Workflow current: State name » SQL error: Views field broken with relation: Workflow current: State name
semiaddict’s picture

semiaddict commented

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

jtjones23 commented

+1 As far as hearing about the workaround

Thanks

geek-merlin’s picture

geek-merlin
Primary language German
Location Freiburg, Germany
commented

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

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.