Mongo regex query for field in list of embedded objects

Question

i'm have a collection with records like this

> db.company.findOne({companyId:1})
{
"_id" : ObjectId("4e22ff08eefdd839f60ab95f"),
"lastUpdate" : ISODate("2011-07-11T17:00:00Z"),
"errorCount" : 0,
"house" : 49,
"phones" : [
    {
        "cityCode" : "3852",
        "number" : "461423",
        "type" : "phone"
    },
    {
        "cityCode" : "3852",
        "number" : "461317",
        "type" : "phone"
    }
],
"houseAdd" : "",
"rubricsId" : [
    NumberLong(184108177),
    NumberLong(184108175)
],
"companyId" : NumberLong(1)
}

now i'm try to find all companies with phone number start with 8-800 i'm try to search my query

db.company.find({"phones.number":/8-800.*/}

and get an empty list. But

db.company.find({"phones.number":/8.*/})

return all companies which phone numbers starts with eight. AFAIK '-' isn't a special char for regex in this context? I'm try regex '8\-800' with same result. Where's i'm wrong?

did you try escaping the dash (8\-800.*)? Maybe the mongo regex engine doesn't like dashes even if they are outside [] — Gabi Purcaru
– Gabi Purcaru, Commented Jul 24, 2011 at 8:35
Thanks for fixing the quotes. What happens if you use /8.800.*/? Are you sure that you have phones.number values that contain "8-800"? — mu is too short
– mu is too short, Commented Jul 24, 2011 at 8:51
@mu is too short - Thnx for good answer in any way! with /8.800.*/ i'm get an empty result :(. Yes, i'm know a companyId with phone 8-800-2000-245 and can see it with findOne by companyId — Alexey Sviridov
– Alexey Sviridov, Commented Jul 24, 2011 at 8:52

Community · Accepted Answer · 2017-05-23 12:11:55Z

2

Maybe you have some funny Unicode in your data, just because it looks like a hyphen doesn't mean that it is a hyphen. You could try finding the entry you're looking for with findOne and then running the data through a hex dumper to see if it really is a plain ASCII hyphen or some Unicode thing that looks like a hyphen. If this is the case, then loosen up your search pattern to something like /^8\W+800/ and tweak it until it finds exactly what you're looking for.

BTW, you're not the first person to come across tricky Unicode:

String is not equal to itself

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Jul 24, 2011 at 8:39

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Qtax · Accepted Answer · 2011-07-24 13:12:58Z

1

Another possible solution:

/^\D*8\D*800/

^ make sure that this is at the start of the string
\D* any number of non-decimal characters, matches whatever you got between 8 and 800 (except numbers).

The first \D* might not be needed if you know that all those strings start with numbers and not anything else.

edited Jul 24, 2011 at 13:12

answered Jul 24, 2011 at 13:06

Qtax

34k9 gold badges92 silver badges127 bronze badges

Collectives™ on Stack Overflow

Mongo regex query for field in list of embedded objects

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related