Cypher Simple Paths

[Rehan]

Hi, 

I am using below query to get all possible paths between two nodes:

START a=node:node_auto_index(name="A") , m=node:node_auto_index(name="M")  MATCH p=a-[*]-m  WHERE ALL(r in RELS(p) WHERE (r.value >= 200 OR r.value=0) ) RETURN p ORDER BY length(p) desc limit 20

This query returns the results with loops as well i.e. paths contains loop. How can I restrict  this to return only simple paths. 

Br , 

Rehan

[Rehan]

UpDate: 

My Nodes have multiple relationships of same type with each other. 

[Peter Neubauer]

You could for instance exclude paths that have m or a as one of the
nodes? http://docs.neo4j.org/chunked/snapshot/query-function.html#_collection_functions

Let me know if you need an example, I think I can craft one ...

Cheers,

/peter neubauer

G: neubauer.peter
S: peter.neubauer
P: +46 704 106975
L: http://www.linkedin.com/in/neubauer
T: @peterneubauer

Neo4j 1.8 GA - http://www.dzone.com/links/neo4j_18_release_fluent_graph_literacy.html

> --
>
>

[Rehan Azher]

Hi Peter, 

Can you help t craft one such query. please. 

Thanks and Best Regards,


--
Rehan Azher
Cell: +65 92967887

--

[Wes Freeman]

This is a bit of an abomination--there should be a better way--but you might be able to use it to get simple paths:

http://console.neo4j.org/r/1jiuaf

If you want to see the cyclic paths, take out the where clause.

Wes

--
 
 

[Rehan]

Thanks WES, what if we want to add a filter on relationship as well. i.e. property with value <=200.

[Wes Freeman]

You could add that in to the WHERE clause with an AND, just like you had it in the original query.

Wes

--
 
 

[Rehan]

Hi Wes, 

Thank you . 

One more query is it possible to build a query which should not include a given path . 

Thanks and Best Regards, 

Rehan

[Wes Freeman]

Probably. The question is, how do you know which path you don't want to include?

--
 
 

[Wes Freeman]

You can do something like this, which is pretty straightforward:

http://console.neo4j.org/r/i945yw