我尝试在基于Spring 4.1.1.RELEASE和Hibernate 4.2.16.Final的Java应用程序中实现分页。但是现在我想按sql函数值排序,例如:ORDER BY CHAR_LENGTH(name)。当我在@org.springframework.data.jpa.repository.Query中输入这样的子句时,它可以完美地工作,例如:
public class MyRepository {当我将:ORDER BY CHAR_LENGTH(name)作为属性传递给
name of: com.example.domain.OwnerEntity... order by ownerEntity.name ascnew PageRequest(0, 3, Sort.Direction.ASC, "childEntities.name");
它工作时没有错误,但我不想将排序<
00 IST 2015' AND 'Wed Dec 16 00:00:00 IST 2015' ORDER BY date_created ASC OFFSET 5 LIMIT 10;
PageRequest request = new PageRequest(1, 10, Sort.Direction.ASC, date_created