Filter by userId-CodePudding

I need to filter a list of posts and a list comments by userId. Am passing the userId params as postCreator and commentCreator. What am I doing wrong?

//data type for comments 
const commentSchema = new mongoose.Schema(
    {comment: {
      type: String,
      required: [true, "comment can not be empty"],
    },
    createdAt: {
      type: Date,
      default: Date.now(),
    },
    vote: {
      type: Number,
      default: 1,
    },
    commentCreator: {
      type: mongoose.Schema.ObjectId,
      ref: "User",
      required: [true, "comment must belong to a user."],
    },
    postCommentedOn: {
      type: mongoose.Schema.ObjectId,
      ref: "Post",
      required: [true, "a comment must belong to a post"],
    }, } )
 
 //data type for post is
    
    const postSchema = new mongoose.Schema(
  {
    postContent: {
      type: String,
      required: [true, "Post Content cannot be empty"],
    },
    postTitle: {
      type: String,
      required: [true, "Post Title cannot be empty"],
    },
    vote: {
      type: Number,
      default: 1,
    },
    createdAt: {
      type: Date,
      default: Date.now(),
    },
    postCreator: {
      type: mongoose.Schema.ObjectId,
      ref: "User",
      required: [true, "a post must belong to a user."],
    },
    image: {
      type: String,
    },
  },)

I need to filter a list of posts and a list comments by userId. Am passing the userId params as postCreator and commentCreator. What am I doing wrong?

let filter = {};
if (req.params.postId || req.params.userId)
  filter = {
    postCommentedOn: req.params.postId,
    postCreator: req.params.userId,
    commentCreator: req.params.userId,
  };

CodePudding user response：

From the data type, I can see postCommentedOn, postCreator, commentCreator are of type ObjectID meanwhile, req.params are received in string format. So you need to convert them to ObjectId to be used in the filter.

Something like the below code should help.

const mongoose = require('mongoose');
const ObjectId = mongoose.Types.ObjectId;
 filter = {
    postCommentedOn: ObjectId(req.params.postId),
    postCreator: ObjectId(req.params.userId),
    commentCreator: ObjectId(req.params.userId),
  }

CodePudding user response：

I just asked your question to the OpenAI JavaScript Codex. It returned a result which I don't know if it really works or not. But I want to see if this actually works or not.

/* I need to filter a list of posts and a list comments by userId. Am passing the userId params as postCreator and commentCreator */
var posts = [
  {
    id: 1,
    title: 'Post 1',
    body: 'Post 1 body',
    userId: 1
  },
  {
    id: 2,
    title: 'Post 2',
    body: 'Post 2 body',
    userId: 2
  },
  {
    id: 3,
    title: 'Post 3',
    body: 'Post 3 body',
    userId: 1
  }
];
var comments = [
  {
    id: 1,
    body: 'Comment 1',
    userId: 1
  },
  {
    id: 2,
    body: 'Comment 2',
    userId: 2
  },
  {
    id: 3,
    body: 'Comment 3',
    userId: 1
  }
];
var postCreator = 1;
var commentCreator = 1;
var filteredPosts = posts.filter(function(post) {
  return post.userId === postCreator;
});
var filteredComments = comments.filter(function(comment) {
  return comment.userId === commentCreator;
});
console.log(filteredPosts);
console.log(filteredComments);

Please forgive me if this doesn't work. And if it does let me know. Thanks.