Typeorm: How to order by a relation field

typescript typeorm
Budget picture Budget · Sep 10, 2019 · Viewed 17k times · Source

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

Software Person picture Software Person · Sep 12, 2019

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();

Related questions

TypeError: Class extends value undefined is not a function or null

I am getting the following error when trying to create these entities. TypeError: Class extends value undefined is not a function or null I am assuming this has something to do with circular dependencies, but how is that supposed to …

Read More
TypeORM upsert - create if not exist

Does TypeORM include some functionnality to avoid this : let contraption = await thingRepository.findOne({ name : "Contraption" }); if(!contraption) // Create if not exist { let newThing = new Thing(); newThing.name = "Contraption" await thingRepository.save(newThing); contraption = newThing; } Something like : let contraption = await thingRepository.…

Read More
What’s the difference between remove and delete?

For example, I have a TypeORM entity Profile: @Entity() class Profile { @PrimaryGeneratedColumn() id: number; @Column() gender: string; @Column() photo: string; @OneToOne(type => User, { cascade: true }) @JoinColumn() user: User; } And I’m not sure which one should I use to …

Read More