cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

The JSON file not returning some data or more data

saisannihith741
Node Clone

Hi ,

I am running one particular cypher query and by using the Export JSON option for downloading the JSON file got the JSON

By digging deep into it I have found Some data are missing in the JSON file which are returning in the graph.

My question is :-Do the export JSON will return all the nodes and relationship data that are returning in the cypher shell in JSON file or not?

1 ACCEPTED SOLUTION

Normally the export button to JSON should be equal to what is inside the RETURN statement, otherwise there is a bug.

View solution in original post

8 REPLIES 8

Cobra
Ninja
Ninja

Hello @saisannihith741 😊

Can you share the cypher query?

Regards,

Cobra

match p=(v:Vendor)-[]->(m:MatPlant)-[]->(d:MatPlant{matl_typ:'SEMI FINISHED GOODS'})-[]->(c:MatPlant{matl_typ:'FINISHED GOODS'})-[*0..2]->(u:Customer)
where u.node_id in ["US1|0040037155"]  
and m.node_id in ['US1|400A065|US11']
with p,d.node_id as sem_f,c.node_id as finish 
match k=(d:MatPlant)-[r:MfgMatPlant_To_WorkCenter]-(wc:WorkCenter)
where d.node_id in [sem_f]
with p,k,finish
match l=(c:MatPlant)-[r:MfgMatPlant_To_WorkCenter]->(wc:WorkCenter)
where c.node_id in [finish] 
return p,l,k

Normally it will return the same data. Did you see any differences?

The export button has the same result you see in the table view of the Neo4j browser, but the chart view may have more relationships. Everything in the return clause will be exported.

Regards,
Cobra

Yes I see @Cobra There is missing  relationships in the JSON by export JSON options .And also the count of  realtioinships is increasing in some cases and decreasing in some cases .

could you please help me to find an alternate way for getting everything that i saw in the graph in Json 

Hello @saisannihith741

In Neo4j Browser, if you click on Browser settings, you must have a checkbox called Connect result nodes, you have to uncheck it.

Cobra_0-1656938581721.png

Regards,
Cobra

And also What if we dont have those relation ship in table and still showing in the graph??Is it possible Just wanted to learn about this also if that possible @Cobra 

 

Normally the export button to JSON should be equal to what is inside the RETURN statement, otherwise there is a bug.

Thank you I have done it @Cobra .The result is not coming in the return statement, So. I have changed it