Neo4j match path exclude node with certain label

Question

I am having a issue to retrieve path in neo4j exclude certain label.

Foe example, I have

               -->(h)-->(j)
              /
(a)-->(b)-->(c)-->(d)-->(i)
        \           
         -->(f)-->(g)

with h node has a Deleted label.

I have query

MATCH path = (n)-[*]->(child) where id(n)={id of node a} and NOT child:Deleted RETURN path

then I want this query to return the full path but exclude the subtree of node h since node h is Deleted.

the return tree should be like

(a)-->(b)-->(c)-->(d)-->(i)
        \           
         -->(f)-->(g)

But the query seems not working.

Can any one help me with this.

Thanks

Answer 1

What worked for me is a list comprehension over nodes in the path:

MATCH path = ()-[*]->()
WHERE NONE(n IN nodes(path) WHERE n:Deleted)
RETURN path