Update Specific fields in a document record using MONGODB

Question

I am new to mongodb.So in sql to update the specific fields the query is

In sql::

update students set marks = 95, grade = 'A' where _id = '1234';

In mongo shell ::

db.students.update({_id:'1234'},{"$set":{"marks":95,"grade":'A'}},{multi:false});

Using mongotemplate , how can we acheive this. I have tried using the following code for single field update and it is working.

String uniqueId = student.getSection() + "#" + student.getRollNo();
    Query query = new Query();
    query.addCriteria(Criteria.where("_id").is(uniqueId));
    Update update = Update.update("marks", student.getMarks());
    logger.info("[Updating the Student marks using the id=]["+uniqueId+"]");
    UpdateResult result =  mongoTemplate.updateFirst(query, update, Student.class);

But how we acheive to update grade also using mongo templete?
Note :: I want to update specific fields in the document , not replacing the entire document

Valijon · Accepted Answer · 2021-12-18 12:19:30Z

1

Call .set(key, value)

Update update = Update.update("marks", student.getMarks()).set("grade", student.getGrade());

//Alternative
Update update = new Update().set("marks", student.getMarks()).set("grade", student.getGrade());

answered Dec 18, 2021 at 12:19

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

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

2 Comments

user11790395 Over a year ago

Hi @Valijon, thanks for the answer. It is working. But if i want to update the multiple fields without disturbing the existing fields, how can i acheive through pojo object ?. Is there any function like( saveorUPDATE like present in hibernate) ?

Valijon Over a year ago

@user11790395 Give an example please

Collectives™ on Stack Overflow

Update Specific fields in a document record using MONGODB

1 Answer 1

Call .set(key, value)

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Call .set(key, value)

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related