Only merge on keys not additional properties
You could use an extra label for :Deleted
Von meinem iPhone gesendet
> Am 09.08.2018 um 17:23 schrieb M <videm...@gmail.com>:
>
> 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.
--
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.
