nosql - mongodb 多組資料不固定字段查詢問題 [百度黨請繞道]

Question

有以下查詢條件

let fiters = [{
    route: '/',
}, {
    name: 'admin1',
    route: '/1',
    routeGroup: '/admin'
}, {
    _id: {
        _str: '573aca9ce970eb6e9e543405'
    }
}, {
    routeGroup: '/admin'
}, {
    _id: {
        _str: '573c2b1e9161b32c35d76fde'
    },
    route: '/4'
}, {
    _id: {
        _str: '573ad1b5e970eb6e9e543407'
    },
    name: 'esdit'
}]

請問mongodb能不能一次查詢上述條件資料

Answer 1

使用$or表達式：{ $or: [ { }, { }, ... , { } ] }

db.test.find({$or:[{
    route: '/',
}, {
    name: 'admin1',
    route: '/1',
    routeGroup: '/admin'
}, {
    _id: {
        _str: '573aca9ce970eb6e9e543405'
    }
}, {
    routeGroup: '/admin'
}, {
    _id: {
        _str: '573c2b1e9161b32c35d76fde'
    },
    route: '/4'
}, {
    _id: {
        _str: '573ad1b5e970eb6e9e543407'
    },
    name: 'esdit'
}]})