|
Hi. everyone.
Query for a field in an object in array with Mongo?
i have this json and i want check if the value of sessions.id == 1234556:
{
|
"_id": ObjectId("5768e43"),
|
"APPID": {
|
"Number": 0,
|
},
|
sessions: [
|
{
|
id:1234556,
|
"setOID": {
|
"Number": 0
|
|
},
|
"custID": {
|
"Number": 0
|
},
|
},
|
{
|
id:133333,
|
"setOID": {
|
"Number": 2
|
},
|
"custID": {
|
"Number": 2
|
},
|
},
|
]
|
}
|
|
query = BCON_NEW ("$query", "{", "session.id", 1234556,"}");
|
cursor = mongoc_collection_find (collection, MONGOC_QUERY_NONE, 0, 0, 0, query, NULL, NULL);
|
|
the result is like this:
|
|
{
|
"_id": ObjectId("5768e43"),
|
"APPID": {
|
"Number": 0,
|
},
|
sessions: [
|
{
|
id:1234556,
|
"setOID": {
|
"Number": 0
|
|
},
|
"custID": {
|
"Number": 0
|
},
|
},
|
{
|
id:133333,
|
"setOID": {
|
"Number": 2
|
},
|
"custID": {
|
"Number": 2
|
},
|
},
|
]
|
}
|
|
but I want this result.
|
|
{
|
"_id": ObjectId("5768e43"),
|
"APPID": {
|
"Number": 0,
|
},
|
sessions: [
|
{
|
id:1234556,
|
"setOID": {
|
"Number": 0
|
|
},
|
"custID": {
|
"Number": 0
|
},
|
}
|
]
|
}
|
|