translating a small javascript expression to mongodb query [duplicate]

Question

Hi i'm trying to translate this javascript expression with mongo:

db.zipcodes.find( { $where: "69900002 >= obj.LOC_CEP_INI && 69900002 <= obj.LOC_CEP_FIM" } );

To a mongo query. I need that because the javascript is not performatic for query big data.

What i need is search objects where the field LOC_CEP_INI is bigger or equal to 69900002 and LOC_CEP_FIM is equal or smaller than LOC_CEP_INI Thanks!

OUTPUT Example (69900002 is bigger than LOC_CEP_INI and 69900002 is smaller than 69900002:

 {
"create_date": "2016-04-12T20:17:34.397Z",
 "__v": 0,
"UFE_SG": "AC",
"MUN_NU": "1200401",
"LOC_NU": "00000016",
"LOC_NO": "RIO BRANCO",
"LOC_CEP_INI": 69900001,
"LOC_CEP_FIM": 69923999,
"_id": "570d57de457405a61b183ac6"
}

@user3100115 i m trying to search objects where the field LOC_CEP_INI is bigger or equal to 69900002 and LOC_CEP_FIM is equal or smaller than LOC_CEP_INI — michelpm1
– michelpm1, Commented Apr 13, 2016 at 14:47
@michelpm1 How is it functionally any different though? The answers are the same for both. — JohnnyHK
– JohnnyHK, Commented Apr 13, 2016 at 15:09

Sede · Accepted Answer · 2016-04-13 14:59:22Z

2

You need to use the $lte and the $gte query operators to select those document where "LOC_CEP_INI" is lower than 69900002 and "LOC_CEP_FIM" is greater than 69900002.

db.zipcodes.find( {  
    "LOC_CEP_INI": { "$lte": 69900002 }, 
    "LOC_CEP_FIM": { "$gte": 69900002 } 
})

answered Apr 13, 2016 at 14:59

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

1 Comment

michelpm1 Over a year ago

Thanks it worked!!

Collectives™ on Stack Overflow

translating a small javascript expression to mongodb query [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related