如何通过Spring Data MongoDB查询匹配条件的指定字段？

Hey there! The issue you're facing is that by default, Spring Data MongoDB returns all fields when you run a query. To only fetch the categoryName field, you need to add a projection to your Query object to explicitly specify which fields to include (or exclude).

Modified Code with Projection #

Here's how you can adjust your method to return only the categoryName field:

import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;

public ServiceList findOneByCategoryName(String categoryName) {
    Query query = new Query();
    query.addCriteria(Criteria.where("categoryName").is(categoryName));
    // Add projection to explicitly include only the categoryName field
    query.fields().include("categoryName");
    return mongoTemplate.findOne(query, ServiceList.class);
}

What This Does #

• The query.fields().include("categoryName") line tells MongoDB to only return the categoryName field in the query result.
• The other fields in your ServiceList class (like id and serviceTypes) will be set to null since they aren't included in the response from MongoDB.

Optional: Return Just the String Value (More Efficient) #

If you don't need the entire ServiceList object and only want the categoryName string, you can simplify the method for better efficiency:

public String findCategoryNameByCategoryName(String categoryName) {
    Query query = new Query();
    query.addCriteria(Criteria.where("categoryName").is(categoryName));
    query.fields().include("categoryName");
    
    ServiceList result = mongoTemplate.findOne(query, ServiceList.class);
    return result != null ? result.getCategoryName() : null;
    
    // Alternative approach to directly fetch the string value:
    // return mongoTemplate.findOne(query, String.class, "services");
}

Bonus: Exclude the Default _id Field #

MongoDB returns the _id field by default even if you don't include it in your projection. If you want to exclude it entirely, add this line to your query:

query.fields().exclude("_id");

内容的提问来源于stack exchange，提问作者Chaithanya RC