User authored PR

The Teamwork Graph API is coming soon. The relationship types documented here are indicative of what will be available in the Graph via the Teamwork Graph API. Please note that relationships, their properties, and functionality may change before and during the Early Access Program.

Interested in early access? Express your interest in joining the EAP

The UserAuthoredPr relationship represents the link between an Identity user and an external pull request they authored within the Teamwork Graph. It allows you to:

Find which users authored specific external pull requests
Find all external pull requests created by a particular user
Traverse and analyze user-pull-request relationships

Relationship type: Activity

From object type	To object type
Identity user - `ati:cloud:identity:user`	External pull request - `ati:cloud:jira:pull-request`

Cypher

We recommend using parameterized Cypher queries rather than placing parameters directly in the query string. This helps improve performance.

Forward query

GraphQL

1
2
query UserAuthoredPr_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 (user:IdentityUser {ari: $id})-[:user_authored_pr]->(request:GraphPullRequest) RETURN request",
 "params": {
  "id": "$id"
 }
}

Inverse query

GraphQL

1
2
query UserAuthoredPr_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 AtlassianAccountUser {
           id
          }. on CustomerUser {
           id
          }. on AppUser {
           id
          }. on ThirdPartyUser {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on AtlassianAccountUser {
          id
         }. on CustomerUser {
          id
         }. on AppUser {
          id
         }. on ThirdPartyUser {
          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 (user:IdentityUser)-[:user_authored_pr]->(request:GraphPullRequest {ari: $id}) RETURN user",
 "params": {
  "id": "$id"
 }
}