Remove automorfism in cypher result

[Jaroslav Ramba]

Hi,

how can I remove automorfism in cypher result? This example http://console.neo4j.org/?id=tz1lwc has 12 rows in result and 10 are "duplicity" (automorfism). I want only 2 triangles in result, which actually are in the database.  As you can see in the result graph, there are only two triangles, but table has 12 rows. 

I know that it is propably caused by traversing, but all I need these 2 unique triangles.

[Michael Hunger]

MATCH (a)-[r]-(b)-[q]-(c)-[o]-(a)

WHERE id(a)<id(b) AND id(b)< id(c)

RETURN a,r,b,q,c,o

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jaroslav Ramba]

Thank you Michael

[Jaroslav Ramba]

I need to apply this for any cypher query though. It means that I do not know what graph pattern will be in MATCH clause (I am developing a method that accepts any cypher query and returns only unique results of the query - without duplicates). I could not apply the query above unless I would parse MATCH clause.

So I am looking for a general part of query (some kind of WHERE clause I guess) that I could add to user’s cypher query to preserve from returning duplicates.

[Jared Beekman]

I modified your query to this:

MATCH (a)-[r]->(b)-[q]->(c)-[o]->(a)

RETURN a,r, b,q,c,o

and returned 6 rows. the DISTINCT modifier didn't help in the return (in either query I may add).

Hopefully this is what you are looking for. Note, sans arraows (>) you are getting bi-directional graphs which is probably why it's doubling.