Channels
#exposed
Title
# exposed
t
Tristan Caron
05/17/2018, 2:25 PMHello,
I'm trying to build a query for
select count(distinct my_column) from my_table where my_other_column = true Copy code
MyTable.select {
MyTable.myOtherColumn.eq(true)
}.withDistinct().count()I found this working
Copy code
MyTable
.slice(MyTable.myColumn.countDistinct())
.select {
MyTable.myOtherColumn.eq(true)
}.first()
.let {
it[MyTable.myColumn.countDistinct()]
}
`👍 1
t
tapac
05/17/2018, 3:40 PMyou even can write
first()[MyTable.myColumn.countDistinct()]let Copy code
MyTable.run {
slice(myColumn.countDistinct()).
select { myOtherColumn eq true }.
first()[myColumn.countDistinct()]
}t
Tristan Caron
05/18/2018, 6:04 AMThis is true 😀
159 Views