Query MongoDB, replacing one specific field with regex

Question

If I have a collection defined as,

const userSchema = new mongoose.Schema({
  username: {
    type: String,
    required: true
  },
  password: {
    type: String,
    required: true
  },

How can I query for all documents, but replace every password into asterisks?

Something like,

const users = await User.find({
  password: password.replace(/./gi, '*');
})

Is this possible?

Ashh · Accepted Answer · 2020-02-11 11:05:39Z

3

You cannot do this with find() query as it is only used to retrieve data instead can use aggregate for this with a $addFields stage.

const users = await User.aggregate([
  { "$addFields": {
    "password": {
      "$reduce": {
        "input": { "$range": [0, { "$strLenCP": "$password" }] },
        "initialValue": "",
        "in": {
          "$concat": [
            "*",
            "$$value"
          ]
        }
      }
    }
  }}
])

console.log({ users })

MongoPlayground

edited Feb 11, 2020 at 11:05

answered Feb 11, 2020 at 10:47

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

3 Comments

Mike K Over a year ago

Is there a way to avoid hardcoding the asterisks and know exactly the length of password?

Ashh Over a year ago

You want the asterisk as per password's length?

Mike K Over a year ago

Yes, without sending a hardcoded value of *********** to the front end.

Collectives™ on Stack Overflow

Query MongoDB, replacing one specific field with regex

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related