mongoose - $regex within $project mongodb aggregation -


i have users collection has location field type string. want pass score field along document shows whether document's location similar text "austin". instance recorded location austin, texas, want matched austin. thought possible use $regex this.

i wrote aggregation:

$project: {   score: {     $cond:        if: {         $regex: {'$location': /austin/}       },       then: 1,       else: 0     }   },   location: 1,   firstname: 1,   lastname: 1 } 

but :

{     "name": "mongoerror",     "errmsg": "exception: invalid operator '$regex'",     "code": 15999,     "ok": 0 } 

use $substr instead:

{     "$project": {         "score": {             "$cond": [                 {                     "$eq": [                         {                             "$substr": [ "$location", 0, 6 ]                         },                         "austin"                     ]                 },                 1,                 0             ]         },         "location": 1,         "firstname": 1,         "lastname": 1     } } 

Comments

Popular posts from this blog

shopping cart - Page redirect not working PHP -

php - How to modify a menu to show sub-menus -

python - Installing PyDev in eclipse is failed -