2 / 2
Feb 20

Hello,

I have a collection like this:

{ "statx" : { "atime" : { "sec" : NumberLong(1740042357), "nsec" : 132742909 }, "mtime" : { "sec" : NumberLong(1740042357), "nsec" : 132742909 } }, "ns" : [ { "name" : "dir2", "xattrs" : { "path" : "/dir2" } } ] } { "statx" : { "atime" : { "sec" : NumberLong(1740042365), "nsec" : 273785382 }, "mtime" : { "sec" : NumberLong(1740042365), "nsec" : 273785382 } }, "ns" : [ { "name" : "file", "xattrs" : { "path" : "/file" } } ] }

I want to retrieve all documents that have a “statx.mtime.sec” greater than the “statx.mtime.sec” of the document with this path “ns.xattrs.path” == “/dir2”.
The only value I have is the “ns.xattrs.path” = “/dir2”. I need to retrieve the mtime of this document and do a comparaison with all other documents.

I don’t know if it’s possible to do it in one query ?