JOOQ empty condition

Question

Is there way to define empty condition which produces nothing in output sql query? Now, for default condition I use trueCondition()

private static Condition limitCondition(Integer offset, Integer count) {
    Condition limitCondition = trueCondition();
    if (count != null && offset != null) {
        limitCondition = rowNum.between(offset, count + offset);
    } else if (count == null && offset != null) {
        limitCondition = rowNum.greaterOrEqual(offset);
    } else if (count != null && offset == null) {
        limitCondition = rowNum.lessOrEqual(count);
    }
    return limitCondition;
}

Answer 1

There is DSL.noCondition() starting with jOOQ 3.11, which can act as an identity for both AND and OR operators, and doesn't produce any output unless strictly required (e.g. when projecting it in SELECT), in case of which it acts like DSL.trueCondition()

For more details, see:

• https://github.com/jOOQ/jOOQ/issues/6817
• https://blog.jooq.org/create-empty-optional-sql-clauses-with-jooq/