Missing nodes in workflow_node table

japanitrat - September 14, 2009 - 05:34
Project:Workflow
Version:6.x-1.1
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

Hi there,

I got a slight problem with Views when I try to filter by Workflow state. I assigned a content workflow to some node types 3 months ago (so most probably with an older version of the Workflow module) and I configured a View2 for it which shows only nodes with a certain workflow state (actually I am excluding a state).

The thing is, some old nodes (about 300 nodes) do not show up, so I took a look at the database. It turned out that the workflow_node table does not contain rows for these nodes. Unfortunately, I can't search for these nodes, since the Views2 filter expects a row for each node having the workflow assigned to it (even if there is no state).

At this point I see only one solution: I need some kind of script which "fixes" the workflow_node table by inserting the missing nodes. Unfortunately, I have no idea how to do that.

Any suggestions?

 
 

Drupal is a registered trademark of Dries Buytaert.