How to query a collection using count of a field in mongoDB using mongoose?

Question

I have been trying to query the Document of posts. The query for the collection is as follows.

db.getCollection('posts').find({ isActive: true, inappropriateReports: { '$exists': true, '$gt': { '$size': 0 } }})

I am able to get the desired results but the issue is as soon as I add the date filter for the query it starts returning the empty array as a response

db.getCollection('tribe-posts').find({ isActive: true,
  createdAt: {
    '$gte': '2021-06-01T00:00:00.000Z',
    '$lte': '2021-07-07T00:00:00.000Z'
  },
  inappropriateReports: { '$exists': true, '$gt': { '$size': 0 } }})

How do I solve this issue as well as have a null check for the collections that doesn't have "inappropriateReports" field?

Thanks in advance

Tushar Shahi · Accepted Answer · 2021-07-08 05:29:37Z

2

Assuming you are checking in tribe-posts, try this:

db.getCollection('tribe-posts').find({ isActive: true,
  createdAt: {
    '$gte': new Date('2021-06-01T00:00:00.000Z'),
    '$lte': new Date('2021-07-07T00:00:00.000Z')
  },
  inappropriateReports: { '$exists': true, '$gt': { '$size': 0 } }})

I think passing date as a string will not work.

answered Jul 8, 2021 at 5:29

Tushar Shahi

21.6k2 gold badges25 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

How to query a collection using count of a field in mongoDB using mongoose?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related