Spring Data MongoDB Repositories Query multiple fields

Question

Here is my document:

@Document(collection = "posts")
public class Post {
    @Id
    String id;
    String title;
    String description;
}

I'm trying to query for posts with title or description with a like operator. My Repository

public class PostsRepository extends MongoRepository<Post, String> {
    @Query(value = "{ $or: [ { 'title' : ?0 }, { 'description' : ?0 } ] }")
    Page<Post> queryByTitleOrDescription(String query, Pageable pageable);
}

How do i perform this query with LIKE on both fields with an or between them?

Oliver Drotbohm · Accepted Answer · 2015-10-11 11:02:22Z

12

You can even go without any explicit query declaration if needed:

interface PostRepository extends Repository<Post, String> {

  // A default query method needs parameters per criteria

  Page<Post> findByTitleLikeOrDescriptionLike(String title, 
                                              String description,
                                              Pageable pageable);

  // With a Java 8 default method you can lipstick the parameter binding 
  // to accept a single parameter only

  default Page<Post> findByTitleOrDescription(String candidate, Pageable pageable) {
    return findByTitleLikeOrDescriptionLike(candidate, candidate, pageable);
  }
}

answered Oct 11, 2015 at 11:02

Oliver Drotbohm

83.6k19 gold badges236 silver badges219 bronze badges

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

3 Comments

shayy Over a year ago

Is it using the regex by default and not performing a full text comparison?

Oliver Drotbohm Over a year ago

See docs.spring.io/spring-data/mongodb/docs/current/reference/html/…

shayy Over a year ago

Super! Thanks a bunch.

shayy · Accepted Answer · 2015-10-10 18:34:58Z

8

So to answer my own question, this is the solution I came up with, if someone knows something which is more performant I'd appreciate it (I believe text search is not applicable since it doesn't work with partial words)

@Query(value = "{ $or: [ { 'title' : {$regex:?0,$options:'i'} }, { 'description' : {$regex:?0,$options:'i'} } ] }")
    Page<Post> query(String query, Pageable page);
}

answered Oct 10, 2015 at 18:34

shayy

1,3123 gold badges17 silver badges28 bronze badges

Collectives™ on Stack Overflow

Spring Data MongoDB Repositories Query multiple fields

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related