How to use updateOption with arrayFilters in spring-data mongodb?

Question

I have a document as shown below in Mongodb:

Now, I want to go to a document based on specific "_id" and for that document, want to go to "schedule" list in which for the few specific dates (not only one date, but more than one), I want to update the status as "BOOKED".I went through this link, How to apply update using Filtered positional operator with arrayFilters but in MongoTemplate class, updateMulti method does NOT take the updateOption parameter. Can someone please help

Me out. really will be appreciated for any suggestion. Thanks.

Note: I am using spring-data version "2.0.3.RELEASE", MongoDB driver version is v3.6.4.

Below is a document:

{
      "_id": "x1",
      "timeZone": "America/Los_Angeles",
      "schedule": [
        {
          "Date": "2018-07-10T00:00:00.000Z",
          "status": "AVAILABLE"
        },
        {
          "Date": "2018-07-10T00:30:00.000Z",
          "status": "AVAILABLE"
        },
        {
          "Date": "2018-07-10T08:00:00.000Z",
          "status": "AVAILABLE"
        }
      ],
      "_class": "com.scheduler.persistance.model.Calendar"
    }

jemag · Accepted Answer · 2019-04-03 19:53:06Z

8

It will soon be available in spring-data-mongodb. See : https://github.com/spring-projects/spring-data-mongodb/pull/656

Using it will look like :

new Update()
.set("grades.$[element]", 100)
.filterArray(Criteria.where("element").gte(100));

In the meantime, you should be able to use it with their snapshot maven repository:

<dependency>
  <groupId>org.springframework.data</groupId>
  <artifactId>spring-data-mongodb</artifactId>
  <version>2.2.0.DATAMONGO-2215-SNAPSHOT</version>
</dependency>

<repository>
  <id>spring-libs-snapshot</id>
  <name>Spring Snapshot Repository</name>
  <url>https://repo.spring.io/libs-snapshot</url>
</repository>

answered Apr 3, 2019 at 19:53

jemag

1791 silver badge10 bronze badges

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

Comments

Ravi Gurijala · Accepted Answer · 2018-07-08 09:34:07Z

5

If there is no "updateOption" in spring-data, then we can use plain driver jar. I hope it will solve your problem.

MongoDatabase db = client.getDatabase("test");

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z');
format.setTimeZone("EST");

List<Date> dateList = Arrays.asList(new Date[]
                                {format.parse("2018-07-10T00:30:00.000Z")}
                               );

db.getCollection("test").updateMany(new Document("_id", "x1"),
        new Documen("$set", new Document("schedule.$[elem].status", "booked")),
        new UpdateOptions().arrayFilters(Arrays.asList(new Document[]
            {new Document("elem.Date", new Document("$in", dateList))}
        )));

answered Jul 8, 2018 at 9:34

Ravi Gurijala

512 bronze badges

1 Comment

Bhargav Choksi Over a year ago

Hi Ravi, I am more looking into the spring data solution. I appreciate your response. Thanks.

Suresh T · Accepted Answer · 2021-09-20 18:02:49Z

0

// Assuming your collection is based out of class by name Test.class

Query query = new Query();
query.addCriteria(Criteria.where("_id").is("someID");
Update update = new Update();
update.set("schedule.$[myRec].status", "BOOKED" );
update.filterArray("myRec.Date", dateValue);
FindAndModifyOptions options = new FindAndModifyOptions().returnNew(true);
mongoTemplate.findAndModify(query, update, options, Test.class);

answered Sep 20, 2021 at 18:02

Suresh T

671 silver badge4 bronze badges

Collectives™ on Stack Overflow

How to use updateOption with arrayFilters in spring-data mongodb?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related