Mongodb create index for boolean and integer fields

Viewed 26

user collection

[{
        deleted: false,
        otp: 3435,
        number: '+919737624720',
        email: 'Test@gmail.com',
        name: 'Test child name',
        coin: 2
    },
    {
        deleted: false,
        otp: 5659,
        number: '+917406732496',
        email: 'anand.satyan@gmail.com',
        name: 'Nivaan',
        coin: 0
    }
    ]

I am using below command to create index Looks like for string it is working But i am not sure this is correct for number and boolean field.

db.users.createIndex({name:"text", email: "text", coin: 1, deleted: 1})

I am using this command to filter data:

db.users.find({$text:{$search:"anand.satya"}}).pretty()
db.users.find({$text:{$search:"test"}}).pretty()
db.users.find({$text:{$search:2}}).pretty()
db.users.find({$text:{$search:false}}).pretty()

string related fields working. But numeric and boolean fields are not working. Please check how i will create index for them

0 Answers
Related