Refresh document in OrientDB by deleting item in list
Is it possible to remove one item in an inline list in a document in OrientDB? I have a "personaldata" document that contains a list of "requests". for example
{ name: "Marco", inquiries: [{date: 2014-11-22, status: "DRAFT}, {date: 2014-10-22, status: "PUBLISHED"}]}
Now I want to delete all requests with the status "PROJECT". How can I accomplish this using Orient SQL?
+3
Gregor
source
to share
1 answer
You can try this command
update personaldata remove inquiries = {"status":"DRAFT","date":"2014-11-22"}
+4
Roman Gordon
source
to share