Skip to content

Instantly share code, notes, and snippets.

@AshishBarde

AshishBarde/Query

Created January 8, 2015 05:11
Show Gist options
  • Save AshishBarde/b0891fa8a8edcb84c817 to your computer and use it in GitHub Desktop.
Save AshishBarde/b0891fa8a8edcb84c817 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Query
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
@AshishBarde
Copy link
Author

help me out on these issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment