Skip to main content
All CollectionsData & operationsIssues & Pull Requests dataset
Issues and PRs > First review submitted at
Issues and PRs > First review submitted at
Tom Williams avatar
Written by Tom Williams
Updated over 6 months ago

Dataset: Issues & Pull Requests

Entity: Pull Requests, Issues

Field ID: first_review_submitted_at

Type: Datetime

Description: The datetime at which the first review was submitted on a pull request. For issues, it is the timestamp of the oldest review submission across all resolving pull requests.

Source: Calculated from pull request reviews

Transformation logic:

  • Pull requests: It is the submission datetime of the first pull request review

  • Issues: It is the submission datetime of the oldest pull request review across all resolving pull requests. Resolving pull requests are pull requests that reference the issue via auto-closing keywords.

The table below maps the fields or logic from the source systems corresponding the most closely to the transformation carried out by Keypup:

From:

Github (PR reviews)

first_review.submitted_at

Gitlab (PR reviews)

first_review_event.created_at

Bitbucket (PR reviews)

first_review.participated_on

JIRA (Issues)

N/A (see transformation logic)

ClickUp (Issues)

N/A (see transformation logic)

Trello (Issues)

N/A (see transformation logic)

Did this answer your question?