MongoDB - Query on key name of an object
Renato Souza de Oliveira
I'm new to MongoDB. I'm using laravel-mongodb.
I have a document in tree structure. I need to get documents for a specific year. Here is the image of how my data is:
I need to select all documents that have the period 2017. my problem is that the period is a field of type object. And the value is the index. Does anyone know how I can do this?
whoami - fakeFaceTrueSoul
You can try below query :
db.collection.aggregate([
/** As we need to filter on key but not on key's value,
* So convert periodos object to an array which makes {k : 2017, v : value of 2017} etc.. */
{
$addFields: {
periodos: {
$objectToArray: "$periodos"
}
}
},
/** Filter docs to check periodos has 2017 */
{
$match: {
"periodos.k": "2017"
}
},
/** convert periodos array back to object to its original type */
{
$addFields: {
periodos: {
$arrayToObject: "$periodos"
}
}
}
])
Test : MongoDB-Playground
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
Query object within object
- 2
How to refer to each property of an object in an array of objects in MongoDB MapReduce JavaScript query?
- 3
Query in MongoDb for fetching record
- 4
Mongodb find query optimization
- 5
Use the value of a key as a key in mongodb aggregation
- 6
MongoDB object - PYTHON
- 7
How to pluck by key name matching?
- 8
How to get key name with AutoHotkey
- 9
Convert SQL Server Query to MongoDB Query @ Runtime
- 10
Parse include key in sub query
- 11
MongoDB spatial query on source and destination
- 12
MongoDB Aggregate Query Group by Dates
- 13
mongodb nested search query in java
- 14
MongoDb query not returning all the fields
- 15
MongoDb query not returning all the fields
- 16
MongoDB: find() query to select nothing
- 17
Check id of foreign key object
- 18
PHP: access object with key int
- 19
DataTable object initializer with Primary Key
- 20
Sorting array of object by specific key
- 21
How to access a key object in jQuery with "/"
- 22
TypeError : undefined는 개체가 아닙니다 ( 'row [OBJECT_COLUMN_NAME] = key'평가). 네이티브 반응
- 23
In Java is there a name for the object the method is called on?
- 24
Get an object property name as string
- 25
How to set the object name on json
- 26
sql dependency Invalid object name '
- 27
combine two keys to one key in mongodb
- 28
MongoDB 제한 mapReduce on index key
- 29
Does the name of the csr and private key file should match the domain name?
몇 마디 만하겠습니다