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

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

shopping cart - Page redirect not working PHP -

python - Installing PyDev in eclipse is failed -