maybe I am blind, but I cannot create this where c...

# exposed

[Goetz Markgraf]

maybe I am blind, but I cannot create this where condition:

WHERE id = <some value> AND (type = 0 OR type is null)

I tried:

.select { id eq <some value> }
.andWhere { (type eq 0) or (type.isNull() }

However, the last statement gives an error:

Type mismatch.
Required: Op<Boolean>
Found:    Unit

Can anyone help please?

Thank you very much

[Dominik Sandjaja]

Can you try

.select { id eq <someValue> }
.andWhere { Op.Build { (type eq 0) or (type.isNull()) } }

?

[Goetz Markgraf]

Thank you, that worked. Interestingly, when I remove the Op.build again, the error was gone.

Maybe, IntelliJ imported a wrong or function.

Now the following code is fine:

.select { id eq <somevalue> }
.andWhere { (type eq 0) or (type.isNull()) }