Querying mongodb

Question

I have a collection of emails in MongoDB with a field containing an array of json.

How can knowing the sender and the receiver, how can I find all the emails exchanged between the two people ? I need to do something like

db.email.find({"from": [email protected]", "tos":"[email protected]")

but I cant find the right way to write this query :(

> db.emails.findOne() { "from" : { "real_name" : "it", "address" : "[email protected]" }, "tos" : [ { "real_name" : null, "address" : "[email protected]" } ], }

anhlc · Accepted Answer · 2014-11-27 21:56:30Z

4

Use "from.address" and "tos.address":

db.emails.find({"from.address" : "[email protected]", "tos.address" : "[email protected]"})

answered Nov 27, 2014 at 21:56

anhlc

14.6k4 gold badges38 silver badges42 bronze badges

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

1 Comment

Tug Grall Over a year ago

Quick link to the documentation : docs.mongodb.org/manual/reference/method/db.collection.find/…

Romain Jouin · Accepted Answer · 2014-11-27 21:57:09Z

Each field is considered as a json, we can precise the expected value through a "." :

db.emails.find({"tos.address" : "[email protected]", "from.address":"[email protected]"})

Nathan Tuggy · Accepted Answer · 2017-07-01 05:57:35Z

From and To are objects and data inside them can be accessed through a . operator. So the query will be:

db.emails.find({"from.address" : "[email protected]", "tos.address" : "[email protected]"}).

Collectives™ on Stack Overflow

Querying mongodb

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related