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

Error occurred due to an invalid element type with the imported React component

Steps for adding a row as the penultimate row in a table

How can you use React.js to only display "Loading..." on the page while the full name is included in the URL?

Can two Angular element components be utilized simultaneously on a single page in Angular 6?

Organize an array based on its ratio

Empty body detected in Jquery AJAX request with Django REST running in a Docker environment

Obtaining the body from a post request in Node.js: A step-by-step guide

Is there a problem with renaming files using the multer module's filename options?

Tips for aligning two objects side by side in HTML

Is it possible to mimic a ref attribute with jest/rtl within a functional component?

Is it feasible to choose the component generated by this element?

Using Dropzone.js to bypass the Browse dialog when uploading files in integration tests with php-webdriver

Tips for presenting JSON data retrieved using jQueryWould you like to know how

Tips for refining a list to only include items that contain every element from a specified array

a tutorial on linking component data to a prop value

Attempting to single out various entities within a JSON array through the use of radio buttons

An AJAX script for dynamically adding, modifying, and removing records from a database

Performing XML API Requests with Node.js

Deleting multiple subdocuments and their related subdocuments with Mongoose

When incorporating @babel/standalone, a JavaScript memory limit is exceeded