[mongodb-dev] MONGODB QUERY

[Glenn Karl Guiyab]

I have this schema


"db_order" :{
"_id" : "",
"order_code" : "",
"rec_timestamp" : "",
"order_status" : "",
"order_cost" : "",
"order_content" : [
{
"employee" : "",
"food_list" : [],
"total_price": ""
}
]
},

how can I access the data inside the order content? for example I have two
dictionaries inside the order_content. I have this input and pseudo code:
Input :
order_code
employee
food

1. Check for records where order code is and assign it to record 1
2. Check if record1 != None
3. Iterate each dictionary inside the content. Check if record1's record
content.employee has the employee input.
4.If step3 = True: Push input food to the record inside chosen record
inside the order_content.

Man Im stuck with this all day. Hope you can help me.