[DELTASPIKE-1222] Allow query by example method expression wtih @Query annotation

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Data-Module
• Labels: features
• Assignee: Unassigned
• Reporter: Richard Juso
• Created: 11/Nov/16 14:46
• Updated: 08/Oct/19 08:46

Description

ability to either override findBy/findAll methods with @Query annotation (without using params or using params, but also allowing the E example pattern) or add support for custom method expression that could be used for this purpose. the E example would only appy to the main Entity restrictions, the additional params could apply to nested entities based on param index

ie. @Query(value = "select r from Range r where r.customId IN (select e.customId from EbsUserStub e)")
public abstract List<Range> findBy(Range paramE, SingularAttribute<Range, ?> paramArrayOfSingularAttribute);

or

@Query(value = "select r from Range r where r.customId IN (select e.customId from EbsUserStub e)")
public abstract List<Range> findUsing(Range paramE, SingularAttribute<Range, ?> paramArrayOfSingularAttribute);

or

@Query(value = "select r from Range r where r.customId IN (select e.customId from EbsUserStub e where e.miscField = ?2)")
public abstract List<Range> findByMiscField(Range paramE, SingularAttribute<Range, ?> paramArrayOfSingularAttribute, String miscField);

method expression could either be custom ie. findUsing, findByEntityName, findByMiscField or some other marker.