Class JRSqlBetweenClause

  • All Implemented Interfaces:
    JRClauseFunction

    public class JRSqlBetweenClause
    extends SQLBetweenBaseClause
    Base BETWEEN clause function for SQL queries.

    The purpose of this clause function is to find that a given value can be found in a given A...B interval.

    The first token in the $X{...} syntax is the function ID token. Possible values for the BETWEEN clause function ID token are:

    • BETWEEN - in this case the A...B interval will be considered open: (A,B)
    • [BETWEEN - in this case the A...B interval will be considered right-open: [A,B)
    • BETWEEN] - in this case the A...B interval will be considered left-open: (A,B]
    • [BETWEEN] - in this case the A...B interval will be considered closed: [A,B]

    Author:
    Sanda Zaharia (shertage@users.sourceforge.net)