Spring Data JPA: Query for Field in List of Objects

Question

I'm looking for the correct method name to find all Documents with a given Target's type:

public class Document {

    @Indexed(name = "targets")
    private List<Target> targets;

    public class Target {
        private String value;
        private String type;
    }
}

Unfortunately, all of the following method names aren't working:

List<Document> findByTargetType(...);
List<Document> findByTargetsTargetType(...);
List<Document> findByTargetsContainsTargetType(...);
List<Document> findByTargetsContainsTargetTargetType(...);
List<Document> findByTargetsContainingTargetType(...);
List<Document> findByTargetsContainingTargetTargetType(...);

So which is the correct method name to accomplish the desired feature?

Is this about spring-data-jpa or spring-data-mongodb? Please remove the other tag. — Jens Schauder
– Jens Schauder, Commented Aug 16, 2017 at 5:21
@JensSchauder thank's for pointing that out. It's about the naming conventions we have to follow in order to avoid writing queries for JPA or Mongo-Repositories, so it applies to both. How would you suggest to tag it? — user3105453
– user3105453, Commented Aug 17, 2017 at 9:07

s7vr · Accepted Answer · 2017-08-15 12:40:55Z

7

You can try below query.

Using @Query annotation

@Query("{ 'targets.type' : ?0 }")
List<Document> findByTargetsType(String type);

Or

Using repository supported keywords

List<Document> findByTargetsType(String type);

answered Aug 15, 2017 at 12:40

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

1 Comment

user3105453 Over a year ago

findByTargetsType(String type) is what I was looking it. Thank you.

Collectives™ on Stack Overflow

Spring Data JPA: Query for Field in List of Objects

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related