Nested Query In MongoDb Where Clause

Question

i'm quite new and i can't find any query that matches my output.

for ex, i have data look like:

{_id:1, 
  name:a,  
  "date" : {
    "request" : 2020-02-02,
    "validate" : 2021-02-02
}

i'm having a problem using a query to find a data with a request date exists and validate date null.

i tried following query, but it returns all null

db.testing.find({"date.validate" : {$exists:false} })

is there any condition that i can use to manipulate data like

SELECT * FROM testing WHERE request is not null and validate is null

Thanks

Abdullah Shoaib · Accepted Answer · 2021-02-22 05:24:10Z

1

For request date exists & validate date null:

db.testing.find({"date.validate" : null, "date.request" : {
        $exists : true 
    }   })

answered Feb 22, 2021 at 5:24

Abdullah Shoaib

2,0952 gold badges18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Yohanes Lim Over a year ago

Hi abdul, your solution works. i wonder how if i wanted to add name : {$ne : "A"} ? . i encountered error if i add it. thanks

Abdullah Shoaib Over a year ago

@YohanesLim db.testing.find({"date.validate" : null, "date.request" : { $exists : true },"name":{$ne:"a"}}) should work.

Yohanes Lim Over a year ago

is there any order in using exists and ne and other query operator?

Abdullah Shoaib Over a year ago

@YohanesLim For these simple queries, I haven't followed any order ever and my queries have returned desired results. Though I'm not aware if there's some order or priority for some other complex forms of queries.

Collectives™ on Stack Overflow

Nested Query In MongoDb Where Clause

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related