Skip to content

Instantly share code, notes, and snippets.

View AshishBarde's full-sized avatar

Ashish Barde AshishBarde

  • Pune
View GitHub Profile
I have one problem with neo4j cypher query I am using 2.1.4 version of neo4j an in that using adpator I am putting sql data into neo4j It's showing all records and property values well I have one node or label WASTAGE but when I am applying cypher query on it then it is showing null value for quantity property actully qunatity value showing in the database neo4j on label WASTAGE
cypher query:
MATCH (SMARTORDER:SMARTORDER)-[SMARTORDERHASSITE:HAS]->(SITE:SITE)-[SITEHASWASTAGE:HAS]->(WASTAGE:WASTAGE) RETURN DISTINCT SITE.siteName AS SITE_siteName, WASTAGE.Date AS WASTAGE_Date, sum(toFloat(WASTAGE.Quantity)) AS SUM_WASTAGE_Quantity LIMIT 100
these is the cypher query I am using.. please give me a suggestion on it