Question Details

No question body available.

Tags

java jooq r2dbc

Answers (1)

Accepted Answer Available
Accepted Answer
June 2, 2025 Score: 0 Rep: 223,772 Quality: High Completeness: 50%

Assuming the ADDRESSES.LINE1 and CITIES.NAME fields are non-nullable, you can just add more predicates:

  .where(
     LOCATIONS.NAME.likeIgnoreCase(query)
         .or(ADDRESSES.LINE1.likeIgnoreCase(query))
         .or(ADDRESSES.LINE1.isNull())
         .or(CITIES.NAME.likeIngoreCase(query))
         .or(CITIES.NAME.isNull())
  )

If the fields are nullable, then you might need to take this semantics into account as well.