{"id":10314,"date":"2023-07-07T21:52:46","date_gmt":"2023-07-08T02:52:46","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=10314"},"modified":"2023-08-29T10:08:49","modified_gmt":"2023-08-29T15:08:49","slug":"neo4j-cypher-queries","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=10314","title":{"rendered":"NEO4J: More Cypher Queries"},"content":{"rendered":"

To get a count of returned records, Cypher uses COUNT<\/a> pretty much the same way as SQL does<\/p>\n

\"\"<\/a><\/p>\n

Interestingly, there are other aggregation functions that remind me of using the ELK API — I can get averages, min\/max, and standard deviation.<\/p>\n

 <\/p>\n

Chaining MATCH statements functions similarly to a SQL JOIN — get the items with this label, add in some other stuff. And, just like an INNER JOIN, this means no data is returned when one of the conditions has no matches — Bill Clinton never lost an election, so we get a null data set here:<\/p>\n

\"\"<\/a><\/p>\n

The equivalent of an outer join is an OPTIONAL<\/em> MATCH — here, the records from the first MATCH will be returned even if there is no corresponding record matching the second MATCH<\/p>\n

\"\"<\/a><\/p>\n

ORDER BY<\/a> also works in the same way it does in SQL. Multiple order parameters are separated by a comma and add DESC to do a DESCENDING ORDER<\/p>\n

\"\"<\/a><\/p>\n

WHERE<\/a> can be used to create the equivalent of a LIKE query — the where =~ operator uses regular expression syntax, so you don’t just use % or * as a wildcard. Regex wildcards like .* (match any character zero or more times) are used.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

To get a count of returned records, Cypher uses COUNT pretty much the same way as SQL does Interestingly, there are other aggregation functions that remind me of using the ELK API — I can get averages, min\/max, and standard deviation.   Chaining MATCH statements functions similarly to a SQL JOIN — get the items …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1896],"tags":[1902,1897],"class_list":["post-10314","post","type-post","status-publish","format-standard","hentry","category-neo4j","tag-cypher","tag-neo4j"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10314"}],"version-history":[{"count":3,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10314\/revisions"}],"predecessor-version":[{"id":10322,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10314\/revisions\/10322"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}