In a view with nodes as base table, how do I get the date of the first transition to a certain state?

I would like to sort my nodes with the date they were first transitioned to "published" state and display this date as well in a field labeled "First published on:"

Comments

shadysamir’s picture

shadysamir commented
Issue summary: View changes
shadysamir’s picture

shadysamir commented
Title: Get date of first transition to a state » Get date of first transition to a state in Views
johnv’s picture

johnv
Primary language Dutch
commented
Status: Active » Closed (works as designed)
Related issues: +#2400211: Add Views support for non-node entity types

I don't think this is possible without programming some custom code.

Please check out lated dev-version, file workflow_views.views.inc, function workflow_views_views_data_alter(&$data).
Then, you can copy code from $data['workflow_node_current'] .

johnv’s picture

johnv
Primary language Dutch
commented
Category: Support request » Feature request
Status: Closed (works as designed) » Closed (duplicate)

See #2405077: Views Filter:Workflow Current only pulls data from latest transition, not first, for follow-up.