var result=db.day_air.aggregate([
{$match:{"$and":[{"data_time":{"$gte":ISODate('2021-02-01 00:00:00')}},{"data_time":{"$lte":ISODate('2021-03-31 23:59:59')}}]}}, //前置过滤器
{$unwind:"$values"}, //拆分子集数据
{$match:{"values.pollutant_code":"S01"}}, //后置过滤器
{ $project: { //字段处理
"_id": "$_id",
"mp_id": "$mp_id",
"mn":"$mn",
"data_time":"$data_time",
"pullutant_code":"$values.pollutant_code",
"rtd_value":"$values.rtd_value"
}}
])
while(result.hasNext()){ //游标循环插入临时表
db.temp.insert(result.next());
}