CODEWITHSUNDEEP
javasqlconditional-statementsjooq
Jef Jedrison
Jef Jedrison

Reputation: 303

How to combine Conditions in jOOQ

I have a list of conditions:

List<Condition> conditions = ...;

What is the easiest way to and-combine (or or-combine) these conditions into a new condition?

Condition condition = and(conditions);

Does JOOQ have a utility function for this? I agree it is easy to write, but I would rather not re-invent the wheel.

Upvotes: 6

Views: 5515

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 221315

jOOQ 3.6+ solution.

You can simply write:

Condition condition = DSL.and(conditions);

Prior to jOOQ 3.6:

Before this was implemented in jOOQ 3.6 (#3904) you had to resort to writing your own method:

static Condition and(Collection<? extends Condition> conditions) {
    Condition result = DSL.trueCondition();

    for (Condition condition : conditions)
        result = result.and(condition);

    return result;
}

Upvotes: 20

Related Questions