Auto-complete : do a middle search

MongoDB Atlas Atlas Search
,
1

Hello ,
I would like to introduce in the query field the like system as in the sql to be able to search for a telephone number starting with the middle example: +3367854456
my search is done like this: 67854456 without the telephone code
do you have any idea how to do it please?
Cordially.

2

Hi,

You can use $regex operator:

db.collection.find({
  "phone": {
    "$regex": "67854456"
  }
})

Working example

3

Hi NeNad ,

Thanx for your response but unfortunately I avoid the regex because it slows down the call to the api I would rather something like this :

{
   autocomplete: {
       query: `%${phoneSearch}%`,
       path: 'phone',
   },
},

if it exists ?

Cordialy

4

the response of my question → https://www.mongodb.com/docs/atlas/atlas-search/define-field-mappings/#std-label-bson-data-types-autocomplete

5

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.