useful_cypher.txt

Useful Cypher:

Find and kill the open debug port: (in terminal)
lsof -i :5005
kill -9 <pid>

Kill all apoc.periodic.list functions:
CALL apoc.cypher.doIt("CALL apoc.periodic.list",{}) YIELD value 
WITH value.name AS names
UNWIND names AS name
CALL apoc.cypher.doIt("CALL apoc.periodic.cancel({name}) YIELD delay RETURN delay", {name: name}) YIELD value
RETURN value


Get generated ES docs:
CALL apoc.es.query('localhost','_all','doc', "_all", null) YIELD value
WITH value
RETURN value


Using Maps so you don’t have to string together withs:
MATCH (n:Person)
WITH n LIMIT 1
WITH n, apoc.map.fromValues([]) AS map
MATCH p=shortestPath( (k:Person {name:'Kevin Bacon'})-[*0..]-(n)) 
WITH length(p)/2 AS baconNumber, n, map
WITH apoc.map.setKey(map,'baconNumber', baconNumber) AS map, n
MATCH (n)-[:ACTED_IN]-(m:Movie)
WITH collect(m) AS wasIn, n, map
WITH apoc.map.setKey(map,'wasInn', wasIn) AS map, n
RETURN map


!!!!Getting the label with the number of nodes it has!!!!!:
MATCH (a) WITH DISTINCT LABELS(a) AS temp, COUNT(a) AS tempCnt
UNWIND temp AS label
RETURN label, SUM(tempCnt) AS cnt
ORDER BY label