VSD [FE] - "Projects by DORA table" - Include subgroup projects in the panel

Subgroup projects with DORA metrics are not included in the "Projects by DORA table". This is due to a limitation mentioned in this thread.

Solution

The existing GraphQL query needs to be updated to use the new GraphQL resolver created in #507722 (closed).

diff --git a/ee/app/assets/javascripts/analytics/dashboards/graphql/dora_metrics_by_project.query.graphql b/ee/app/assets/javascripts/analytics/dashboards/graphql/dora_metrics_by_project.query.graphql
index 7fbddba48389..9c959c8f359d 100644
--- a/ee/app/assets/javascripts/analytics/dashboards/graphql/dora_metrics_by_project.query.graphql
+++ b/ee/app/assets/javascripts/analytics/dashboards/graphql/dora_metrics_by_project.query.graphql
@@ -9,19 +9,21 @@ query doraMetricsByProjectQuery(
 ) {
   group(fullPath: $fullPath) {
     id
-    projects(after: $after) {
-      pageInfo {
-        endCursor
-        hasNextPage
-      }
-      nodes {
-        id
-        name
-        avatarUrl
-        webUrl
-        dora {
-          metrics(startDate: $startDate, endDate: $endDate, interval: $interval) {
-            ...DoraMetricItem
+    dora {
+      projects(after: $after, from: $startDate, to: $endDate, includeSubgroups: true) {
+        pageInfo {
+          endCursor
+          hasNextPage
+        }
+        nodes {
+          id
+          name
+          avatarUrl
+          webUrl
+          dora {
+            metrics(startDate: $startDate, endDate: $endDate, interval: $interval) {
+              ...DoraMetricItem
+            }
           }
         }
       }