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?
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
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
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
Normally the export button to JSON should be equal to what is inside the RETURN statement, otherwise there is a bug.
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.
Regards,
Cobra
Thank you I have done it @Cobra .The result is not coming in the return statement, So. I have changed it
