Update operation adds in a new array instead of adding array elements

Question

My controller:

@RequestMapping(value = "/{id}/giveFacilitiesAccess", method = RequestMethod.POST)
    public Object giveFacilityAccessToAnotherUser(@PathVariable("id") String userId)
    {
        return userService.giveFacilitiesAccessToAnotherUser(userId);
    }

My service:

@Override
    public Object giveFacilitiesAccessToAnotherUser(String id)
    {
        String userId = getLoggedInUserId();
        User u = userDao.findById(userId);
        List<String> facilitiesAccess = u.getFacilitiesAccess();
        return userDao.giveFacilitiesAccessToAnotherUser(id,facilitiesAccess);

    }

My dao:

@Override
    public Object giveFacilitiesAccessToAnotherUser(String userId, List<String>facilitiesAccess)
    {
        Query query = new Query();
        query.addCriteria(Criteria.where("id").is(userId));
        Update update = new Update().addToSet("facilitiesAccess.",facilitiesAccess);
        mongoTemplate.updateFirst(query, update, User.class);
        return null;
    }

After updating: "facilitiesAccess":["5f0996f792691d1b68671da3",["5f0998ba92691d1b68671da4"]]

It's updating like array inside another array, but i need in this format:
"facilitiesAccess":["5f0996f792691d1b68671da3","5f0998ba92691d1b68671da4"]

prasad_ · Accepted Answer · 2020-07-17 13:59:29Z

1

The update works with the syntax using the addToSet(String key) which returns a Update.AddToSetBuilder - then apply the each(Object... values) method on the builder, to return the Update object.

Update update = new Update().addToSet("facilitiesAccess").each(facilitiesAccess);

answered Jul 17, 2020 at 13:59

prasad_

14.4k2 gold badges27 silver badges44 bronze badges

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

1 Comment

Manoj Obbilisetty Over a year ago

Thnaks now it is adding in array

Rahul Kumar · Accepted Answer · 2020-07-17 12:09:53Z

0

You need to use Each like below

    @Override
    public Object giveFacilitiesAccessToAnotherUser(String userId, List<String>facilitiesAccess)
    {
        Query query = new Query();
        query.addCriteria(Criteria.where("id").is(userId));
        Update update = new Update().addToSet("facilitiesAccess.",new Each(facilitiesAccess));
        mongoTemplate.updateFirst(query, update, User.class);
        return null;
    }

answered Jul 17, 2020 at 12:09

Rahul Kumar

3721 silver badge7 bronze badges

1 Comment

Manoj Obbilisetty Over a year ago

no, its still showing an error. not working suggest me any another

Collectives™ on Stack Overflow

Update operation adds in a new array instead of adding array elements

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related