How to compare a field with the value of another field from a specific document

Working with Data
,
1

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 ?

2

I believe the $expr operator would work for this case.