Views of type 'Content Revisions' cannot be filtered out by content type

I don't know why, but it also happens to me. Would be nice to find out a solution.

Thank you

Re-opening as the issue is not solved even with the workaround in place.

Steps to reproduce:
- Install a site using the Standard profile
- Enable Content Moderation and Content Translation modules (content moderation will give us the moderated content admin dashboard which has this issue "/admin/content/moderated")
- Assign the "Editorial" workflow that gets created when enabling the content moderation module to the Article content type.
- Add a second language to the site, e.g French.
- Enable translation on the Article content type.
- Add an Article node and mark it as published.
- Add a translation for the article node that was just added but mark it as draft.
- Visit "/admin/content/moderated" and observe that the Content Type column for our translated node will have no information in it.

I'm facing this issue. I installed moderation_dashboard module that comes with some views installed. I tried updating one of the views to list only "Blog" content type, however I cannot find the Type filter.

I have exactly the same issue as described in #20.

Turned out that when content moderation is enabled for a content type and there are multiple translations, the table node_field_data will list only published translations. This is a problem because nid relationship has extra condition to match the language

For me the solution was quite obvious

/**
 * Implements hook_views_data_alter().
 */
function example_views_data_alter(array &$data): void {
  // We need to remove this extra language field in order to make it work
  // with unpublished translations of moderated content that are not listed in
  // node_field_data table.
  if (isset($data['node_field_revision']['nid']['relationship']['extra'])) {
    unset($data['node_field_revision']['nid']['relationship']['extra']);
  }
}

I followed the same steps as listed in #20 and I can reproduce the error #Atlanta2025