Project associated vulnerability

The ProjectAssociatedVulnerability relationship represents the link between a Jira project and an external vulnerability within the Teamwork Graph. It allows you to:

• Retrieve external vulnerabilities associated with a specific Jira project
• Find which Jira projects are associated with an external vulnerability
• Traverse and analyze project-vulnerability relationships

Relationship type: Canonical

Cypher

Forward query

GraphQL

1
2
query ProjectAssociatedVulnerability_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 DevOpsSecurityVulnerabilityDetails {
           id
          }. on ExternalVulnerability {
           id
          }
         }
        }
       }. on GraphStoreCypherQueryV2AriNode {
        data {. on DevOpsSecurityVulnerabilityDetails {
          id
         }. on ExternalVulnerability {
          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_vulnerability]->(vulnerability:GraphVulnerability) RETURN vulnerability",
 "params": {
  "id": "$id"
 }
}

Inverse query

GraphQL

1
2
query ProjectAssociatedVulnerability_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_vulnerability]->(vulnerability:GraphVulnerability {ari: $id}) RETURN project",
 "params": {
  "id": "$id"
 }
}

Materialization via Cypher Experimental

This materialization rule automatically creates project_associated_vulnerability relationships by traversing from Jira projects through their security containers to find associated vulnerabilities.

Cypher

1
2
// Materialization Rule: security-container-associates-project-to-vulnerability
MATCH (project:JiraProject {ari: $id})
MATCH (project)-[rel0:project_associated_to_security_container]->(container:GraphSecurityContainer)
MATCH (container)-[rel1:security_container_associated_to_vulnerability]->(vulnerability:GraphVulnerability)
RETURN vulnerability AS ret, MAX(rel1.lastUpdated) AS lastUpdated

Metadata

To metadata

Container

Ari

VulnerabilityStatus

VulnerabilitySeverity

VulnerabilityType