TypeORM: How to order by a relation field

Question

I have a Singer entity and a related Song entity

Singer entity

export class Singer {      @PrimaryGeneratedColumn()     id: number;      @Column()     name: string;      @OneToMany( type => Song, Song => Song.user )     songs: Song[];  } 

Song entity

export class Song {      @PrimaryGeneratedColumn()     id: number;      @Column()     name: string;      @ManyToOne( type => Singer, Singer => Singer.songs )     singer: Singer;  } 

I want to get all Songs ordered by Singer name

I searched the docs and GitHub issues but can't find an answer How can I solve this? better without QueryBuilder

Answer 1

I don't think it is currently supported by typeorm without the query builder, there is currently a feature request open

With the QueryBuilder it is quite simple though:

connection.createQueryBuilder(Song, 'songs')    .leftJoinAndSelect('songs.singer', 'singer')    .orderBy('singer.name', 'ASC')    .getMany(); 

Answer 2

I had the same issue i tried to order by custom column but without query builder because i was using Repository, this is my solution :

let res = await this.trackingRepository.findAndCount({       where: `username like '%${seachValue}%' or action like '%${seachValue}%' or ip like '%${seachValue}%'`,       order: {         [sortField]: sortOrder === "descend" ? 'DESC' : 'ASC',       },       skip: (current - 1) * pageSize,       take: pageSize,     });