APOC函数详解：路径查询方法

数据模型基于以下示例图：

@Data
@RelationshipEntity(type = "Materials")
public class MaterialsRelationship {
    @Id
    private String uuid;
    /**
     * 起始节点
     */
    @StartNode
    private ProductEntryNode startNode;
    /**
     * 终止节点
     */
    @EndNode
    private ProductEntryNode endNode;
}

@Query(" match path=(p:ProductEntry)-[r:Materials|Manufacture|Technology*1..]->(pp)" +
       " where p.productEntryId={productEntryId}" +
       " return path")
List getProductEdgesList(String productEntryId);

@Query(" match path=(p:ProductEntry)-[r:Materials|Manufacture|Technology*1..{level}]->(pp)" +
       " where p.productEntryId={productEntryId}" +
       " return path")
List getProductEdgesList(String productEntryId, int level);

apoc.path.expand(start :: ANY?, relationshipFilter :: STRING?, labelFilter :: STRING?, minLevel :: INTEGER?, maxLevel :: INTEGER?) :: (path :: PATH?)

• start：起始节点，可以是任意类型。
• relationshipFilter：关系类型，多个类型用 | 分隔（STRING）。
• labelFilter：标签过滤（STRING）。
• minLevel：最小路径长度（INTEGER）。
• maxLevel：最大路径长度（INTEGER）。
• path：返回的路径结果。

@Query("match (p:ProductEntry) where p.productEntryId={productEntryId}" +
       " call apoc.path.expand(p,'       " return path")
List getProductEdgesList(String productEntryId, int level);

(p)-[r:Materials]->(pp:ProductEntry)-[r:Materials]->(ppp:ProductEntry)

@Query("match (p:ProductEntry) where p.productEntryId={productEntryId}" +
       " call apoc.path.expand(p,'Materials>|Manufacture>|Technology>','',1,{level}) yield path" +
       " return path")
List getProductEdgesList(String productEntryId, int level);

@Query("match (p:ProductEntry) where p.productEntryId={productEntryId}" +
       " call apoc.path.expand(p,'Materials>|Manufacture>|Technology>','/Engineering',1,{level}) yield path" +
       " return path")
List getProductEdgesList(String productEntryId, int level);

(p)-[r:Materials]->(pp:Engineering)-[r:Materials]->(ppp:Engineering)