Adding "workflow: previous comment" to fields duplicates nodes in view results

I'm having the same problem with workflow 6.x-1.0 and views 6.x-2.2.
When I add Workflow: previous comment to the fields, I get an entry in the view for each different comment I entered, not just the most recent one. Does anyone know how to avoid this duplication?
This might have more to do with views than with anything else, but any help is appreciated.

changed title, because this pertains only to the comment fields.

I have the same issue. Any news on that? I am not using workflow owner, just views and workflow.

same as #5 - getting double results, even with distinct turned on, on the view.

Same here for workflow 6.x-1.1 and views 6.x.-2.5

I am having the same issue. When the field Previous Comments is used, there are duplicates because the node has been in that workflow with more more than one comment. Blanks are essentially a comment with no characters. What is REALLY needed is a field "Workstate Current Comment". I think this is essentially what all of us are looking for. This SHOULD get rid of the duplicates and it's not really a bug if the field is designed to list ALL of the previous comments.. Not just the comment previous to the current. I'm not sure when one would use it as a better field would be "All Previous Comments."

When listing all nodes of a certain workstate, it sure would be nice to list the comment associated with that workstate. At present, I don't think there is a way to do this.

If I am wrong here, please, someone let me know. I really need this functionality.

Thanks.

One work around I thought might work would be to add an argument "Current State", then use php to return the current state and therefore, only list the comment of the current state.. I have no idea how to do this with php.. Love help, or a new field :)

I'm having the exact same issue. Anybody know of a fix??

thx

As "distinct" modifier doesn't work for me in views, here is the quick workaround I used to get the most recent workflow comment:

- Install http://drupal.org/project/views_customfield module
- Create a php custom code view field for your view
- Insert the following code inside textearea:

echo db_result(db_query("SELECT comment FROM {workflow_node_history} WHERE nid=%d ORDER BY stamp DESC LIMIT 1", $data -> nid));

Thanks restyler -- that's perfect!
I adjusted your query a bit to get the immediately previosu workflow state:

<?php
echo db_result(db_query("SELECT ws.state FROM workflow_node_history wh, workflow_states ws
WHERE wh.old_sid = ws.sid and wh.nid=%d ORDER BY wh.stamp DESC LIMIT 1", $data -> nid));
?>

Like a charm. :)

While the above workarounds work for fields, I need to have a sort based on the now non-existent 'current time' field. I posted the beginnings of a fix for this issue at #426800: "Workflow: Previous time" views field results in duplicate nodes (D6), I'd appreciate any input.

I just posted a patch for this bug on #426800: "Workflow: Previous time" views field results in duplicate nodes (D6) - please post if it works for you.

Hi

i've the same trouble when i would to customize the basic workflow summary view...so when i add a field to display comments, nodes are duplicate...i would to know if someone have fixed this for the later version ?

thanks

IMO this is fixed. In 6.x-1.5, the "Workflow:current state/time/comment" is added. You can use "Workflow: previous:..." to create a history of your nodes.

See also #2147535: Add a "Last transition" views filter