Repositories: Let Create Query by Example with Projection [DATAJPA-1162]

[spring-projects-issues]

Sébastien Laoût opened DATAJPA-1162 and commented

Given this interface:

/** Projection of any entity with a Long id field. */
public interface LongIdProjection {
    Long getId();
}

And this example entity:

public class My {
    public Long id;
    public String veryLongAndBoringString;
}

I'd like to create this automatically-generated query:

@Repository
public interface MyRepository extends JpaRepository<My, Long> {
    List<LongIdProjection> findAllIds(Example<My> example);
}

Unfortunately, I get this exception:

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property findAllIds found for type My!

Could be cool to enable creating custom queries by examples that return a subset of properties of an entity, so we don't ask the database to return a lot of potentially big fields if we are only interested in one or two fields

---

Affects: 1.11.6 (Ingalls SR6)

1 votes, 2 watchers

[mp911de]

Fixed via #2294 (fluent query API for Query by Example)