Hello, I'm trying to build a query for `select count(distinct my_column) from my_table where my_othe...

# exposed

[Tristan Caron]

Hello,
I'm trying to build a query for select count(distinct my_column) from my_table where my_other_column = true

I have started the fellowing, but I don't know I can achieve what I would like

MyTable.select {
  MyTable.myOtherColumn.eq(true)
}.withDistinct().count()

Any ideas?

[Tristan Caron]

I found this working

MyTable
  .slice(MyTable.myColumn.countDistinct())
  .select {
    MyTable.myOtherColumn.eq(true)
  }.first()
  .let {
    it[MyTable.myColumn.countDistinct()]
  }
`

[tapac]

you even can write first()[MyTable.myColumn.countDistinct()] without let

[tapac]

MyTable.run {
    slice(myColumn.countDistinct()).
    select { myOtherColumn eq true }.
    first()[myColumn.countDistinct()]
}

[Tristan Caron]

This is true 😀