Neo4j

igordata · 08-18-2020

Hi everyone, I have a node and I want to get all connected nodes in several steps. MATCH (n:tx)-[:tx2tx*1..3]-(m:tx) WHERE ID(m)=1791789334 RETURN * What I get is all possible paths with node m in them, in total about 2k paths. I don't need the pat...

igordata · 08-20-2020

Apoc rules. I end up with this and it works great and damn fast MATCH (t:tx) where id(t) = 1791789334 CALL apoc.path.subgraphAll(t, { relationshipFilter: "tx2tx", minLevel: 0, maxLevel: 4 }) YIELD nodes, relationships UNWIND nodes as nod...

igordata · 08-18-2020

Sorry, how? Could you please provide me an example? I already grew my query to that // uniq with outputs with fringe MATCH ptx=(m:tx)-[:tx2tx*1..3]-(n:tx)-[:tx2tx]-(f:tx) WHERE ID(m)=1791789334 MATCH po=(o:output)-[rtxo]-(n) MATCH pa=(a:addr)-[ra]-(...

igordata · 08-18-2020

It's not a perfect solution due to I'm still getting duplicates from po that are already in ptx but I'll stick with that one for this week

igordata · 08-18-2020

Found that kind of solution: // uniq MATCH ptx=(n:tx)-[:tx2tx*1..3]-(m:tx) MATCH po=(o:output)-[rtxo]-(n) WHERE ID(m)=1791789334 UNWIND nodes(ptx) as node UNWIND relationships(ptx) as relationship UNWIND nodes(po) as outputs RETURN collect(distinct n...

igordata · 08-18-2020

got error about apoc unknown function, I'll read about how to enable it, it looks like it is a must have thing, thanks

Neo4j

User Statistics

User Activity

How to avoid getting paths and get only list of unique nodes and relationships?

Re: How to avoid getting paths and get only list of unique nodes and relationships?

Re: How to avoid getting paths and get only list of unique nodes and relationships?

Re: How to avoid getting paths and get only list of unique nodes and relationships?

Re: How to avoid getting paths and get only list of unique nodes and relationships?

Re: How to avoid getting paths and get only list of unique nodes and relationships?