Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Retrieve a list of the issues & PRs in the global backlog and include Status #10

Closed
mikeaintworkin opened this issue Jan 23, 2023 · 22 comments
Closed

Retrieve a list of the issues & PRs in the global backlog and include Status #10

mikeaintworkin opened this issue Jan 23, 2023 · 22 comments
Labels
ReportProjectDetails

Comments

@mikeaintworkin
Copy link
Contributor

mikeaintworkin commented Jan 23, 2023 •
edited
Loading

This is really a continuation of IQSS/dataverse#8
which was interrupted because I did the PR procedure out of order.
The objective here is to retrieve the list of columns in a project.
For this one I'm going to continue to use my own project instead of dataverse.

I'm still not confident I understand how to interpret the documentation on how to pull specific information. I'm still relying on examples. As far as this issue is concerned I'm still not there yet. What I've done is just manage to get a list of projects.

Originally posted by @mikeaintworkin in #8 (comment)
@mikeaintworkin
Copy link
Contributor Author

First I'm going to create a branch,
then continue to work out the process until I have a list of column names printed out for my project

@mikeaintworkin
Copy link
Contributor Author

deleted the branch IQSS/dataverse#8 from origin
Before I can delete it locally I have to switch my local branch that I'm working off locally.
In this case, I have a branch created for this issue so I switched to that.
Then I was able to delete the branch associated with IQSS/dataverse#8

@mikeaintworkin
Copy link
Contributor Author

It appears my bearer token has been deleted.
I'm going to go ahead and create a new one.
The old one was not stored in github.
Maybe this is user error?

@mikeaintworkin
Copy link
Contributor Author

mikeaintworkin commented Jan 23, 2023 •
edited
Loading

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/return_project_columns.py

xxx - {'data': {'organization': {'projectsV2': {'nodes': [{'id': 'PVT_kwDOA9hM5s4AK8Hf', 'number': 4, 'title': 'Experments with GitHub', 'closed': False}, {'id': 'PVT_kwDOA9hM5s4AHoYs', 'number': 3, 'title': 'Agile Dungeon Trekking', 'closed': False}, {'id': 'PVT_kwDOA9hM5s4AHidk', 'number': 2, 'title': "@mreekie's untitled project", 'closed': True}]}, 'id': 'MDEyOk9yZ2FuaXphdGlvbjY0NTA3MTEw', 'email': None}}}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author

It appears that if I even cut/paste the bearer token into comments here it gets deleted.
That's pretty cool.

@mikeaintworkin
Copy link
Contributor Author

mikeaintworkin commented Jan 23, 2023 •
edited
Loading

Looking at the work here:
https://github.com/atsign-company/dump_cards

And wondering if I could/should learn this and build on it or contribute.
For now I'm looking at his dump_cards code and learning about the API that way.

@mikeaintworkin
Copy link
Contributor Author

Going to pause here.
I know that I can get there.
I know that I"m still a bit far away.
The next step is to make sure I'm focused on the right info retrieval first..

@mikeaintworkin mikeaintworkin changed the title Complete - retrieving column names from ordered backlog projects Retrieve column names from ordered backlog projects Jan 23, 2023
@mikeaintworkin
Copy link
Contributor Author

making good progress.
Here is the latest query and results.

