Project associated PR

The ProjectAssociatedPr relationship represents the link between Jira project and external pull request within the Teamwork Graph. It allows you to:

• Retrieve external pull requests associated with a specific Jira project
• Find which Jira projects are associated with an external pull request
• Traverse and analyze project-pull-request relationships

Relationship type: Canonical

Cypher

Forward query

GraphQL

1
2
query ProjectAssociatedPr_CypherQuery($cypherQuery: String!, $params: JSON!) {
 graphStore @optIn(to: ["GraphStore", "GraphStoreCypherQueryV2"]) {
  cypherQueryV2(query: $cypherQuery, params: $params) {
   edges {
    node {
     columns {
      key
      value {. on GraphStoreCypherQueryV2NodeList {
        nodes {
         data {. on DevOpsPullRequestDetails {
           id
          }. on ExternalPullRequest {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on DevOpsPullRequestDetails {
          id
         }. on ExternalPullRequest {
          id
         }
        }
       }. on GraphStoreCypherQueryV2BooleanObject {
        bool_val: value
       }. on GraphStoreCypherQueryV2IntObject {
        int_val: value
       }. on GraphStoreCypherQueryV2FloatObject {
        float_val: value
       }. on GraphStoreCypherQueryV2StringObject {
        str_val: value
       }
      }
     }
    }
   }
  }
 }
}

Params

1
2
{
 "cypherQuery": "MATCH (project:JiraProject {ari: $id})-[:project_associated_pr]->(request:GraphPullRequest) RETURN request",
 "params": {
  "id": "$id"
 }
}

Inverse query

GraphQL

1
2
query ProjectAssociatedPr_CypherQuery($cypherQuery: String!, $params: JSON!) {
 graphStore @optIn(to: ["GraphStore", "GraphStoreCypherQueryV2"]) {
  cypherQueryV2(query: $cypherQuery, params: $params) {
   edges {
    node {
     columns {
      key
      value {. on GraphStoreCypherQueryV2NodeList {
        nodes {
         data {. on JiraProject {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on JiraProject {
          id
         }
        }
       }. on GraphStoreCypherQueryV2BooleanObject {
        bool_val: value
       }. on GraphStoreCypherQueryV2IntObject {
        int_val: value
       }. on GraphStoreCypherQueryV2FloatObject {
        float_val: value
       }. on GraphStoreCypherQueryV2StringObject {
        str_val: value
       }
      }
     }
    }
   }
  }
 }
}

Params

1
2
{
 "cypherQuery": "MATCH (project:JiraProject)-[:project_associated_pr]->(request:GraphPullRequest {ari: $id}) RETURN project",
 "params": {
  "id": "$id"
 }
}

Materialization via Cypher Experimental

This materialization rule automatically creates project_associated_pr relationships by traversing from Jira projects through their issues to find associated pull requests.

Cypher

1
2
// Materialization Rule: issue-associates-project-to-pr
MATCH (project:JiraProject {ari: $id})
MATCH (project)-[rel0:project_has_issue]->(issue:JiraIssue)
MATCH (issue)-[rel1:issue_associated_pr]->(request:GraphPullRequest)
RETURN request AS ret, MAX(rel1.lastUpdated) AS lastUpdated

Metadata

To metadata

Relationship metadata

Reviewer

Author

Ari

PullRequestStatus

ReviewerStatus