A gist of the queries used in the Advanced Neo4j course for conditional logic

neo4j-advanced-ifthen.cql

//001 - Deceased
MATCH (person:Person)
WHERE NOT person.died IS NULL
SET person:Deceased;

//002 - Alive
MATCH (person:Person)
WHERE person.died IS NULL
SET person:Alive;

//003 - Cleanup the additional labels so we can do it again
MATCH (person:Person)
REMOVE person:Alive, person:Deceased;

//004 - APOC Alive or deceased
MATCH (person:Person)
CALL apoc.do.when(
  person.died IS NULL, 
  'SET person:Alive',
  'SET person:Deceased',
  {person:person}
) YIELD value
RETURN DISTINCT "done";

//005 - Cleanup the additional labels so we can do it again
MATCH (person:Person)
REMOVE person:Alive, person:Deceased;

//006 - CALL Subquery Alive or deceased
MATCH (person:Person)
CALL { WITH person
  WITH person WHERE person.died IS NOT NULL
  SET person:Alive
}
CALL { WITH person
  WITH person WHERE person.died IS NULL
  SET person:Deceased
}
RETURN count(*);