A comprehensive guide on extracting matching date from MongoDB with Mongoose

Question

A comprehensive guide on extracting matching date from MongoDB with Mongoose

I'm currently facing an issue with returning the appropriate records for a given date query in MongoDB and Mongoose. Despite my efforts, all rows are being returned instead.

Below, you'll find the relevant code snippet as well as the model schema. Please note that the "todaydate" field is of type Date.

MongoDB Data:

{ 
_id:ObjectId("5edd1df67b272e2d4cf36f70"),
pname:"Test 1",
category:"Choco 1",
todaydate:2020-06-01T18:30:00.000+00:00
},
{ 
_id:ObjectId("5gdd1df67b272e2d4cf36f72"),
pname:"Test 2", 
category:"Choco 3",
todaydate: 2020-06-02T18:30:00.000+00:00
},
{ 
_id:ObjectId("5kdd1df67b272e2d4cf36f74"),
pname:"Test 5", 
category:"Choco 6",
todaydate: 2020-05-01T18:30:00.000+00:00
},
{ 
_id:ObjectId("5ewd1df67b272e2d4cf36f75"),
pname:"Test 6", 
category:"Choco 8",
todaydate: 2020-06-03T18:30:00.000+00:00
}

data.model.js:

const mongoose = require('mongoose'); 
var userSchemaDate = new mongoose.Schema({ 
    pname: {
        type: String
    },  
    category: {
        type: String
    },  
    todaydate: {
        type: Date
    }   
}, {
    versionKey: false,
    collection: 'data'
}); 

module.exports = mongoose.model('Data', userSchemaDate);

data.controller.js:

module.exports.getReportTableData = (req, res, next) => {
    var collection = req.query.collection;  
    let tabledata = dbc.model(collection);  
    let reportPar = new Date("2020-06-03"); //yyyy-mm-dd
        tabledata.find({
            todaydate: {
                $gte: reportPar
            }
        }, function(err, docs) {
            if (err) {
                console.log(err);
                return;
            } else {
                console.log("Successfully loaded data");
                res.json({ data: docs, msg: 'Data loaded.' });
            }
        }); 
     }

node.js mongodb mongoose mongodb-query

Answer 1

Answer №1

Upon examining your example, I couldn't identify any issues that appear to be problematic, assuming the synchronization of your system clocks is accurate.

Here's a code snippet provided for comparison purposes:

mongoose.connect(`mongodb://localhost/tests`, {useNewUrlParser: true, useUnifiedTopology: true, autoIndex: false});
const db = mongoose.connection;

db.on('error', (err) => {
    console.error(err);
});

db.once('open', async () => {
    // Clear the table
    const collections = await db.db.collections();
    if (collections.map(c => c.s.namespace.collection).includes('datetests')) {
        await db.db.collection('datetests').drop();
    }

    // Define schema
    const schema = new Schema(
        {
            todaydate: {
                type: Date,
                required: true
            }
        },
        {
            versionKey: false,
            timestamps: false
        }
    );

    const Test = mongoose.model('datetest', schema);

    // Insert dates for a week
    let start = new Date('2020-06-02');
    for(let i = 0; i < 7; i++) {
        const date = new Date(start.valueOf());
        date.setDate(start.getDate() + i);

        await Test.create({
            todaydate: date
        });
    }

    let result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-02')
        }
    }).exec();

    assert.ok(result.length === 1);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-03')
        }
    }).exec();

    assert.ok(result.length === 2);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-05')
        }
    }).exec();

    assert.ok(result.length === 4);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-08')
        }
    }).exec();

    assert.ok(result.length === 7);
});

Answer 2

Upon examining your example, I couldn't identify any issues that appear to be problematic, assuming the synchronization of your system clocks is accurate.

Here's a code snippet provided for comparison purposes:

mongoose.connect(`mongodb://localhost/tests`, {useNewUrlParser: true, useUnifiedTopology: true, autoIndex: false});
const db = mongoose.connection;

db.on('error', (err) => {
    console.error(err);
});

db.once('open', async () => {
    // Clear the table
    const collections = await db.db.collections();
    if (collections.map(c => c.s.namespace.collection).includes('datetests')) {
        await db.db.collection('datetests').drop();
    }

    // Define schema
    const schema = new Schema(
        {
            todaydate: {
                type: Date,
                required: true
            }
        },
        {
            versionKey: false,
            timestamps: false
        }
    );

    const Test = mongoose.model('datetest', schema);

    // Insert dates for a week
    let start = new Date('2020-06-02');
    for(let i = 0; i < 7; i++) {
        const date = new Date(start.valueOf());
        date.setDate(start.getDate() + i);

        await Test.create({
            todaydate: date
        });
    }

    let result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-02')
        }
    }).exec();

    assert.ok(result.length === 1);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-03')
        }
    }).exec();

    assert.ok(result.length === 2);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-05')
        }
    }).exec();

    assert.ok(result.length === 4);

    result = await Test.find({
        todaydate: {
            $gte: new Date('2020-06-02'), $lte: new Date('2020-06-08')
        }
    }).exec();

    assert.ok(result.length === 7);
});

A comprehensive guide on extracting matching date from MongoDB with Mongoose

Answer №1

Similar questions

Is there a Nuxt/Vue glitch causing the server to be called multiple times on a single route or page?

The response from the nodejs request.body function is showing an empty object as

Yaml file validation encountered an issue with Swagger specifications

The outcome of AES encryption varies when comparing Node JS with C# programming languages

Retrieving CSS style values with Node.js

The Express server automatically shuts down following the completion of 5 GET requests

What is the reason for not opening the ndb debugger in the package.json file?

I'm trying to figure out which one is the correct term on Ubuntu - is it "node" or "nodejs"? And

Ways to resolve the issue "Module Not Found Error: Cannot locate module './src/bot/index'"

What could be causing the array value at index[i] within the for loop to be undefined?

Tips for transferring a file to PocketBase using NodeJs

What is the proper way to specifically define a new property on the `global` object in TypeScript?

MongoDB virtual fields failing to populate in Mongoose

Using Socket.IO in Node.js to distribute information to every connected client

Error messages encountered following the latest update to the subsequent project

Is there a way to retrieve just the array element as the output instead of the entire object in MongoDB?

Need to install Node.js in order to install n and then install Node.js again?

Auto-refresh the page upon any updates made to the MongoDB collection

Modify entry if present, otherwise insert in a node/express application

Managing JSON data retrieval and manipulation with REST API in Node.js and MongoDB