mongodb find problem

Question

in user_history collection

user_name: john
eat : [{food:'apple', timestamp:123}, {food:'cheese', timestamp:80}]

user_name: paul
eat : [{food:'melon', timestamp:125}, {food:'bread', timestamp:60}]

user_name: mattew
eat : [{food:'water', timestamp:90}, {food:'pizza', timestamp:91}]

I need to get food which has timestamp over 100

my code:

db.user_history.find({"eat.timestamp":{$gte:100}},{"eat.food":1})

result:

{'_id': ObjectId('......'),'eat':[{food:'apple'},{food:'cheeza'}]},
{'_id': ObjectId('......'),'eat':[{food:'melon'},{food:'bread'}]}

result I want to get:

{'_id': ObjectId('......'), 'eat':{food:apple}},
{'_id': ObjectId('......'), 'eat':{food:melon}}

how could I get this?

Community · Accepted Answer · 2017-05-23 11:47:51Z

1

I dont think its possible,see the ticket: https://jira.mongodb.org/browse/SERVER-828. Looks like this question is already asked

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Jul 28, 2011 at 4:40

KaKa

1,56312 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

mongodb find problem

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related