Like this
{
"_id": 1,
"array": [
{"name": "a", "price": "2","amount":1},
{"name": "b", "price": "2","amount":2},
{"name": "c", "price": "3","amount":4}
]
}
I just want to export the name attribute and price attribute. What should I do? It seems impossible to realize with mongoexport. do you have any good methods? Ask for advice
Mongo supports js scripts and can batch process and export data using javascript scripts:
#! /usr/bin/env mongo db = db.getSiblingDB(db_name) // db.auth("user", "passwd"); result = {}; db.clt_name.find().forEach(function(r) { //here is the callback function, r is each record, is an object object, can traverse r.array, store the required attributes in result }) for (var key in result) { //Output in the format you want: print(key + "\t" + result[key]) }
Functions that can be used in the mongo environment are shown inWrite Scripts for the mongo Shell