Hi all, I got an expression like ```transaction { Restaurants.slice(Restaurants.followers.min(),...

# exposed

[Timur Atakishiev]

Hi all, I got an expression like

transaction {
    Restaurants.slice(Restaurants.followers.min(),Restaurants.id)
            .selectAll()
            .groupBy(Restaurants.id)
            .first()
}

and I have a simple mapper

private fun toRestaurantUserName(row: ResultRow) = RestaurantUserNameDto(
        id = row[Restaurants.id],
        numberOfFollowers = row[Restaurants.followers.min()]!!
)

my question is when I want to fetch Restaurants.followers.min(), should I use

row[Restaurants.followers.min()]!!

these one with double !!, or is it better way to write the code?Thank you

[tapac]

It depends on you data.
For example, if your followers column is nullable and you will run such query then you can get null as a result.
Also, if you will call min() on a column which comes from a left join table you will face the same null value in a result row.

[Timur Atakishiev]

Got you, thank you very much