Hey all, is the best way to return the value of a sum to create an aliased field and pass it into the query like so? Or can I just refer to the column in the

.get()

on the query via the

.sum()

method on the column? Here’s what I have right now:

val sumAlias = TransactionsTable.amount.sum().alias("campaignTotal")
TransactionsTable.slice(sumAlias)
    .select { TransactionsTable.campaignID eq campaignID }
    .limit(1)
    .firstOrNull()
    ?.get(sumAlias)

Pretty sure you can just do:

val sum = TransactionsTable.amount.sum()
TransactionsTable.slice(sumAlias)
    .select { TransactionsTable.campaignID eq campaignID }
    .limit(1)
    .firstOrNull()
    ?.get(sum)

Gotcha. The reason I was doing

.firstOrNull()?.get(sumAlias)

was because

.firstOrNull()

will return a

ResultRow?

so I need to retrieve the actual sum value. Thanks!