Issues and PRs > State
Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Dataset: Issues & Pull Requests

Entity: Pull Requests, Issues

Field ID: state

Type: Select list

Description: The open/close state of the item. Possible values are:

  • CLOSED the issue was closed or the pull request was closed without being merged.

  • DRAFT the pull request is currently being worked on and is not ready to be looked at by others.

  • MERGED the pull request was merged.

  • OPEN the issue or pull request is still active.

Source: App

Transformation logic: N/A

From:

Github (PRs)

If isDraft = true then DRAFT.

Otherwise, it is mapped from the state field:

  • CLOSED => CLOSED

  • MERGED => MERGED

  • OPEN => OPEN

Github (Issues)

Mapped from the state field:

  • OPEN => OPEN

  • CLOSED => CLOSED

Gitlab (PRs)

If draft = true then DRAFT

Otherwise, it is mapped from the state field:

  • closed => CLOSED

  • merged => MERGED

  • opened => OPEN

Gitlab (Issues)

Mapped from the state field:

  • closed => CLOSED

  • opened => OPEN

Bitbucket (PRs)

Mapped from the state field:

  • DECLINED => CLOSED

  • MERGED => MERGED

  • OPEN => OPEN

  • SUPERSEDED => CLOSED

JIRA (Issues)

if resolutiondate is populated then CLOSED, otherwise OPEN.

ClickUp (Issues)

if date_closed is populated then CLOSED, otherwise OPEN.

Trello (Issues)

if closed OR dueComplete then CLOSED, otherwise OPEN.

Did this answer your question?