I want to get the distinct production names sorted by the fi | Exposed

Docs

Join the conversation Join Slack

Channels

# 100daysofcode

# 100daysofkotlin

# 100daysofkotlin-2021

# android-architecture

# android-databinding

# android-studio

# androidgithubprojects

# androidthings

# androidx

# androidx-xprocessing

# cincinnati-user-group

# codemash-precompiler

# competitive-programming

# compose-ui-showcase

# compose-wear

# compose-web

# connect-audit-events

# cscenter-course-2016

# domain-driven-design

# event21-community-content

# github-actions-kotlin-dsl

# java-to-kotlin-refactoring

# jvm-ir-backend-feedback

# kotest-contributors

# kotlin-data-storage

# kotlingforbeginners

# kotlinultimatechallenge

# leedskotlinusergroup

# lets-have-fun

# libgdx

# libkgd

# library-development

# machinelearningbawas

# myndocs-oauth2-server

# navigation-architecture-component

# practical-functional-programming

# proguard

# prozis-android-backup

# pyhsikal

# python

# python-contributors

# refactoring-to-kotlin

# russian-kotlinasfirst

# skia-wasm-interop-temp

# stayhungrystayfoolish

# swagger-gradle-codegen

# tricity-kotlin-user-group

Channels

danielm

4 years ago

I want to get the distinct production names sorted by the first performance date for a given organization. But the code returns all production rows.

tapac

4 years ago

You have to use grouping operation, not distinct.

.slice(Production.name)
.select { Organization.id eq organizationId }
.groupBy(Production.name)
.orderBy(Performance.date.min())

View count: 1

Join thread in Slack