How do I query a GitHub Project V2 Item Order by Custom Field from GraphQL?

Question

How do I get the order of items in a board view column from the API? I found the sortBy object in the ProjectV2 views, but I'm struggling querying the items ordered by fieldValue (position?).

Would you mind helping me construct a query for the JSON equivalent of the data in the picture, please?

I also asked the same question in the Github Community, just in case — Adam Kliment
– Adam Kliment, Commented Sep 8, 2022 at 15:41
Hey, Ben, I did not. But I suspect there might not be such a thing as Order in Column in Github Projects V2 data design at all. I think there's only an Order of Items in the entire Project and the column is "view" in the scope of the Field Value. — Adam Kliment
– Adam Kliment, Commented Sep 22, 2022 at 9:35
What I did: - created custom select field A with options A1, A2, A3 - created custom select field B with options B1, B2, B3 - created two different boards, columns by A and B options - created three Items (cards) "One", "Two", "Three", all with custom Field A value A1, custom Field B value B1 - reordered the items in the board A - the order is the Items node order in the GrapQL API - BUT the order propagated to the board B - when I reorder the items in the board B - the order propagates to the board A and again to the Items order in the API — Adam Kliment
– Adam Kliment, Commented Sep 22, 2022 at 9:42

sara byron · Accepted Answer · 2024-05-07 07:57:20Z

0

I find a example, it may helps.

You can use orderBy: {field: CREATED_AT, direction: ASC} as below shows.

query MyQuery {
  repository(name: "dbeaver", owner: "dbeaver") {
    issues(first: 100, filterBy: {labels: "bug", createdBy: "2022-01-01..*"}, orderBy: {field: CREATED_AT, direction: ASC}) {
      edges {
        node {
          createdAt
          labels(first: 100) {
            edges {
              node {
                name
              }
            }
          }
        }
      }
      totalCount
    }
  }
}

answered May 7, 2024 at 7:57

sara byron

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I query a GitHub Project V2 Item Order by Custom Field from GraphQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related