[SQL] GroupBy in MirkoORM

I have an Entity that looks like this:

@Entity({ tableName: 'certificates' })
@Unique({ properties: ['version', 'type'] })
export class CertificateEntity extends BaseEntity {
@Property({ type: 'float' })
version: number;

@Property()
name: string;

@Property()
type: CertificateType;

@Property()
description: string;
}


I am trying to get a list of the latest certificates by version for every type. So only the highest version of each type should appear.

I am running

const r = await this.em.createQueryBuilder(CertificateEntity)
.select(['type', 'version'])
.groupBy('type')
.execute();


But what I am getting is

{
"statusCode": 500,
"path": "/certificates/list",
"errorType": "error",
"errorMessage": "select \"c0\".\"type\", \"c0\".\"version\" from \"certificates\" as \"c0\" group by \"c0\".\"type\" - column \"c0.version\" must appear in the GROUP BY clause or be used in an aggregate function"
}


If I add the version as instructed by the error message. I just get the list

[
{
"version": 1.7,
"type": "s-type"
},
{
"version": 1.6,
"type": "s-type"
},
{
"version": 1.5,
"type": "s-type"
}
]


What am I doing wrong?

Continue reading...