Build dynamic queries with Spring Data MongoDB Criteria

Question

I would like to run a bulk delete operation on a list of documents in MongoDB that have been selected by the user in the UI so I need to dynamically build a query that looks like the following (the or clause expands for every document selected):

{
    $and: [
        {
            "contentType": "application/vnd.sometype"
        },
        {
            $or: [
                {
                    "metadata.name": "someName",
                    "metadata.version": "someVersion"
                },
                {
                    "metadata.name": "someOtherName",
                    "metadata.version": "someOtherVersion"
                }
            ]
        }
    ]
},
Fields: null,
Sort: null

Just now I'm using string concatenation to achieve this.

Is it possible to build this query with the Spring Data MongoDB Criteria Builder (org.springframework.data.mongodb.core.query.Criteria)?

Artem Bilan · Accepted Answer · 2014-07-03 21:41:41Z

13

Doesn't this work for you?

Criteria criteria = Criteria.where("contentType").is("application/vnd.sometype");

List<Criteria> docCriterias = new ArrayList<Criteria>(docs.size());

for (Document doc: docs) {
    docCriterias.add(Criteria.where("metadata.name").is(doc.getName())
                               .and("metadata.version").is(doc.getVersion()));
}

criteria = criteria.orOperator(docCriterias.toArray(new Criteria[docs.size()]));

?

answered Jul 3, 2014 at 21:41

Artem Bilan

123k11 gold badges103 silver badges130 bronze badges

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

9 Comments

Ramzan Zafar Over a year ago

@Artem Bilan criteria.orOperator(docCriterias.toArray(new Criteria[docs.size()])); im getting issue while converting my Criteria list to an Array its keep saying that orOperator not defined for Criteria[]? can you plese help?

Artem Bilan Over a year ago

Please, check your Spring Data MongoDB version. Try to use the latest one.

Ramzan Zafar Over a year ago

I'm using 1.5.0.RELEASE

Ramzan Zafar Over a year ago

its keep saying The method orOperator(Criteria...) in the type Criteria is not applicable for the arguments (Criteria[])

Artem Bilan Over a year ago

Don't you use org.hibernate.Criteria by mistake?

|

Sandun Susantha · Accepted Answer · 2020-03-03 07:35:07Z

Here we need to build new query and embed the criteria to the built new query. And also, we have to create a list of criteria using some criteria for embed to the query. Here my example is providing a list of metadata and we don't know the name of parameter which will send for us. So, The solution is as given follow.

List<Criteria> criterias = new ArrayList<>();

    for (MetaData metaData : newDoc.getMetaData()) {
        Criteria dynamicCriteria = Criteria.where("metaData.key").is(metaData.getKey()).andOperator(Criteria.where("metaData.value").is(metaData.getValue()));
        criterias.add(dynamicCriteria);
    }

    Criteria criteria = new Criteria().andOperator(criterias.toArray(new Criteria[criterias.size()]));

    Query searchQuery = new Query(criteria);

    List<Document> documents = mongoTemplate.find(searchQuery, Document.class);

Collectives™ on Stack Overflow

Build dynamic queries with Spring Data MongoDB Criteria

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related