Spring Data MongoDB: search like on multiple fields

Question

I have a MongoDB collection containing User objects with two fields: Firstname and Lastname. I need a query that takes only one string (representing the user fullname) for a findLike research.

The problem is the same of this question but I do not know how translate that query for a MongoDB Repository in Spring Data using MongoTemplate or @Query annotation

EDIT: Using project operator i have to specify all fields I want include in the stages. A better solution maybe could be use AddFields operator: A similar question I found is that: https://stackoverflow.com/a/40812293/6545142

How can I use the $AddFields operator with MongoTemplate?

What is your mongo version ? You can check running db.version() in shell. — s7vr
– s7vr, Commented Feb 2, 2018 at 15:55

s7vr · Accepted Answer · 2018-02-02 16:18:59Z

4

You can use $expr ( 3.6 mongo version operator ) to use aggregation functions in regular query for only exact matches.

Spring @Query code

@Query("{$expr:{$eq:[{$concat:["$Firstname","$Lastname"]}, ?0]}}")
ReturnType MethodName(ArgType arg);

For find like searches or exact search you've to use aggregation via mongo template in lower versions.

AggregationOperation project = Aggregation.project().and(StringOperators.Concat.valueOf("Firstname").concatValueOf("Lastname")).as("newField");

for like matches

AggregationOperation match = Aggregation.match(Criteria.where("newField").regex(val));

for exact match

AggregationOperation match = Aggregation.match(Criteria.where("newField").is(val));

Rest of the code

 Aggregation aggregation = Aggregation.newAggregation(project, match);
 List<BasicDBObject> basicDBObject =  mongoTemplate.aggregate(aggregation, colname, BasicDBObject.class).getMappedResults();

answered Feb 2, 2018 at 16:18

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

5 Comments

Emanuele Vannacci Over a year ago

It works but returns me an object with all attributes set on null, only the Id is set...

s7vr Over a year ago

Add all the fields in the project stage that you need to keep in the response. Something like project("field1", "field2"). Change to your pojo class from BasicDBObject for mapping

Emanuele Vannacci Over a year ago

My pojo class has really many attributes, and adding all the fields in the project stage is not very nice. I found a better solution with $addFields operator instead of project. My query looks like: {$addFields: {'newField': {$concat:["$field1"," ","$field2"]} } }, {$match: {'newField':'value'}} . How can I use it with MongoTemplate?

s7vr Over a year ago

I wanted to suggest that but there is no helper for addFields just yet and wanted to know what your requirement was. So just need to use AggregationOperation to create a new stage. Here is such example.

Emanuele Vannacci Over a year ago

Thank you! Through AggregationOperation I create the addFileds operator, and now it works properly

Collectives™ on Stack Overflow

Spring Data MongoDB: search like on multiple fields

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related