Using the Mongoose $or operator with a nested array in query conditions

Question

Using the Mongoose $or operator with a nested array in query conditions

Here are the schemas I am using:

//ProjectModel
const ProjectSchema: Schema = new Schema(
 owner: { type: Schema.Types.ObjectId, ref: "User" },
 users: [{type: Schema.Types.ObjectId, ref: "ProjectUser", unique: true }]
);

//Project User model
const ProjectUserSchema = new Schema(
  {
    user: { type: Schema.Types.ObjectId, ref: "User", require: true },
    role: {
      type: String,
      default: 'basic',
      enum: ["basic", "projectuser", "moderator", "admin"]
    },
    project: { type: Schema.Types.ObjectId, ref: "Project", require: true },
  },
  {
    timestamps: true,
    usePushEach: true,
  }
);

The User model contains fields such as password and name.

I am attempting to locate a User within a ProjectModel either as the owner (UserSchema) or among the users (ProjectUserSchema)

ProjectModel.findOne()
                    .or([{ owner: req.params.user }, { "users.user": req.params.user }])
                    .then(project => {
                        res.json(project);
                    });

However, this query is returning null. Even trying the condition

.or([{ owner: req.params.user }, { "users._id": "PROJECT USER ID" }])

does not yield results.

What steps should I take next?

javascript mongodb express mongoose mongodb-query

Answer 1

Answer №1

If you want to handle the incoming req.params.user as an ObjectId, you can perform a conversion. Below is an example of how you can achieve this:

const mongoose = require('mongoose');

const getProjectByUser = (req, res) => {
  let userId = mongoose.Types.ObjectId(req.params.user);

  ProjectModel
    .findOne({
      $or: [
        { "owner": userId },
        { "users": userId }
      ]
    })
    .then(project => {
      res.json(project);
    })
    .catch(e => {
      res.json({ error: "An error occurred!" });
    });
}

Answer 2

If you want to handle the incoming req.params.user as an ObjectId, you can perform a conversion. Below is an example of how you can achieve this:

const mongoose = require('mongoose');

const getProjectByUser = (req, res) => {
  let userId = mongoose.Types.ObjectId(req.params.user);

  ProjectModel
    .findOne({
      $or: [
        { "owner": userId },
        { "users": userId }
      ]
    })
    .then(project => {
      res.json(project);
    })
    .catch(e => {
      res.json({ error: "An error occurred!" });
    });
}

Using the Mongoose $or operator with a nested array in query conditions

Answer №1

Similar questions

Ways to display multiple PHP pages in a single division

Programmatically setting properties for elements

Steps to trigger a Bootstrap modal when the user clicks anywhere on the webpage

Exploring Jasmine's Powerful Spying and Mocking Capabilities in JavaScript Prototypes

[filepond] in order to enroll using the serverId value received from the server

Using Jquery's getJson method, we can easily fetch and retrieve the appropriate JSON string by

Run several asynchronous HTTP requests in the background within a Chrome extension

Tips for troubleshooting a node module that is part of a build process

ReactJS does not trigger a re-render when changes are made to CSS

Having all elements at the same height

What is the best way to access a cached value?

Detach an item from its parent once it has been added to an array

Utilizing Typescript for parsing large JSON files

Achieve maximum height with background images

Is it possible to alter the name of a slot before displaying the element in the shadowDOM, depending on the slot utilized in the DOM?

Retrieving Public ID from Cloudinary Link

Searching dynamically using class names with JQuery

Mastering the Art of Live Search in Drop Down Multi Select

Is it possible to switch the summernote editor between airmode and toolbar mode?

What steps should I take to delete a class from my calendar after it has reached the maximum capacity of 20