Keypup

Dataset: Issues &amp; Pull Requests

Field ID: <code>last_review_created_at</code>

Description: The datetime at which the last submitted pull request review was created. For issues, the timestamp is evaluated from resolving pull requests.

Source: Calculated from pull request reviews

Pull requests: It is the creation datetime of the last pull request review submitted, from when the review was started. Only GitHub allows reviews to be started and finished later. GitLab and Bitbucket consider reviews as instant, meaning that <code>last_review_created_at</code> and <code>last_review_submitted_at</code> will always be equal.

Issues: It is the creation datetime of the newest pull request review across all resolving pull requests. Resolving pull requests are pull requests that reference the issue via <a href="https://docs.keypup.io/en/articles/8117180-linking-pull-requests-to-issues">auto-closing keywords</a>.

- Pull requests: It is the creation datetime of the last pull request review submitted, from when the review was started. Only GitHub allows reviews to be started and finished later. GitLab and Bitbucket consider reviews as instant, meaning that <code>last_review_created_at</code> and <code>last_review_submitted_at</code> will always be equal.
- Issues: It is the creation datetime of the newest pull request review across all resolving pull requests. Resolving pull requests are pull requests that reference the issue via <a href="https://docs.keypup.io/en/articles/8117180-linking-pull-requests-to-issues">auto-closing keywords</a>.

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

Issues and PRs > Last review created at

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

From:
Github (PRs, Issues)	`last_review_submitted.created_at`
Gitlab (PRs, Issues)	Use the earliest `updated_at` of the request approvals endpoint. Note: GitLab only exposes approved reviews, there is no concept of informational or “changes requested” reviews.
Bitbucket (PRs)	`last_review_submitted.participated_on`
JIRA (Issues)	Calculated from resolving PRs
ClickUp (Issues)	Calculated from resolving PRs
Trello (Issues)	Calculated from resolving PRs