Data views: Only display relevant options in status filter

[jameskoster]

Related #55083

In the Pages management view all post statuses appear in the Status filter dropdown. This can lead to irrelevant filter configurations, for example if you install WooCommerce you'll find order statuses as options while managing pages:

Some context from @oandregal:

but the issue here seems to be that statuses are unbound: they affect all post types – see, for example, register_post_status. I can see how Woo may be registering some new statuses that show up there in your setup.

The issue is that we don't know for which post type a status is registered, and we cannot simply remove the ones that are not the default from core: we'd also be removing post types that plugins intentionally added for pages, for example (editorial flow).

The way forward may be what Jorge already suggested: allow providing statuses that are bound to a Custom Post Type.

[oandregal]

@jameskoster would you be able to share a screenshot of your wp-admin page for pages? I don't see the trash status in the list you share, so I wonder whether you'd see the Trash link at the top-right of that page:

[jameskoster]

Yes I see Trash in the wp-admin Pages view:

Edit: It does seem to be related to custom statuses though. If I disable WooCommerce then Trash appears as an option:

[oandregal]

I've discussed this issue with others, to better understand the way forward here. It seems sensible to only support the core statuses right now.

We want to support custom statuses as well. However, that has many ramifications, see #3144 and https://core.trac.wordpress.org/ticket/12706 Plugins would need to migrate to this new API. It's something that would take time, and it's beyond the current scope for the dataviews project at the moment. It needs to be looked at separately.