organization(login: "IQSS") {
        projectV2 (number: 34) {
            title
            closed
            number
            createdAt
            updatedAt
            closedAt
            url
            creator {
                login
            }
            # view number 1 is the ordered backlog tab
            view (number: 1 ) {
                name
                filter
                fields(first: 20) {
                    totalCount
                    # nodes returns a list.
                    # The items in the list are of type unionIsProjectV2FieldConfiguration
                    # This is a union type, so we need to use the __typename field to determine the type
                    # of the item in the list.  
                    # The __typename field is a string that contains the name of the type.
                    # We can use this to determine which fields to query.
                    # The fields we query depend on the type of the item in the list.
                    nodes  {
                            __typename 
                            # This will only show the name of the field if it's set to visible
                            ... on ProjectV2Field {
                                name
                            }  
                            ... on ProjectV2IterationField {
                                name
                            }  
                            ... on ProjectV2SingleSelectField {
                                name
                            }  
                    }
                        
                    
                }
            }
            # ProjectV2 views return ProjectV2ViewConnection
            views (first: 20) {
                totalCount
                nodes {
                    id
                    name
                    number

                }
            }
        }
        id
        email
        projectsUrl
        login
    }


}

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-27T00:00:31Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "view": {
                    "name": "\ud83c\udf0fGlobal Backlog",
                    "filter": "",
                    "fields": {
                        "totalCount": 8,
                        "nodes": [
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Title"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Assignees"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Labels"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Linked pull requests"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Reviewers"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Repository"
                            },
                            {
                                "__typename": "ProjectV2Field",
                                "name": "Milestone"
                            },
                            {
                                "__typename": "ProjectV2SingleSelectField",
                                "name": "Sprint"
                            }
                        ]
                    }
                },
                "views": {
                    "totalCount": 9,
                    "nodes": [
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgAu2p0",
                            "name": "\ud83c\udf0fGlobal Backlog",
                            "number": 1
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgAzvl4",
                            "name": "All",
                            "number": 4
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgA2D5A",
                            "name": "Community",
                            "number": 6
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgA-HPI",
                            "name": "\ud83d\udd0e:\u23f1Sprint + \ud83c\udfc1Sprint",
                            "number": 8
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgA-ISA",
                            "name": "\ud83d\udd0e:PRs in the Ordered Backlog",
                            "number": 9
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgA-IXo",
                            "name": "\ud83d\udd0e:Just the Ordered Backlog",
                            "number": 10
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgBDT3c",
                            "name": "NetCDF",
                            "number": 11
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgBDa5Y",
                            "name": "OrderedSizingQueue",
                            "number": 12
                        },
                        {
                            "id": "PVTV_lADOAApNpc4AHKIszgBHuNE",
                            "name": "View 13",
                            "number": 13
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author

The immediate objective has changed because the sprint is going now.
What I am going to do first is retrieve the list of issues that are all in the "current sprint" column.
What I will do is:

  • Get the project.
  • Get the status column values

Then

  • get the list items that have the status value of in this sprint.
  • Get the titles, numbers, and labels

@mikeaintworkin
Copy link
Contributor Author

More progress.
I have retrieved the "Status" list - the list of columns in the backlog.

organization(login: "IQSS") {
        projectV2 (number: 34) {
            title
            closed
            number
            createdAt
            updatedAt
            closedAt
            url
            creator {
                login
            }
            # view number 1 is the ordered backlog tab
            field( name: "Status" ) {
                __typename 
                # This will only show the name of the field if it's set to visible
                ... on ProjectV2Field {
                    name
                    id
                }  
                ... on ProjectV2IterationField {
                    name
                }  
                ... on ProjectV2SingleSelectField {
                    name
                    id
                    options {
                        name
                        id
                    }
                }  

            }   
                
        }
        id
        email
        projectsUrl
        login
    }

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-27T00:00:31Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "field": {
                    "__typename": "ProjectV2SingleSelectField",
                    "name": "Status",
                    "id": "PVTSSF_lADOAApNpc4AHKIszgEIB9s",
                    "options": [
                        {
                            "name": "Community Backlog (Phil)",
                            "id": "51ae1026"
                        },
                        {
                            "name": "HERMES (Oliver)",
                            "id": "87df89a3"
                        },
                        {
                            "name": "External Commitments (Jim)",
                            "id": "c90173cb"
                        },
                        {
                            "name": "Dataverse Team (Gustavo)",
                            "id": "f7b365a7"
                        },
                        {
                            "name": "SonarQube cleanup (Gustavo)",
                            "id": "bcdd99cc"
                        },
                        {
                            "name": "Harvard Dataverse Instance (Sonia)",
                            "id": "92a3600d"
                        },
                        {
                            "name": "NIH NetCDF (Phil)",
                            "id": "fa1011fd"
                        },
                        {
                            "name": "NIH bklog items (Stefano)",
                            "id": "c59f5cef"
                        },
                        {
                            "name": "Re-arch: Auth MVP (Phil)",
                            "id": "f492918e"
                        },
                        {
                            "name": "Re-arch: SPA MVP (Guillermo)",
                            "id": "fc7ac1e1"
                        },
                        {
                            "name": "1\ufe0f\u20e3 \u25b6ORDERED BACKLOG (Stefano)",
                            "id": "98236657"
                        },
                        {
                            "name": "2\ufe0f\u20e3\u25b6 SPRINT PREP (Tech discussion/Sizing)",
                            "id": "452dbbfb"
                        },
                        {
                            "name": "3\ufe0f\u20e3\u25b6 \ud83d\udca8\ud83d\udc5fSPRINT READY BACKLOG",
                            "id": "172d4ab2"
                        },
                        {
                            "name": "4\ufe0f\u20e3\u25b6\u23f1In This Sprint",
                            "id": "e75513da"
                        },
                        {
                            "name": "5\ufe0f\u20e3\u25b6\ud83c\udfc1Been In a Sprint",
                            "id": "101a240f"
                        },
                        {
                            "name": "[reference] Deliverables & collections",
                            "id": "a7a8b126"
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author

The next step is to return a list of issues

  • In the backlog
  • with status
  •                    {
                      "name": "4\ufe0f\u20e3\u25b6\u23f1In This Sprint",
                      "id": "e75513da"
                  },

@mikeaintworkin
Copy link
Contributor Author

image

@mikeaintworkin
Copy link
Contributor Author

mikeaintworkin commented Jan 28, 2023 •
edited
Loading

Updated columns in backlog after a discussion with Stefano

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-28T01:36:50Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "field": {
                    "__typename": "ProjectV2SingleSelectField",
                    "name": "Status",
                    "id": "PVTSSF_lADOAApNpc4AHKIszgEIB9s",
                    "options": [
                        {
                            "name": "\ud83d\udeaeClear of the Backlog",
                            "id": "866d07ba"
                        },
                        {
                            "name": "Community Backlog (Phil)",
                            "id": "51ae1026"
                        },
                        {
                            "name": "HERMES (Oliver)",
                            "id": "87df89a3"
                        },
                        {
                            "name": "External Commitments (Jim)",
                            "id": "c90173cb"
                        },
                        {
                            "name": "Dataverse Team (Gustavo)",
                            "id": "f7b365a7"
                        },
                        {
                            "name": "SonarQube cleanup (Gustavo)",
                            "id": "bcdd99cc"
                        },
                        {
                            "name": "Harvard Dataverse Instance (Sonia)",
                            "id": "92a3600d"
                        },
                        {
                            "name": "NIH NetCDF (Phil)",
                            "id": "fa1011fd"
                        },
                        {
                            "name": "NIH bklog items (Stefano)",
                            "id": "c59f5cef"
                        },
                        {
                            "name": "Re-arch: Auth MVP (Phil)",
                            "id": "f492918e"
                        },
                        {
                            "name": "Re-arch: SPA MVP (Guillermo)",
                            "id": "fc7ac1e1"
                        },
                        {
                            "name": "\u25b6SPRINT- NEEDS SIZING",
                            "id": "98236657"
                        },
                        {
                            "name": "\u25b6 SPRINT READY",
                            "id": "172d4ab2"
                        },
                        {
                            "name": "\u25b6Sprint Kickoff!",
                            "id": "e75513da"
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author 

                  {
                        "name": "\u25b6Sprint Kickoff!",
                        "id": "e75513da"
                    }

I need this id, but the path I've taken down the tree of properties won't get me to a list of issues in the column "\u25b6Sprint Kickoff!"

I need to go down a different path:

@mikeaintworkin mikeaintworkin mentioned this issue Jan 29, 2023
Closed
@mikeaintworkin mikeaintworkin changed the title Retrieve column names from ordered backlog projects Retrieve a list of the issues & PRs in the ready-for-sprint column in the global backlog Jan 29, 2023
@mikeaintworkin
Copy link
Contributor Author

mikeaintworkin commented Jan 29, 2023 •
edited
Loading

More progress!

  • I have a list of all the isssues in the project
  • Well I have a list of the 1st 20 of 172.
  • The next step will be to get the first 20 in the ready-for-sprint column.
  • Then I'm going to have to worry about pagination I think.

I'm using a combination of viewing the original schema.docs.graphql in pycharm and then manually walking through the query with the same schema doc imported into zenkit hypernotes. The work in hypernotes is very manual, but I'm finding that it helps me to digest how the schema "thinks".

query1 = """
{
###
organization(login: "IQSS") {
        projectV2 (number: 34) {
            title
            closed
            number
            createdAt
            updatedAt
            closedAt
            url
            creator {
                login
            }
            items (first: 20) {
                
                totalCount
                nodes {
                    id
                    type 
                    content {
                        ... on Issue {
                            title
                            number
                            url
                        }
                        ... on PullRequest {
                            title
                            number
                            url
                        }
                        ... on DraftIssue {
                            title
                        }
                    
                    }
                }
            } 
        }    
                
 
        id
        email
        projectsUrl
        login
    }
###
}
"""

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-28T01:36:50Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "items": {
                    "totalCount": 172,
                    "nodes": [
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDdiPw",
                            "type": "DRAFT_ISSUE",
                            "content": {
                                "title": "\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDgBco",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "Dataset files cleanup",
                                "number": 9132,
                                "url": "https://github.com/IQSS/dataverse/pull/9132"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ8hQ",
                            "type": "ISSUE",
                            "content": {
                                "title": "Feature request: Add the ability to configure a Harvesting Client to add a custom header to OAI calls",
                                "number": 9231,
                                "url": "https://github.com/IQSS/dataverse/issues/9231"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEREPI",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "8339 file data api",
                                "number": 9269,
                                "url": "https://github.com/IQSS/dataverse/pull/9269"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgERENo",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "extract metadata (NcML XML) from NetCDF/HDF5 files, new \"requirements\" option for external tools",
                                "number": 9239,
                                "url": "https://github.com/IQSS/dataverse/pull/9239"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDO4h0",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "7980 enhanced dsd",
                                "number": 8915,
                                "url": "https://github.com/IQSS/dataverse/pull/8915"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPakE",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "7000 mpconfig files basic",
                                "number": 8827,
                                "url": "https://github.com/IQSS/dataverse/pull/8827"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnFM",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "Add quotes around CVoc term URIs on advanced search page",
                                "number": 9105,
                                "url": "https://github.com/IQSS/dataverse/pull/9105"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDP82U",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "IQSS/9121 Fix for search display with ext. CVoc",
                                "number": 9122,
                                "url": "https://github.com/IQSS/dataverse/pull/9122"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDQd5Q",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "IQSS/9126- Fix workflow token access",
                                "number": 9129,
                                "url": "https://github.com/IQSS/dataverse/pull/9129"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ35M",
                            "type": "ISSUE",
                            "content": {
                                "title": "In TabularSubsetGenerator.java use try-with-resources for BufferedWriter",
                                "number": 9282,
                                "url": "https://github.com/IQSS/dataverse/issues/9282"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ28M",
                            "type": "ISSUE",
                            "content": {
                                "title": "In Files.java usr try-with-resources to for  JsonReader",
                                "number": 9280,
                                "url": "https://github.com/IQSS/dataverse/issues/9280"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPajk",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "7000 mpconfig rserve",
                                "number": 8830,
                                "url": "https://github.com/IQSS/dataverse/pull/8830"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDr79w",
                            "type": "ISSUE",
                            "content": {
                                "title": "Retrospective: Continue the daily standups.",
                                "number": 9201,
                                "url": "https://github.com/IQSS/dataverse-pm/issues/101"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnIs",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "IQSS/9095-dvwebloader integration",
                                "number": 9096,
                                "url": "https://github.com/IQSS/dataverse/pull/9096"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEJPkw",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "9228 - add OIDC development setup for OIDC login feature testing",
                                "number": 9234,
                                "url": "https://github.com/IQSS/dataverse/pull/9234"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD575s",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "8843 more harvest tests",
                                "number": 9227,
                                "url": "https://github.com/IQSS/dataverse/pull/9227"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDieAs",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "QDR/9172-fix messages",
                                "number": 9173,
                                "url": "https://github.com/IQSS/dataverse/pull/9173"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD4sWU",
                            "type": "PULL_REQUEST",
                            "content": {
                                "title": "import function DatasetUtil",
                                "number": 9226,
                                "url": "https://github.com/IQSS/dataverse/pull/9226"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDWIBo",
                            "type": "ISSUE",
                            "content": {
                                "title": "Extract metadata from NetCDF and HDF5 files as XML in NcML format",
                                "number": 9153,
                                "url": "https://github.com/IQSS/dataverse/issues/9153"
                            }
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author

mikeaintworkin commented Jan 29, 2023 •
edited
Loading

I can get all the issues in the project with more information

query1 = """
{
###
organization(login: "IQSS") {
        projectV2 (number: 34) {
            title
            closed
            number
            createdAt
            updatedAt
            closedAt
            url
            creator {
                login
            }
            items (first: 20) {
                
                totalCount
                nodes {
                    id
                    type 
                    content {
                        ... on Issue {
                            repository {
                                name
                            }
                            title
                            number
                            url
                            labels (first: 10) {
                              totalCount
                                nodes {
                                    name
                                }
                            }
                        }
                        ... on PullRequest {
                            repository {
                                name
                            }
                            title
                            number
                            url
                            labels (first: 10) {
                              totalCount
                                nodes {
                                    name
                                }
                            }
                        }
                        ... on DraftIssue {
                            title
                        }
                    
                    }
                }
            } 
        }    
                
 
        id
        email
        projectsUrl
        login
    }
###
}

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-28T01:36:50Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "items": {
                    "totalCount": 172,
                    "nodes": [
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDdiPw",
                            "type": "DRAFT_ISSUE",
                            "content": {
                                "title": "\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDgBco",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Dataset files cleanup",
                                "number": 9132,
                                "url": "https://github.com/IQSS/dataverse/pull/9132",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: SprintTail"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ8hQ",
                            "type": "ISSUE",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Feature request: Add the ability to configure a Harvesting Client to add a custom header to OAI calls",
                                "number": 9231,
                                "url": "https://github.com/IQSS/dataverse/issues/9231",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "NIH OTA: 1.4.1"
                                        },
                                        {
                                            "name": "Size: 80"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEREPI",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "8339 file data api",
                                "number": 9269,
                                "url": "https://github.com/IQSS/dataverse/pull/9269",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: SprintTail"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgERENo",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "extract metadata (NcML XML) from NetCDF/HDF5 files, new \"requirements\" option for external tools",
                                "number": 9239,
                                "url": "https://github.com/IQSS/dataverse/pull/9239",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDO4h0",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7980 enhanced dsd",
                                "number": 8915,
                                "url": "https://github.com/IQSS/dataverse/pull/8915",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPakE",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7000 mpconfig files basic",
                                "number": 8827,
                                "url": "https://github.com/IQSS/dataverse/pull/8827",
                                "labels": {
                                    "totalCount": 6,
                                    "nodes": [
                                        {
                                            "name": "Feature: File Upload & Handling"
                                        },
                                        {
                                            "name": "Feature: Code Infrastructure"
                                        },
                                        {
                                            "name": "Feature: Installation Guide"
                                        },
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Containers & Cloud"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnFM",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Add quotes around CVoc term URIs on advanced search page",
                                "number": 9105,
                                "url": "https://github.com/IQSS/dataverse/pull/9105",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDP82U",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9121 Fix for search display with ext. CVoc",
                                "number": 9122,
                                "url": "https://github.com/IQSS/dataverse/pull/9122",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDQd5Q",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9126- Fix workflow token access",
                                "number": 9129,
                                "url": "https://github.com/IQSS/dataverse/pull/9129",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ35M",
                            "type": "ISSUE",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "In TabularSubsetGenerator.java use try-with-resources for BufferedWriter",
                                "number": 9282,
                                "url": "https://github.com/IQSS/dataverse/issues/9282",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        },
                                        {
                                            "name": "Tech Debt"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ28M",
                            "type": "ISSUE",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "In Files.java usr try-with-resources to for  JsonReader",
                                "number": 9280,
                                "url": "https://github.com/IQSS/dataverse/issues/9280",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        },
                                        {
                                            "name": "Tech Debt"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPajk",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7000 mpconfig rserve",
                                "number": 8830,
                                "url": "https://github.com/IQSS/dataverse/pull/8830",
                                "labels": {
                                    "totalCount": 6,
                                    "nodes": [
                                        {
                                            "name": "Type: Feature"
                                        },
                                        {
                                            "name": "Feature: Code Infrastructure"
                                        },
                                        {
                                            "name": "Feature: Installation Guide"
                                        },
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Containers & Cloud"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDr79w",
                            "type": "ISSUE",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Retrospective: Continue the daily standups.",
                                "number": 9201,
                                "url": "https://github.com/IQSS/dataverse-pm/issues/101",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Sprint Retrospective"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnIs",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9095-dvwebloader integration",
                                "number": 9096,
                                "url": "https://github.com/IQSS/dataverse/pull/9096",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DataverseNO"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEJPkw",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "9228 - add OIDC development setup for OIDC login feature testing",
                                "number": 9234,
                                "url": "https://github.com/IQSS/dataverse/pull/9234",
                                "labels": {
                                    "totalCount": 3,
                                    "nodes": [
                                        {
                                            "name": "Feature: Account & User Info"
                                        },
                                        {
                                            "name": "NIH OTA: 1.7.1 (reArchitecture)"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD575s",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "8843 more harvest tests",
                                "number": 9227,
                                "url": "https://github.com/IQSS/dataverse/pull/9227",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDieAs",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "QDR/9172-fix messages",
                                "number": 9173,
                                "url": "https://github.com/IQSS/dataverse/pull/9173",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD4sWU",
                            "type": "PULL_REQUEST",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "import function DatasetUtil",
                                "number": 9226,
                                "url": "https://github.com/IQSS/dataverse/pull/9226",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDWIBo",
                            "type": "ISSUE",
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Extract metadata from NetCDF and HDF5 files as XML in NcML format",
                                "number": 9153,
                                "url": "https://github.com/IQSS/dataverse/issues/9153",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "NIH: NetCDF"
                                        },
                                        {
                                            "name": "Size: 80"
                                        }
                                    ]
                                }
                            }
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin
Copy link
Contributor Author

I'm feeling stuck. I've got a list of issues in the project.
I have a list of fields and values. How do put the 2 together?
Like I want to see all of the issues in this project with this field set to this value?

I've avoided looking at views. Maybe the answer is there?
Perhaps...

  • I am missing some basic thing - like there's some operator I don't realize exists
  • It can't be done. This sounds ridiculous though. I mean - the UI works and it would have to use this informaiton.
  • Worst case I can do it old school and build a local database one query at a time. I'm planning on doing something like that eventually though.

I think it's likely I"m missing something basic.

@mikeaintworkin
Copy link
Contributor Author

I have the next piece possibly.
the projectv2|items|nodes is where I think the next step might be.

  • I've explored the content property - which is the PRs/Issues.
  • The fieldValueByName property is next.
  • I think that will get me to the list of issues and add on the value of the "Status" field.
  • If I go only this far, I'll still be able to have a list that I can deal with in the python.

@mikeaintworkin
Copy link
Contributor Author 

... on ProjectV2ItemFieldDateValue {
	date
}

... on  ProjectV2ItemFieldIterationValue {
	id
}
... on  ProjectV2ItemFieldLabelValue {
	labels
}
... on  ProjectV2ItemFieldMilestoneValue {
	milestone
}
... on  ProjectV2ItemFieldNumberValue {
	number
}
... on  ProjectV2ItemFieldPullRequestValue {
	pullRequests {
		totalCount
	}
}
... on  ProjectV2ItemFieldRepositoryValue {
	repository {
		name
	}
}
... on  ProjectV2ItemFieldReviewerValue {
	reviewers(first:20) {
		totalCount
	}

}
... on  ProjectV2ItemFieldSingleSelectValue {
	name
}
... on  ProjectV2ItemFieldTextValue {
	text	

}
... on  ProjectV2ItemFieldUserValue {
	users(first:20) {
		totalCount
	}
}

@mikeaintworkin
Copy link
Contributor Author 

#Query1C
organization(login: "IQSS") {
        projectV2 (number: 34) {
            title
            closed
            number
            createdAt
            updatedAt
            closedAt
            url
            creator {
                login
            }
            items (first: 20) {
                
                totalCount
                nodes {
                    id
                    type 
                    fieldValueByName (name: "Status") {
                        ... on ProjectV2ItemFieldDateValue {
                            date
                        }
                        
                        ... on  ProjectV2ItemFieldIterationValue {
                            id
                        }
                        ... on  ProjectV2ItemFieldLabelValue {
                            labels {
                                totalCount
                                nodes {
                                    name
                                } 
                            }
                        }
                        ... on  ProjectV2ItemFieldMilestoneValue {
                            milestone {
                                title
                            }
                        }
                        ... on  ProjectV2ItemFieldNumberValue {
                            number
                        }
                        ... on  ProjectV2ItemFieldPullRequestValue {
                            pullRequests {
                                totalCount
                            }
                        }
                        ... on  ProjectV2ItemFieldRepositoryValue {
                            repository {
                                name
                            }
                        }
                        ... on  ProjectV2ItemFieldReviewerValue {
                            reviewers(first:20) {
                                totalCount
                            }
                        
                        }
                        ... on  ProjectV2ItemFieldSingleSelectValue {
                            name
                        }
                        ... on  ProjectV2ItemFieldTextValue {
                            text	
                        
                        }
                        ... on  ProjectV2ItemFieldUserValue {
                            users(first:20) {
                                totalCount
                            }
                        }
                    }
                    content {
                        ... on Issue {
                            repository {
                                name
                            }
                            title
                            number
                            url
                            labels (first: 10) {
                              totalCount
                                nodes {
                                    name
                                }
                            }
                        }
                        ... on PullRequest {
                            repository {
                                name
                            }
                            title
                            number
                            url
                            labels (first: 10) {
                              totalCount
                                nodes {
                                    name
                                }
                            }
                        }
                        ... on DraftIssue {
                            title
                        }
                    
                    }
                }
            } 
        }    
                
 
        id
        email
        projectsUrl
        login
    }
###

/usr/bin/python3.10 /home/perftest/DevCode/github-com-mreekie/GitHubProjects/experimentsWithGithub/bin/queryies_to_github.py 
{
    "data": {
        "organization": {
            "projectV2": {
                "title": "Dataverse_Global_Backlog",
                "closed": false,
                "number": 34,
                "createdAt": "2022-10-13T16:30:18Z",
                "updatedAt": "2023-01-28T01:36:50Z",
                "closedAt": null,
                "url": "https://github.com/orgs/IQSS/projects/34",
                "creator": {
                    "login": "mreekie"
                },
                "items": {
                    "totalCount": 172,
                    "nodes": [
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDdiPw",
                            "type": "DRAFT_ISSUE",
                            "fieldValueByName": {
                                "name": "\u25b6 SPRINT READY"
                            },
                            "content": {
                                "title": "\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab\u25ab"
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDgBco",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Dataset files cleanup",
                                "number": 9132,
                                "url": "https://github.com/IQSS/dataverse/pull/9132",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: SprintTail"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ8hQ",
                            "type": "ISSUE",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Feature request: Add the ability to configure a Harvesting Client to add a custom header to OAI calls",
                                "number": 9231,
                                "url": "https://github.com/IQSS/dataverse/issues/9231",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "NIH OTA: 1.4.1"
                                        },
                                        {
                                            "name": "Size: 80"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEREPI",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "8339 file data api",
                                "number": 9269,
                                "url": "https://github.com/IQSS/dataverse/pull/9269",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: SprintTail"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgERENo",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "extract metadata (NcML XML) from NetCDF/HDF5 files, new \"requirements\" option for external tools",
                                "number": 9239,
                                "url": "https://github.com/IQSS/dataverse/pull/9239",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDO4h0",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7980 enhanced dsd",
                                "number": 8915,
                                "url": "https://github.com/IQSS/dataverse/pull/8915",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPakE",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7000 mpconfig files basic",
                                "number": 8827,
                                "url": "https://github.com/IQSS/dataverse/pull/8827",
                                "labels": {
                                    "totalCount": 6,
                                    "nodes": [
                                        {
                                            "name": "Feature: File Upload & Handling"
                                        },
                                        {
                                            "name": "Feature: Code Infrastructure"
                                        },
                                        {
                                            "name": "Feature: Installation Guide"
                                        },
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Containers & Cloud"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnFM",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Add quotes around CVoc term URIs on advanced search page",
                                "number": 9105,
                                "url": "https://github.com/IQSS/dataverse/pull/9105",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDP82U",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9121 Fix for search display with ext. CVoc",
                                "number": 9122,
                                "url": "https://github.com/IQSS/dataverse/pull/9122",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDQd5Q",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9126- Fix workflow token access",
                                "number": 9129,
                                "url": "https://github.com/IQSS/dataverse/pull/9129",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DANS"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ35M",
                            "type": "ISSUE",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "In TabularSubsetGenerator.java use try-with-resources for BufferedWriter",
                                "number": 9282,
                                "url": "https://github.com/IQSS/dataverse/issues/9282",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        },
                                        {
                                            "name": "Tech Debt"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEQ28M",
                            "type": "ISSUE",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "In Files.java usr try-with-resources to for  JsonReader",
                                "number": 9280,
                                "url": "https://github.com/IQSS/dataverse/issues/9280",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        },
                                        {
                                            "name": "Tech Debt"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDPajk",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "7000 mpconfig rserve",
                                "number": 8830,
                                "url": "https://github.com/IQSS/dataverse/pull/8830",
                                "labels": {
                                    "totalCount": 6,
                                    "nodes": [
                                        {
                                            "name": "Type: Feature"
                                        },
                                        {
                                            "name": "Feature: Code Infrastructure"
                                        },
                                        {
                                            "name": "Feature: Installation Guide"
                                        },
                                        {
                                            "name": "User Role: Sysadmin"
                                        },
                                        {
                                            "name": "Containers & Cloud"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDr79w",
                            "type": "ISSUE",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Retrospective: Continue the daily standups.",
                                "number": 9201,
                                "url": "https://github.com/IQSS/dataverse-pm/issues/101",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Sprint Retrospective"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDNnIs",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "IQSS/9095-dvwebloader integration",
                                "number": 9096,
                                "url": "https://github.com/IQSS/dataverse/pull/9096",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "DataverseNO"
                                        },
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgEJPkw",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "9228 - add OIDC development setup for OIDC login feature testing",
                                "number": 9234,
                                "url": "https://github.com/IQSS/dataverse/pull/9234",
                                "labels": {
                                    "totalCount": 3,
                                    "nodes": [
                                        {
                                            "name": "Feature: Account & User Info"
                                        },
                                        {
                                            "name": "NIH OTA: 1.7.1 (reArchitecture)"
                                        },
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD575s",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "8843 more harvest tests",
                                "number": 9227,
                                "url": "https://github.com/IQSS/dataverse/pull/9227",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 10"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDieAs",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "QDR/9172-fix messages",
                                "number": 9173,
                                "url": "https://github.com/IQSS/dataverse/pull/9173",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgD4sWU",
                            "type": "PULL_REQUEST",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "import function DatasetUtil",
                                "number": 9226,
                                "url": "https://github.com/IQSS/dataverse/pull/9226",
                                "labels": {
                                    "totalCount": 1,
                                    "nodes": [
                                        {
                                            "name": "Size: 3"
                                        }
                                    ]
                                }
                            }
                        },
                        {
                            "id": "PVTI_lADOAApNpc4AHKIszgDWIBo",
                            "type": "ISSUE",
                            "fieldValueByName": {
                                "name": "\ud83d\udeaeClear of the Backlog"
                            },
                            "content": {
                                "repository": {
                                    "name": "dataverse"
                                },
                                "title": "Extract metadata from NetCDF and HDF5 files as XML in NcML format",
                                "number": 9153,
                                "url": "https://github.com/IQSS/dataverse/issues/9153",
                                "labels": {
                                    "totalCount": 2,
                                    "nodes": [
                                        {
                                            "name": "NIH: NetCDF"
                                        },
                                        {
                                            "name": "Size: 80"
                                        }
                                    ]
                                }
                            }
                        }
                    ]
                }
            },
            "id": "MDEyOk9yZ2FuaXphdGlvbjY3NTIzNw==",
            "email": null,
            "projectsUrl": "https://github.com/orgs/IQSS/projects",
            "login": "IQSS"
        }
    }
}

Process finished with exit code 0

@mikeaintworkin mikeaintworkin changed the title Retrieve a list of the issues & PRs in the ready-for-sprint column in the global backlog Retrieve a list of the issues & PRs in the global backlog and include Status Jan 29, 2023
@mikeaintworkin
Copy link
Contributor Author

I modified the title again.
I'm going to stop here and close the issues.

I have retrieved a list of issues and PRs

  • That belong to the global backlog project
  • That include the value of the "Status" field which indicates which backlog column that they are in.
  • That include enough other field data that I should be able to have the start of an external database.

@mikeaintworkin
Copy link
Contributor Author

Where I Think I'm heading now is:

  • Learn how to extract JSON into python using the JSON library
  • Output the results into tabular format
    • in particular get the list of issues out of this that I'm going to want to add to the dataverse project where we host the sprints.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
ReportProjectDetails
Projects
Experments with GitHub
Status: ✅ Done
Milestone
No milestone
Development

When branches are created from issues, their pull requests are automatically linked.

10-complete-retrieving-column-names-from-ordered-backlog-projects thisaintwork/experimentsWithGithub
1 participant
@mikeaintworkin