Index | Keyword | Sample | JPQL snippet |
1 | And | findByLastnameAndFirstname | … where x.lastname = ?1 and x.firstname = ?2 |
2 | Or | findByLastnameOrFirstname | … where x.lastname = ?1 or x.firstname = ?2 |
3 | Is,Equals | findByFirstnameIs,findByFirstnameEquals | … where x.firstname = ?1 |
4 | Between | findByStartDateBetween | … where x.startDate between ?1 and ?2 |
5 | LessThan | findByAgeLessThan | … where x.age < ?1 |
6 | LessThanEqual | findByAgeLessThanEqual | … where x.age ⇐ ?1 |
7 | GreaterThan | findByAgeGreaterThan | … where x.age > ?1 |
8 | GreaterThanEqual | findByAgeGreaterThanEqual | … where x.age >= ?1 |
9 | After | findByStartDateAfter | … where x.startDate > ?1 |
10 | Before | findByStartDateBefore | … where x.startDate < ?1 |
11 | IsNull | findByAgeIsNull | … where x.age is null |
12 | IsNotNull,NotNull | findByAge(Is)NotNull | … where x.age not null |
13 | Like | findByFirstnameLike | … where x.firstname like ?1 |
14 | NotLike | findByFirstnameNotLike | … where x.firstname not like ?1 |
15 | StartingWith | findByFirstnameStartingWith | … where x.firstname like ?1 (parameter bound with appended %) |
16 | EndingWith | findByFirstnameEndingWith | … where x.firstname like ?1 (parameter bound with prepended %) |
17 | Containing | findByFirstnameContaining | … where x.firstname like ?1 (parameter bound wrapped in %) |
18 | OrderBy | findByAgeOrderByLastnameDesc | … where x.age = ?1 order by x.lastname desc |
19 | Not | findByLastnameNot | … where x.lastname <> ?1 |
20 | In | findByAgeIn(Collection ages) | … where x.age in ?1 |
21 | NotIn | findByAgeNotIn(Collection age) | … where x.age not in ?1 |
22 | TRUE | findByActiveTrue() | … where x.active = true |
23 | FALSE | findByActiveFalse() | … where x.active = false |
24 | IgnoreCase | findByFirstnameIgnoreCase | … where UPPER(x.firstame) = UPPER(?1) |