mongo query - SyntaxError: Unexpected token :

Question

I have a document in my collection.

"_id" : ObjectId("5755b94abcfc6666d6f5fe56"),
"NAME" : John Smith,
"PHONE" : "800-555-1000",
"DOC" : {
    " TYPE" : "M",
    " DATE" : "01/28/2016",
    " AMOUNT" : 281593
},
"ADDRESS" : 123 Sesame Street

I am trying to find this record by passing in the keys and values:

db.acris.find("DOC" : {" TYPE" : "MTGE"," DATE" : "01/28/2003"," AMOUNT" : 281593})

However, I am getting the following error:

SyntaxError: Unexpected token :

How can I fix this query so that the code will work?

Community · Accepted Answer · 2017-05-23 10:29:00Z

1

The syntax error is fixed as KRONWALLED answer shows. The query I think you want is however is:

db.acris.find({"DOC.TYPE" : "M", "DOC.DATE" : "01/28/2003"," DOC.AMOUNT" : 281593})

Notice the DOT notation for matching against subfields.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Jun 9, 2016 at 17:04

Chris Seymour

86.4k32 gold badges166 silver badges209 bronze badges

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

Comments

KRONWALLED · Accepted Answer · 2016-06-09 17:55:58Z

1

You're missing {} around the whole find like

db.collection.find({ "DOC" : ... })

Update: Just to be complete. You can also search for the whole element. You don't necessarily need dot notation.

> db.test.insertOne({"NAME" : "John Smith",
... "PHONE" : "800-555-1000",
... "DOC" : {
...     " TYPE" : "M",
...     " DATE" : "01/28/2016",
...     " AMOUNT" : 281593
... },
... "ADDRESS" : "123 Sesame Street"})

> db.test.find({"DOC" : { " TYPE" : "M", " DATE" : "01/28/2016", " AMOUNT" : 281593 }})
{ "_id" : ObjectId("5759a933cdcc5a8d09a1aeb9"), "NAME" : "John Smith", "PHONE" : "800-555-1000", "DOC" : { " TYPE" : "M", " DATE" : "01/28/2016", " AMOUNT" : 281593 }, "ADDRESS" : "123 Sesame Street" }

edited Jun 9, 2016 at 17:55

answered Jun 9, 2016 at 17:01

KRONWALLED

1,44211 silver badges12 bronze badges

Collectives™ on Stack Overflow

mongo query - SyntaxError: Unexpected token :

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related