Hi Jackrabbit Dev Team,
I am working on JackRabbit Oak, and have questions about the node deletion. Our backend store is using mysql. From Jackrabbit documentation, I see this "The _deleted sub-document contains the revision this node was created in. In the above example the root node was created in revision r13f3875b5d1-0-1. If the node is later deleted, the _deleted sub-document will get a new field with the revision the node was deleted in." And I can see this "_deleted" in mysql in the "data" field, So I reply on the "_deleted" field, and tried to use the latest value of it to determine whether it's gotten deleted. For example, _deleted={r173bcb4360b-0-34d=false, r173bcb2fb8f-0-34d=false, r173bcaf6d2c-0-34e=false, r173bcae10fa-0-350=false, r173bcac5862-0-34d=false, r173bcac5859-0-34d=false, r173bc9bf9f0-0-342=false, r173bc9a42ce-0-343=false, r173bc994dce-0-34d=false, r173bc962853-0-34d=false, r173bc942ceb-0-34d=false, r173baa5a789-0-329=true, r1739196c343-1-2e9=false}. The latest value is "r173bcb4360b-0-34d=false", base on this, I assume it's not deleted. But actually, I have deleted this node via our UI, and it disappears in explorer as well. And there are some cases that we did not delete the anything, but the "_deleted" field shows the last revison as "true", which means it's gotten deleted. Thsi quite confuses us. So the question here is without mysql db connection (active jcr instance) what is the best/correct way to determin a node indeed exists or gets deleted from the mysql record? Thank for your support, Feng