Clever Geek Handbook

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


source to share


1 answer


You can try this command



update personaldata remove inquiries = {"status":"DRAFT","date":"2014-11-22"}
+4


source






More articles:


All Articles