spring data mongodb @Query with exclude option

Question

Using spring data mongo repository class, how do we declare a method to return the documents with few fields excluded? Spring data reference document shows 'include' fields mechanism but not exclude. Code from spring documentation:

public interface PersonRepository extends MongoRepository<Person, String>

  @Query(value="{ 'firstname' : ?0 }", fields="{ 'firstname' : 1, 'lastname' : 1}")
  List<Person> findByThePersonsFirstname(String firstname);

}

I need a mechanism to specify the fields to be excluded? Is this supported for repository methods?

suman j · Accepted Answer · 2014-03-25 19:55:01Z

6

specify the fields value as 0. Ex:

public interface PersonRepository extends MongoRepository<Person, String>

  @Query(value="{ 'firstname' : ?0 }", fields="{ 'firstname' : 0}")
  List<Person> findByThePersonsFirstname(String firstname);

}

This will not fetch firstname property of the document and value will be null in returned java object.

answered Mar 25, 2014 at 19:55

suman j

7,00012 gold badges62 silver badges118 bronze badges

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

1 Comment

arxakoulini Over a year ago

how then can you tell the difference between included field that has null value vs excluded field?

xick · Accepted Answer · 2016-06-09 14:58:26Z

0

Add an empty filter criteria for findAll query:

public interface PersonRepository extends MongoRepository<Person, String> {
    @Query(value = "{}", fields = "{ 'firstname' : 0 }")
    List<Person> findAll(Sort sort);
}

answered Jun 9, 2016 at 14:58

xick

315 bronze badges

Collectives™ on Stack Overflow

spring data mongodb @Query with exclude option

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related