Querying for prefix in a list

[deepak]

In the following example:

CREATE (:A)-[:AB{list:['k1:v1', 'k2:v2']}]->(:B)
CREATE (:A)-[:AB{list:['k2:v2']}]->(:B)

To find path with AB.list having an element k1:v1, I can use the following query:

WITH 'k1:v1' AS query
MATCH path = (:A)-[ab:AB]->(:B) WHERE query IN ab.list RETURN path

The query above uses an exact match in the list, but I only have a prefix k1: to query with. Is there a valid Cypher to achieve something like this?

WITH 'k1:' AS queryPrefix
MATCH path = (:A)-[ab:AB]->(:B) WHERE queryPrefix.* IN ab.list RETURN path

[BairDev · Accepted solution]

Maybe you can try some trick with list.reduce()

reduce(totalAge = 0, n IN nodes(p) | totalAge + n.age)

in your case:

WHERE reduce(contains = 0, l IN ab.list | contains + CASE WHEN l CONTAINS 'k1:' THEN 1 ELSE 0 END) > 0

The syntax works, but I did not test it in a similar data set like yours.