The JSON file not returning some data or more data

[saisannihith741]

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?

[Cobra]

Hello @saisannihith741 😊

Can you share the cypher query?

Regards,

Cobra

[saisannihith741]

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

[Cobra]

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

[saisannihith741]

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 

[Cobra]

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

[saisannihith741]

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 

[Cobra · Accepted solution]

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

[saisannihith741]

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