Evan R.
09/03/2019, 5:06 PM.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)
spand
09/04/2019, 8:36 AMval sum = TransactionsTable.amount.sum()
TransactionsTable.slice(sumAlias)
.select { TransactionsTable.campaignID eq campaignID }
.limit(1)
.firstOrNull()
?.get(sum)
.limit(1)
and you can do .first()
insteadEvan R.
09/04/2019, 5:15 PM.firstOrNull()?.get(sumAlias)
was because .firstOrNull()
will return a ResultRow?
so I need to retrieve the actual sum value. Thanks!