Workflow / Views: Specific state date I need a column (field) in a view where you can see the date of a specific state (Workflow state). 

For example:
A content type news has three workflow states: new, reviewed, published. 
Now I need a view where you can see each news (also ones that haven't entered that state!) with a field where the date is shown when it was new, reviewed and published (sortable).
The Workflow module only provides "Previous time", but that's not specific to a state.

Any ideas? 

I know how to program a views handler for custom table/fields but my problem is that the node -> workflow_node_history has an 1:n relation.

drupal 6, workflow 1.5, views 2.x

Example:

Title   | Date new     | Date Reviewed | published
---------------------------------------------------
Title1  | 01.03.2012   | 13.03.2012    | pending
Title2  | 02.05.2012   | 16.05.2012    | 20.05.2012
Title3  | 20.05.2012   | pending       | pending
The Views PHP Module provides a custome field that is click sort enabled

Value code example:

....
$result = db_fetch_object(db_query("SELECT stamp FROM {workflow_node_history} WHERE nid = %d AND sid = %d", $row-&gt;nid, $sid));
if(isset($result-&gt;stamp)) {
   return $result-&gt;stamp;
}
return 0;


Output code:

&lt;?php 
print date('d.m.Y', $value);
?&gt;


Enable click sort: sort numerically