Breaking News: Grepper is joining You.com. Read the official announcement!

mongodb filter subdocument

Salo Hopeless answered on February 10, 2023 Popularity 5/10 Helpfulness 6/10

answer mongodb filter subdocument

mongodb filter subdocument

Comment

// DATA:
[
	{
		"id":94726294,
		"name": "Working hours",
		"owner_id":16884548,
		"rules": [
			{"type":"wday","intervals":[{"from":"07:00","to":"23:45"}],"wday":"sunday"},
            {"type":"date","intervals":[{"from":"07:00","to":"23:45"}],"date":"2023-02-11"}
		]
		}
]
// Query
$ db.mentor_calendar.aggregate([
    { $match: {mentor_email: "eduardo@gmail.com" } },
    { $project: {
      "name": "hello",
        rules: {
          $filter: {
            input: "$rules",
            as: "item",
            cond: {
              $or: [
                {  $gte: ['$$item.date', "2023-02-10"] },
                {$eq: ['$$item.type', "wday"]}
              ]
            }
          }
        }
    } }
  ])

Popularity 5/10 Helpfulness 6/10 Language javascript

Source: Grepper

Tags: filter javascript mongodb subdocument

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

Salo Hopeless

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

mongodb filter subdocument

Contents

More Related Answers

mongodb filter subdocument

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.