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

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -