Is there a way to specify a condition of eager loa...
# exposed
m
Is there a way to specify a condition of eager loading when using
with()
? For example, we have a field signifying a soft-deleted row: `deleted`; is there a way to specify that we don't want to eager-fetch rows whose
deleted = 't'
? or by giving expression with reference in Entity class. example
Copy code
object Users : UUIDTable("x") {
    val deleted: Column<Boolean> = bool("deleted").default(false)
    val teamId: Column<UUID> = reference("team_id", Teams)
}

class User(id: EntityID<UUID>) : UUIDEntity(id) {
    companion object : UUIDEntityClass<User>(Users)
   
    var deleted by Users.deleted
}

object Teams : UUIDTable("y") {
    val deleted: Column<Boolean> = bool("deleted").default(false)
}

class Team(id: EntityID<UUID>) : UUIDEntity(id) {
    companion object : UUIDEntityClass<Team>(Teams)

    var deleted by table.deleted
    val members by User referrersOn Users.teamId
}