返回顶部

获取班级信息

根据教室的Mid和语文的科目去获取:排课任务的id,语文课的学生的Mid,和班级的名称

db.SS_ArrangingResult.aggregate([
    {"$unwind":"$AlwaysSchedule"},
    {"$unwind":"$AlwaysSchedule.schedule"},
    {"$match":{"AlwaysSchedule.schedule.classroomMid":"59e6d09b705deb72706503c1","AlwaysSchedule.schedule.subject":"语文"}},
    {"$group":{_id:"$SS_Arranging_Mid","studentlist":{"$last":"$AlwaysSchedule.schedule.studentlist"},"className":{"$last":"$AlwaysSchedule.schedule.publicclass"}}}
])

bug

db.SS_ArrangingResult.aggregate([
//     {"$match":{"SS_Arranging_Mid":"5a055cc1705deb3b32d3bca6"}},
    {"$unwind":"$AlwaysSchedule"},
    {"$unwind":"$AlwaysSchedule.schedule"},
    {"$match":{"AlwaysSchedule.schedule.subject":"语文","AlwaysSchedule.schedule.classroomMid":"59e6d09b705deb72706503b0"}},
//     {"$group":{_id:"$SS_Arranging_Mid","studentlist":{"$last":"$AlwaysSchedule.schedule.studentlist"},"className":{"$last":"$AlwaysSchedule.schedule.publicclass"}}}
    
    ])

 

posted @ 2018-03-29 10:52  Crazymagic  阅读(65)  评论(0)    收藏  举报