Linked project has version

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 LinkedProjectHasVersion relationship represents the link between a Jira project and a Jira version within the Teamwork Graph. It allows you to:

Retrieve versions for a specific linked project
Find which linked project a version belongs to
Traverse and analyze linked-project-version relationships

Relationship type: Canonical

From object type	To object type
Jira project - `ati:cloud:jira:project`	Jira version - `ati:cloud:jira:version`

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 LinkedProjectHasVersion_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 JiraVersion {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on JiraVersion {
          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})-[:linked_project_has_version]->(version:JiraVersion) RETURN version",
 "params": {
  "id": "$id"
 }
}

Inverse query

GraphQL

1
2
query LinkedProjectHasVersion_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)-[:linked_project_has_version]->(version:JiraVersion {ari: $id}) RETURN project",
 "params": {
  "id": "$id"
 }
}

Materialization via Cypher Experimental

This materialization rule automatically creates linked_project_has_version relationships by traversing from Jira projects through their shared version relationships to find associated versions.

Cypher

1
2
// Materialization Rule: project-associates-linked-project-to-version
MATCH (project:JiraProject {ari: $id})
MATCH (project)-[rel0:project_has_shared_version_with]->(project_1:JiraProject)
MATCH (project_1)-[rel1:project_has_version]->(version:JiraVersion)
RETURN version AS ret, GREATEST(MAX(rel0.lastUpdated), MAX(rel1.lastUpdated)) AS lastUpdated