Missing nodes in workflow_node table
| Project: | Workflow |
| Version: | 6.x-1.1 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
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?
