Hi all, this is my query: match(n)-[r]->(m) where not m.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospital','Recovered'] and not n.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospital','Recovered'] return n,r,m The result of the query will be a subgraph. How can I save this s…

Here is a solution that I used, Collected the ids of nodes, created a node and added the ids list as a property. Step: 1 match(n)-[r]->(m) where not m.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospital','Recovered'] and not n.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospit…

Hi @abhishekjayant1 , Unfortunately there's no way to save a sub-graph in Neo4j itself. While this may possible some day when multi-graph handling has become available, today you have to manage this manually. There are two main approaches: mark the query results with a label on the nodes, and a …

Hey @abk , thanks for your reply. The first method is easy but also naive. Can you pls explain the 2nd method in some detail? Would appreciate the help :)

Hey @ameyasoft , thanks a lot for the reply. I didn't think of this way, will definitely help me out. :slight_smile:

Abhishek - you might be able to use the function apoc.refactor.cloneSubgraphFromPaths . match path=(n)-->(m) where not m.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospital','Recovered'] and not n.name in ['JANSSEN','PFIZER\BIONTECH','ANOFI PASTEUR','Hospital','Recovered'] WITH path CAL…

The problem here is not cloning, but saving the query results for subsequent reproduction as and when required. Many users use the database and run their own anlaytics and want to save the query results,

Only replying here because there might be :dragon: for those who stumble across this later. There's no problem if the data in your graph never changes once it's loaded. But, be careful here for two reasons: 1 - internal node id's returned by the id() function are not stable outside of a t…

Good Approach, For me this also worked MATCH (n {name: 'M10-1'})-[r:CALLS *]->(m) WITH collect(id(m)) as cg MATCH (n1)-[r]->(m1) WHERE id(m1) in cg RETURN n1,r,m1

How to save the result of a query (sub graph) in cypher

Neo4j Graph Platform

malsharafi (Malsharafi) November 20, 2024, 11:15am 10

can't you reduce the query and eliminate the step of:
"
unwind sub1 as sub2
with collect(sub2) as s1
"
just keep:
match(x) where id(x) in sub1
?

Topic		Replies	Views
How to save the result of a query (sub graph) in cypher Neo4j Graph Platform migrated	1	95	July 26, 2022
Facing difficulties to create a subgraph from original one in NEO4j Cypher networkx	15	1920	November 19, 2019
Querying in cypher a subgraph from my DB Cypher cypher , operations	7	157	January 25, 2025
Issue of Performance in Generating our Graphs Cypher apoc , performance , plugin	2	78	November 21, 2024
Copy Subgraph from one neo4j server to another neo4j server Neo4j Graph Platform apoc , cypher , operations	1	328	August 13, 2021

How to save the result of a query (sub graph) in cypher

Related topics