GraphQL - Get all commits by all users in all orgs with filtered date #24590

udayabaski · 2019-05-27T03:57:47Z

udayabaski
May 27, 2019

Hi,

I have the following query which returns all the commit history for the given org.

Questions 1:-

Not sure, How to filter commits history by date
Here, I pass orgName. How to get across all orgs?

{
search(query: “org:test”, type: REPOSITORY, last: 100) {
edges {
node {
… on Repository {
name
defaultBranchRef {
name
target {
… on Commit {
history(first: 100) {
edges {
node {
… on Commit {
committedDate
additions
author {
name
email
}
}
}
}
}
}
}
}
}
}
}
}
}

Answered by lee-dohm

May 29, 2019

You can filter commit history by date using the since or until parameter to the history connection on Commit:

{
  search(query: "org:test", type: REPOSITORY, last: 100) {
    nodes {
      ... on Repository {
        name
        defaultBranchRef {
          name
          target {
            ... on Commit {
              history(first: 100, since: "2013-07-11T00:00:00") {
                totalCount
                nodes {
                  ... on Commit {
                    committedDate
                    additions
                    author {
                      name
                      email
                    }
                  }
                }
              }
           …

View full answer

lee-dohm · 2019-05-29T19:09:41Z

lee-dohm
May 29, 2019

You can filter commit history by date using the since or until parameter to the history connection on Commit:

{
  search(query: "org:test", type: REPOSITORY, last: 100) {
    nodes {
      ... on Repository {
        name
        defaultBranchRef {
          name
          target {
            ... on Commit {
              history(first: 100, since: "2013-07-11T00:00:00") {
                totalCount
                nodes {
                  ... on Commit {
                    committedDate
                    additions
                    author {
                      name
                      email
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

As for getting all orgs, there isn’t currently a way to do that via the GraphQL API because the search connection requires something in the search query. There’s also no top-level connection that allows you to list all users, orgs, or repositories.

I hope that helps!

5 replies

maciekbanas Mar 16, 2023

Still that does not give you all commits, but only 100 per repo. Or am I wrong?

IAmHughes Mar 16, 2023

You would want to pagenate on them after this.

maciekbanas Mar 16, 2023

You mean with external wrapper on commits - with the use of endCursor and nextPage? But I wonder how to do it if I have repos above (sorry, I'm new to GraphQL). I mean, I can pagenate commits when I have query for one repository, like that:

{
  repository(name: "Test", owner: "Owner") {
    defaultBranchRef {
      target {
        ... on Commit {
          history(first: 100) {
            pageInfo {
              hasNextPage
              endCursor
            }
            edges {
              node {
                ... on Commit {
                  id
                  committedDate
                  author {
                    name
                  }
                  additions
                  deletions
                  changedFilesIfAvailable
                }
              }
            }
          }
        }
      }
    }
  }
}

IAmHughes Mar 16, 2023

It's not super clean but I have some examples here that was for a project I worked on when I found this discussion: https://github.com/IAmHughes/github-enterprise-user-commit-history

maciekbanas Mar 17, 2023

Yeah, thanks for that. So as far as I see you do it the way, I described - you first iterate over repos and then over commits, so you handle pagination for them individually (these are separate queries for repos and commits: https://github.com/IAmHughes/github-enterprise-user-commit-history/blob/main/user-commit-history-report.js).
So, rather your example is the answer to the problem, not the above 'search' query, where you can not handle pagination of both repos and commits in one query.

AshantaP · 2021-07-07T20:51:29Z

AshantaP
Jul 7, 2021

How collect all commits from all organizations with all repos for all the users ?
instead of “org:test”, How can we get all commit details for all the orgs ?

0 replies

IAmHughes · 2022-07-22T17:27:43Z

IAmHughes
Jul 22, 2022

Hey @lee-dohm - now that there’s a concept of an Enterprise object with 1:many organizations, can this be improved?

We are looking for a way to query all commits made by a member of my organization. I need to find out as much commit info as possible.

It would be…

For a given user, find all commits made across every repository in every organization over the last 12 months.

Then for each commit, any data on the commit itself (sha, and if possible, the actual changes made themselves, i.e. maybe the filenames and we’d output the url to see the diff)

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

GitHub Community

GraphQL - Get all commits by all users in all orgs with filtered date #24590

{{title}}

Replies: 3 comments 5 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

GraphQL - Get all commits by all users in all orgs with filtered date #24590

Replies: 3 comments · 5 replies

Replies: 3 comments 5 replies