Get a query with string mongoose

Asked Apr 22 '16 at 11:21

Active Apr 22 '16 at 11:59

Viewed 427 times

    "_id" : ObjectId("5713af5e39dd161a0c546501"),
    "year" : "1949",
    "_created_at" : ISODate("2016-04-17T15:44:30.221Z"),
    "_updated_at" : ISODate("2016-04-17T15:44:30.221Z"),
    "date" : "10.1" // 10 is day 1 is the month

I have my collection called quotes with the structure above.

In the express app I want to get all the data for each month. I tried this but it didn't work:

mongoose.model('quotes').find({ date: { $search : id  } },function (err, quotes) {
    if (err) {
      return console.error(err);
    } else {
      //respond to both HTML and JSON. JSON responses require 'Accept: application/json;' in the Request Header
      res.send(quotes);
    }
});

id here is the month; like, if it is 1 that means it is January. I get no response back when executing the code.

Thanks for your help

edited Apr 22 '16 at 11:59

asked Apr 22 '16 at 11:21

Özgür Ersil

6,909
3
19
29

Possible duplicate of [MongoDB/Mongoose querying at a specific date?](http://stackoverflow.com/questions/11973304/mongodb-mongoose-querying-at-a-specific-date) – SlashmanX Apr 22 '16 at 11:24
in this example it is a date object but i have a string date – Özgür Ersil Apr 22 '16 at 11:25
`"date" : "10.1"` it is a `string` – Özgür Ersil Apr 22 '16 at 11:26
Sorry, my fault, I thought you were querying the `_created_at`. Misread it – SlashmanX Apr 22 '16 at 11:26
Try this: mongoose.model('quotes').find({ "day" : new RegExp("^"+ id + ".*", "i") },function (err, quotes) { – Hiren S. Apr 22 '16 at 11:37

Get a query with string mongoose

0 Answers0