Get_Outgoing_Java_Package_Dependencies_Including_Subpackages.cypher

// Get Java Packages including their sub packages with the most outgoing dependencies first (if set before). Requires "Add_file_name and_extension.cypher".

MATCH (p:Java:Package)
WHERE p.outgoingDependenciesIncludingSubpackages IS NOT NULL
MATCH (artifact:Artifact)-[:CONTAINS]->(p)
RETURN artifact.name AS artifactName
      ,p.fqn                                             AS fullQualifiedPackageName
      ,p.name                                            AS packageName
      ,p.outgoingDependenciesIncludingSubpackages        AS outgoingDependencies
      ,p.outgoingDependenciesWeightIncludingSubpackages  AS outgoingDependenciesWeight
      ,p.outgoingDependentTypesIncludingSubpackages      AS outgoingDependentTypes
      ,p.outgoingDependentInterfacesIncludingSubpackages AS outgoingDependentInterfaces
      ,p.outgoingDependentPackagesIncludingSubpackages   AS outgoingDependentPackages
      ,p.outgoingDependentArtifactsIncludingSubpackages  AS outgoingDependentArtifacts
ORDER BY outgoingDependencies DESC, p.fqn ASC // package with most incoming dependencies first