Hello, I'm working with a data model where entities have a set of common properties:
name created deleted Deleted property is null until entity is soft-deleted, then null is set to time stamp value. I'm using merge to avoid creating new entity if an existing one has the same name: merge (x:Thing{name: $name}) on create set created=timestamp() This works fine until entity is deleted: match (x:Thing{name: "someName"}) set x.deleted=timestamp(); I would like to add deleted property to merge criteria but I'm not sure how to do that. Something like this (not a valid query): merge (x:Thing{name EQUALS $name AND deleted IS NULL}) on create set created=timestamp() That way I could create new entity only if name does not exist or it exists but entity has been deleted. I would appreciate any help in this matter. Thanks, M -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.