[DELTASPIKE-709] New features for Query Expressions

• Type: Improvement
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Data-Module
• Assignee: Daniel Cunha
• Reporter: Juliano Marques
• Created: 07/Sep/14 19:58
• Updated: 13/Mar/17 09:15

Description

It will be nice if query expressions has the following features:

Support aggregate functions. Examples:

Long countByName(String name);
Long countDistinctByName(String name);
Double sumPriceByCategory(Category category);
BigDecimal avgPriceByCategory(Category category);

Support remove expressions. Examples:

void removeByName(String name);
void removeById(Long id);

Support TOP and FIRST. Examples:

void findTop10ByName(String name);
void findFirst10ByName(String name);

Support GROUP BY and HAVING clauses. Examples:

List<Product> findByNameGroupByName(String name);
List<Product> findByNameGroupByNameHavingNameLike(String name);

Sub-Tasks

• Support remove expressions: Closed
• Support aggregate functions: Open
• Support TOP and FIRST: Closed
• Support GROUP BY and HAVING clauses: Open