Please add LeftOpenBetween, RightOpenBetween and OpenBetween as supported query keywords [DATACMNS-1488]

[spring-projects-issues]

teclxl opened DATACMNS-1488 and commented

LeftOpenBetween, RightOpenBetween, and OpenBetween respectively represent the three conditions of left-open and right-closed interval, left-closed and right-open interval, and both open interval. They are as supplements to Between which represent the condition of closed interval. The JPQL like this:

• findByDateLeftOpenBetween, … where x.date > ?1 and x.date <= ?2
• findByDateRightOpenBetween, … where x.date >= ?1 and x.date < ?2
• findByDateOpenBetween , … where x.date > ?1 and x.date < ?2

I know this is not the standard usage of JPQL or even SQL, but the three conditions are often used, and the method name is too long when combined use LessThan, LessThanEqual, GreaterThan, and GreaterThanEqual(E.g findByOpTimeGreaterThanEqualAndOpTimeLessThan)

---

Issue Links:

• DATAJPA-1511 Add support for derived 'between' queries using Range

• DATAMONGO-2072 Add support for derived 'between' queries using Range

[spring-projects-issues]

Oliver Drotbohm commented

We're in the progress of adding support for Range as parameter for Between queries. That allows clients to define which kind of boundary mapping is desired