I have Views and am trying to get a list of all pending revisions.
I have added the filter "Current revision: State (= Pending)" and I do see the pending revision item in my system that has NEVER been published/approved. However, what I DO NOT see is any node that has a pending revision that has EVER been published in the past. In other words, if I create a node and it requires moderation and is not published, it shows up in the list. But, if I edit a current node, the pending revision that has not yet been published, does not show up in the list.
How do I get a list/result set of all nodes with a pending revision that has not yet been published but also has a currently published earlier revision?
Comments
Comment #1
rdeboerHmmm.... strange.
It should work exactly as you say....
Are you logged in as admin?
The alternative is to use the "Pending revisions" block (which is not a view). Try that and see how they compare.
Comment #2
rdeboerComment #3
highfellow commentedI seem to be having the same problem. I have made a view to show pending revisions, using an unformatted list of 'Content Revision: Title' fields. I am filtering on 'Content Revision: State = Pending'. It shows newly submitted content OK, but not new revisions of existing content. I've done my best to copy the view settings from #1309100: "Pending revisions" block requires a published current revision before it shows pending revisions.
I can't use the 'pending revisions' block, because I also want to filter on the value of a 'ready for publication' field I've added to the content types. I only want to show the items which are awaiting moderation and have this box ticked.
Comment #4
highfellow commentedSorry should probably have set the status to active.
Comment #5
highfellow commentedHere is an export of the view I am using:
Comment #6
highfellow commentedI've had a quick look at the code in the module; in particular views/revisioning_handler_filter_revision_state.inc . I can't see any obvious problems with the way the filter is defined, and I'm not sure where to go from here to debug this issue. I am willing to post debug information here, but could do with some help from someone who knows this module well.
Comment #7
rdeboerDuplicate of #2070819: Views 'Content revision: State' gives wrong results for Pending state.
There is now a canned View to produce a list of individual revisions, filtered by state (Archived, Pending, Current/Published).
You can use this View as a base for your own customisations.
Rik