https://kotlinlang.org logo
#exposed
Title
# exposed
h

Hakon Grotte

11/08/2023, 9:19 AM
Does Select Exists clause work for MSSQL in Exposed? Mssql does not support using EXISTS() directly in select clause, and it must be wrapped in case statement (SO-post) . However, it seems that Exposed's case().When(..) does not support the
Exists
class returned from the
exists()
function. Example use case: I have Person table and PersonReview table with fk to Person table. I want to select all people and include a bit/bool value if the individual persons have a review or not.