how to extend jpa order

Question

I search table with Criteria Query and filter it with name field. i filter records that have name like %user-entered-name%.
then sort result with name column. now i have a problem. i will it sort like following:

name (First list records that his name is equal to user entered name)
name* (Second list records that his name starts with user entered name)
*name* (In the last list records that hist name contains user entered name)

is there any solution for it in jpa.

thanks alot.

Maciej Dobrowolski · Accepted Answer · 2014-07-23T13:25:07.143

1

One solution is to retrieve additional column called relevance using CASE WHEN statement. It could be defined as following:

c.multiselect(employee.get("name"),
    cb.selectCase()
    .when(cb.equal(employee.get("name"), "user-defined-name"), 3)
    .when(cb.like(employee.get("name"), "user-defined-name%"), 2)
    .when(cb.like(employee.get("name"), "%user-defined-name%"), 1)
    .otherwise(0)
    .alias("relevance"))

edited Jul 23 '14 at 13:25

answered Jul 23 '14 at 10:53

Maciej Dobrowolski

11,561
5
45
67

thanks for reply. but how can i set order by on this query. the second column of returned result doesn't have name. – Rasoul Taheri Jul 23 '14 at 13:15

how to extend jpa order

1 Answers1