1966420
我有四张表 一张表是Category存放网站的目录分类以及子目录 一张表是Intro是介绍模块,存放属于介绍模块的分类及数据 一张表是News是新闻模块,存放属于新闻模块的分类及数据 一张表是Product是产品模块,存放属于产品模块的分类及数据
var CategorySchema = new mongoose.Schema({
key:String,
catname:String,
subcategories:[{
key:String,
catname:String,
module:String
}]
});
var cateList=[{
key:"about",
catname:"走进企业",
subcategories:[{
key:"about",
catname:"企业概况",
module:"intro"
},{
key:"ideal",
catname:"企业理想",
module:"intro"
},{
key:"honour",
catname:"企业荣誉",
module:"intro"
}]
},{
key:"news",
catname:"动态资讯",
subcategories:[{
key:"news",
catname:"企业动态",
module:"news"
},{
key:"industry-info",
catname:"行业资讯",
module:"news"
},{
key:"new-arrival",
catname:"新品上市",
module:"product"
}]
}];
假设已经通过cateList把数据填充进去了 请问如何筛选出Category中分别属于intro模块、news模块、product的分类? 如果单纯的find像这样会把整条数据中一个符合的就会返回
Category.find({'subcategories.module':'news'}).exec(function(err,docs){
if(err) return callback(err);
if(docs){
callback(null,docs);
}
});
我希望返回的结果就只有模块为news的Subcategories
{
key:"news",
catname:"企业动态",
module:"news"
},{
key:"industry-info",
catname:"行业资讯",
module:"news"
}
对mongoose操作还不熟悉,查阅了资料是要用到populate?还是aggregate? 可能描述上还不是很清楚,但是真心求大神帮助