mongodb use where and custom function to query mongodb預存程序

標籤：

function name regexObjSubObjKey

function code 

function(proto,value) {    var match=false;     var reg = new RegExp(‘.*‘+value);        print(JSON.stringify(this.obj));    print(this[‘arr_‘+proto]);    for(var key in this.obj[‘arr_‘+proto]){          print(key);        if(key!=‘count‘&&key!=‘isgame‘){             match = reg.test(key);            if(match){                return true;            }        }    }    return false;}

query demo

精簡

db.test.find({$where:"regexObjSubObjKey(‘qq‘,‘1234567‘)"})

標準

db.test.find({$and:[{arr_qq:{$exists:true}},{$where:"regexObjSubObjKey(‘qq‘,‘1234567‘)"}]})

 

資料內容

{    "_id": "7654321",    "arr_qq": {        "1234567": {            "count": 8        },        "abcdefg": {            "count": 8        },        "count": 16    }}

mongodb use where and custom function to query mongodb預存程序