Provided view config does not work as expected - Unpublished forward revision not shown

Steps to reproduce:

1. Install content moderation
2. Create a revisionable node which uses the default editorial content moderation workflow and which has the scheduled_publish field
3. Create a published node
4. Create a new draft out of that published node (Unpublished forward revisions)
5. Add a scheduled publish to that draft to transition from draft to published to that unpublished forward transition
6. This will work via drush call
7. This entry will not be visible on the provided view.

I began looking at this issue, and could see that the forward revisions were not included, the attached patch will cause future revisions to be included in the dynamic view. There is still an issue around moderation state and datetime that requires further work.

So in short the patch will show all valid rows, it will however be missing the future publishing state and execution time.

Looks promising. It will also need an update hook to add to the view for existing installs, but we can work out the other issues in the view, that should be easy enough to add.

I was looking into this issue. I could see that for forward revisions entities the Moderation States and Dates are not displaying under the Schedule published view.
I have added a revised patch to include the moderation state and datetime in the view.

Adding the updated patch with minor fixes. The schedules time was not showing on user's default time zone. Applied the fix for that.