Spring Data Mongo Query Field parameters

Question

I'm playing with Spring Data Mongo Query and wondering about the field property parameters. Here is the example that I got from the documentation:

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

The question is: What is the meaning of 1 in { 'firstname' : 1, 'lastname' : 1}?

score 3 · Accepted Answer · answered May 24 '13 at 16:15

3

1 means that both 'firstname' and 'lastname' will be included in the resulted document. For example, if you have 'salary' field you can exclude it from result by typing 'salary': 0.

answered May 24 '13 at 16:15

Ivan Sharamet

317
4
15

So, basically 1 = TRUE, 0 = FALSE? – Maksim May 24 '13 at 16:18
1 - include field in the result, 0 - exclude. Or, if you do not provide 'fields' falue, all document fields will be included. – Ivan Sharamet May 24 '13 at 16:23

score 1 · Answer 2 · answered Jan 30 '15 at 11:24

You can use MongoTemplate for querying.First you declare query and after that you can declare criteria.Below is an example :

Criteria criteria = Criteria.where("kademeler.isemriId").is(isemriNo)
                .and("ogag").is(1);
        Query query = new Query(criteria);
        query.fields().exclude("salary"); //for excluding a field, this is "salary" for you
        List<AboneAriza> result = mongoTemplate.find(query, AboneAriza.class);

score 0 · Answer 3 · answered Jan 21 '16 at 16:52

Just to add, the id of the document is also returned by default, so this in detail will mean, firstname, lastname along with _id of the document will be return, and as some one already answered setting a field to zero will not return that particular field when the document is being returned.

Spring Data Mongo Query Field parameters

3 Answers3

Linked