How many comments/interactions (added labels, assignees) did a pr receive?

[SanJSp]

As a Scrum coach, I'd like to see how many interactions pull requests receive in total.

Basically, PR closing times metric only with interactions as values. The question here is: What counts as interaction, and how is it trackable?

What can we track? What do the APIs return?

[SanJSp]

This GraphQL query currently returns the comments, the reviews and interactions regarding pull requests. The problem is the huge amount of pagination necessary and that I'm currently not able to grab the small interactions like these:

query detailedPullRequests{
  repository(owner: "hpi-swt2", name: "connections-portal") {
    pullRequests(first: 1, after: "Y3Vyc29yOnYyOpHOIQnUng==") {
      pageInfo {
        hasNextPage
      }
      edges {
        cursor
        node {
          url
          author {
            login
          }
          reactions(first: 100){
            nodes{
              id         
            }
          }

          comments(first: 100) {
            nodes {
              body
              createdAt
              author {
                login
              }
            }
          }
          reviews(first: 100) {
            nodes {
              state
              createdAt
              body
              comments(first: 100) {
                nodes {
                  body
                }
              }
            }
          }
        }
      }
    }
  }
}

[SanJSp]

Label assignments do not seem possible, as there is no way to get the "assigned at" query. Your only able to check the updated_at and created_at field of a label.

[SanJSp]

Found a way to find these "interacting items". By using the timeLineItems nodes in he GraphQL query, we can find out the type of these interactions on the timeline. This allows to filter all reaction/team-based events and count them. The following problem is therefore solved:

....that I'm currently not able to grab the small interactions like these:

[SanJSp]

So it is not completely possible to count the interactions based only on the timelineEvents, as there a review is only counted as one comment. I prefer counting every comment by the author and others, every review as one interaction, every review comment as one interaction, every emoji interaction as an interaction and every timelineEvent of certain types listed below. But should I also count the reactions to comments? For example, if a user reacts to a PR review with a thumbs up?

Relevant timelineEvents:

• AssignedEvent - somebody has been assigned to this PR
• CrossReferencedEvent - Represents a mention made by one issue or pull request to another
• LabeledEvent - Represents a 'labeled' event on a given issue or pull request. F.e. added label xyz
• MergedEvent - Represents a 'merged' event on a given pull request.
• MovedColumnsInProjectEvent - Represents a 'moved_columns_in_project' event on a given issue or pull request.
• ReadyForReviewEvent - Represents a 'ready_for_review' event on a given pull request.
• ReferencedEvent - Represents a 'referenced' event on a given ReferencedSubject.
• RenamedTitleEvent - Represents a 'renamed' event on a given issue or pull request
• ReviewRequestedEvent - Represents an 'review_requested' event on a given pull request.
• ReviewRequestRemovedEvent - Represents a 'review_dismissed' event on a given issue or pull request.
• UnlabeledEvent
• UnassignedEvent

Current Query

query detailedPullRequests{
  repository(owner: "hpi-swt2", name: "connections-portal") {
    pullRequests(first: 1, after: "Y3Vyc29yOnYyOpHOIQnUng==") {
      pageInfo {
        hasNextPage
      }
      edges {
        cursor
        node {
          url
          author {
            login
          }
          reactions(first: 10){
            nodes{
              id         
            }
          }
    timelineItems(first: 100){
            nodes{
              __typename
            }
          }
          comments(first: 30) {
            nodes {
              body
              createdAt
              author {
                login
              }
            }
          }
          reviews(first: 4) {
            nodes {
              state
              createdAt
              body
              comments(first: 100) {
                nodes {
                  body
                }
              }
            }
          }
        }
      }
    }
  }
}

[SanJSp]

For simplicity’s sake, I'd prefer not to include the reactions on comments. That will become too much to process 😬

This was my current query until I've noticed a problem. The plan was to use pagination for f.e. the review comments so that we will simply paginate on the next comment-page of the pull request if there are too many. But this would create a huuuuge overhead as this would need a new query for each PR that needs pagination because this query can only deliver the next 100 PRs and not the next page of comments for only one PR. Without individual queries and pagination, this leads to fixed upper boundaries on the request, as we can only request a maximum of 500k nodes (and max 100 of each field - f.e. comments). With this in mind, does this metric still make sense? We could show everything to a scale of a "normal" PR, including up to 10 reviews and 100 comments each, 10 reactions, 30 comments and 100 timeline events per Pull Request.

Old query

query detailedPullRequests{
  repository(owner: "hpi-swt2", name: "connections-portal") {
    pullRequests(first: 100) {
      pageInfo {
        hasNextPage
      }
      edges {
        cursor
        node {
          url
          author {
            login
          }
          reactions(first: 10){
            nodes{
              id         
            }
            pageInfo{
              hasNextPage
            }
          }
    timelineItems(first: 100){
            nodes{
              __typename
            }
            pageInfo{
              hasNextPage
            }
          }
          comments(first: 30) {
            nodes {
              body
              createdAt
              author {
                login
              }
            }            
            pageInfo{
              hasNextPage
            }
          }
          reviews(first: 4) {
            nodes {
              state
              createdAt
              body
              comments(first: 100) {
                nodes {
                  body
                }
              }
            }
            pageInfo{
              hasNextPage
            }
          }
        }
      }
    }
  }
}

Query without pagination and fixed maxima

query detailedPullRequests{
  repository(owner: "hpi-swt2", name: "connections-portal") {
    pullRequests(first: 100) {
      pageInfo {
        hasNextPage
      }
      edges {
        cursor
        node {
          url
          author {
            login
          }
          reactions(first: 10){
            nodes{
              id         
            }
          }
    timelineItems(first: 100){
            nodes{
              __typename
            }
          }
          comments(first: 30) {
            nodes {
              body
              createdAt
              author {
                login
              }
            }
          }
          reviews(first: 10) {
            nodes {
              state
              createdAt
              body
              comments(first: 100) {
                nodes {
                  body
                }
              }
            }
          }
        }
      }
    }
  }
}