| Keyword |
Sample |
JPQL snippet |
| And |
findByLastnameAndFirstname |
where x.lastname = ?1 and x.firstname = ?2 |
| Or |
findByLastnameOrFirstname |
where x.lastname = ?1 or x.firstname = ?2 |
| Is, Equals |
findByFirstname
findByFirstnameIs
findByFirstnameEquals |
where x.firstname = ?1 |
| Between |
findByStartDateBetween |
where x.startDate between ?1 and ?2 |
| LessThan |
findByAgeLessThen |
where x.age < ?1 |
| LessThanEqual |
findByAge LessThanEqual |
where x.age <= ?1 |
| GreaterThen |
findByAgeGreaterThen |
where x.age > ?1 |
| GreaterThenEqual |
findByAgeGreaterThenEqual |
where x.age >= ?1 |
| After |
findByStartDateAfter |
where x.startDate > ?1 |
| Before |
findByStartDateBefore |
where x.startDate < ?1 |
| IsNull, Null, IsNotNull |
findByAge(Is)Null |
where x,age is null |
| NotNull |
findByAge(Is)NotNull |
where x,age is not null |
| LIke |
findByFirstnameLike |
where x.firstname like ?1 |
| NotLike |
findByFirstnameNotLike |
where x.firstname not like ?1 |
| StaringWith |
findByFirstnameStaringWith |
where x.firstname like ?1 (parameter bound with appended %) |
| EndingWith |
findByFirstnameEndingWith |
where x.firstname like ?1 (parameter bound with prepended%) |
| Containing |
findByFirstnameContaining |
where x.firstname like ?1 (parameter bound with wrapped
in %) |
| OrderBy |
findByFirstnameOrderByLastnameDesc |
where x.age = ?1 order by x.lastname desc |
| Not |
findByLastnameNot |
where x.lastname <> ?1 |
| in |
findByAgeln(Collection<Age> ages) |
where x.age in ?1 |
| Notln |
findByAgeNotln(Collection<Age> ages) |
where x.age not in ?1 |
| True |
findByActiveTrue() |
where x.active = true |
| False |
findByActiveFalse() |
where x.active = false |
| IgnoreCase |
findByFirstnameIgnoreCase |
where UPPER(x.firstname) = UPPER(?1) |