Integer value partial search in aggregate MongoDB

Akshay A 0
Viewed 21
  const result = await locationModel.aggregate(
          [
            {$match : {uid : Number(uid), nid: {$regex:listing_id}}},
            {$sort : {[order_by]:order=='desc'?-1:1}},
            {$skip : skip},
            {$limit : pagelimit}
          ])

Here I have used regex method for partial search, but regex method only filter the string, but I need to filter out integer value. Please help me to do this.

aggregation aggregation-framework mongodb
1 Answers
  
const result = await locationModel.aggregate(
          [
            {$match : {uid : Number(uid), '$expr': {'$regexMatch': {
            'input': { '$toString': { '$toLong': "$nid" } },
            'regex': listing_id
          }
        }}},
            {$sort : {[order_by]:order=='desc'?-1:1}},
            {$skip : skip},
            {$limit : pagelimit}
          ])
Akshay A0
Related