Skip to main content

Commits > ID (source)

Written by Tom Williams

Dataset: Commits from pull requests

Entity: Commit

Field ID: id

Type: Text

Description: The ID assigned to the record by the source application. Except on Azure DevOps, this is not the commit hash: use SHA1 to identify a commit.

Source: App

App Mapping

Github (Commits)

id

Gitlab (Commits)

Calculated: commit SHA and merge request ID

Bitbucket (Commits)

Calculated: SHA256 of the pull request ID and the commit hash

Azure DevOps (Commits)

commitId

Jira

N/A

ClickUp

N/A

Trello

N/A

Reporting Use Cases

The ID (Source) field uniquely identifies a commit record. Its primary role in reporting is to enable meaningful drilldowns from aggregated metrics to the specific, individual commits that make up the total.

  • Enabling Accurate Drilldowns: This is the most critical use case for this field. When you view a high-level metric, such as a bar chart showing "Commits per Day," and you click on a bar representing "15 commits," you need a way to see exactly which 15 commits those are. The drilldown view that appears will be a list of those individual commits, and the ID (Source) serves as the unique key for each record. Add SHA1 to the list to see the hash of every commit, a direct, unambiguous reference that you can use to investigate the code in your Git tool.

  • Context in List Reports: In any list-based report that displays individual commits (not just drilldowns), the ID (Source) (often shortened for readability) should be included as a dimension. It serves as the primary unique identifier, giving context and allowing for easy cross-referencing with your source code repository.

  • Direct Filtering: While less common for general reporting, you can also use this field to isolate a single commit record, for example one found in a drilldown. To find a commit by its hash, filter on SHA1 instead, with a filter like SHA1 = "a1b2c3d4e5f6a7b8c9d0...".

Did this answer your question?