Allow filtering work items by status widget values

What does this MR do and why?

Allows filtering work items by status widget on GraphQL.

related to #366218 (closed)

How to set up and validate locally

1. On a project, create a couple of requirements using the UI.
2. Edit both. One to have verified value and another to have failed verification status.
3. Go to your localhost graphql explorer http://local_instance/-/graphql-explorer
4. Execute the following Graphql query:

query filteredWorkItems { 
  project(fullPath: "theproject") {
    workItems(statusWidget: { status: FAILED }) {
      edges {
        node {
          id
        }
      }
    }
  }
}

The result should return only the work item with satisfied status.

Database queries

This introduces new scopes to allow filtering issues by associated test reports state. They were previously used only with requirements table, here we are sharing them to be used with issues table.

• Query to filter by test report state: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/12645/commands/44611
• Query to filter by missing test report state, when there are no associated test report records with the issue: https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/12645/commands/44613

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.