blocks|key|1288332|text|在TypeORM版本0.3.0中，您可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1288333|repository.find({
++++order:+{
++++++++singer:+{
++++++++++++name:+"ASC"
++++++++}
++++}
})|code-block|syntax|javascript|1288334|在0.3.0版之前(原始响应)|1288335|我认为没有查询生成器的typeorm目前不支持它，目前有一个特征请求打开|offset|length|1288336|但是，对于QueryBuilder，它非常简单：|1288337|connection.createQueryBuilder(Song,+'songs')
+++.leftJoinAndSelect('songs.singer',+'singer')
+++.orderBy('singer.name',+'ASC')
+++.getMany();|1288338|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/typeorm/typeorm/issues/2620^0|0|0|0|U|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@$K|12|L|13|1|14]]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

As of TypeORM version 0.3.0 you can do the following:
<pre class="lang-js prettyprint-override"><code>repository.find({
 order: {
 singer: {
 name: &quot;ASC&quot;
 }
 }
})
</code></pre>
<h1>Before version 0.3.0 (original response)</h1>
I don't think it is currently supported by typeorm without the query builder, there is currently a <a href="https://github.com/typeorm/typeorm/issues/2620" rel="nofollow noreferrer">feature request</a> open
With the QueryBuilder it is quite simple though:
<pre><code>connection.createQueryBuilder(Song, 'songs')
 .leftJoinAndSelect('songs.singer', 'singer')
 .orderBy('singer.name', 'ASC')
 .getMany();
</code></pre>

blocks|key|1288435|text|我的问题与我试图按自定义列订购的问题相同，但没有查询生成器，因为我使用的是Repository，这是我的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1288436|let+res+=+await+this.trackingRepository.findAndCount({
++++++where:+[{+username+:+Like(`%25${searchValue}%25`)+},
++++++++++++++{+action+:+Like(`%25${searchValue}%25`)+},
++++++++++++++{+ip+:+Like(`%25${searchValue}%25`)+}],
++++++order:+{
++++++++[sortField]:+sortOrder+===+"descend"+?+'DESC'+:+'ASC',
++++++},
++++++skip:+(current+-+1)+*+pageSize,
++++++take:+pageSize,
++++});|code-block|syntax|javascript|1288437|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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 :
<pre><code>let res = await this.trackingRepository.findAndCount({
 where: [{ username : Like(`%${searchValue}%`) },
 { action : Like(`%${searchValue}%`) },
 { ip : Like(`%${searchValue}%`) }],
 order: {
 [sortField]: sortOrder === &quot;descend&quot; ? 'DESC' : 'ASC',
 },
 skip: (current - 1) * pageSize,
 take: pageSize,
 });
</code></pre>

blocks|key|1288491|text|这在TypeORM+0.3.0中是支持的|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1288492|songRepository.find({
++++order:+{
++++++++singer:+{
++++++++++++name:+"ASC"
++++++++}
++++}
})|code-block|syntax|javascript|1288493|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/typeorm/typeorm/blob/master/CHANGELOG.md#030-2022-03-17^0|2|D|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

This is supported as of <a href="https://github.com/typeorm/typeorm/blob/master/CHANGELOG.md#030-2022-03-17" rel="noreferrer">TypeORM 0.3.0</a>:
<pre><code>songRepository.find({
 order: {
 singer: {
 name: &quot;ASC&quot;
 }
 }
})
</code></pre>

blocks|key|2728604|text|尝试实体模型上的默认顺序|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2728605|https://github.com/typeorm/typeorm/blob/master/sample/sample30-default-order-by/entity/Post.ts|offset|length|2728606|@Entity("sample30_post",+{
++++orderBy:+{
++++++++title:+"ASC",
++++++++id:+"DESC"
++++}
})
export+class+Post+{

++++@PrimaryGeneratedColumn()
++++id:+number;

++++@Column()
++++title:+string;

}|code-block|syntax|javascript|2728607|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2M|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

Try the default order on the entity model
<a href="https://github.com/typeorm/typeorm/blob/master/sample/sample30-default-order-by/entity/Post.ts" rel="noreferrer">https://github.com/typeorm/typeorm/blob/master/sample/sample30-default-order-by/entity/Post.ts</a>
<pre><code>@Entity(&quot;sample30_post&quot;, {
 orderBy: {
 title: &quot;ASC&quot;,
 id: &quot;DESC&quot;
 }
})
export class Post {

 @PrimaryGeneratedColumn()
 id: number;

 @Column()
 title: string;

}
</code></pre>

blocks|key|2728522|text|如果您愿意在内存中排序，则不必使用查询生成器。(小心：，这意味着先获取所有数据集，然后在节点服务器上进行筛选)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2728523|为此，您可以将任务委托给像房客这样的库。这样，您仍然可以使用EntityManager或Repository查询数据。|CODE|2728524|//+first+fetch+the+song+and+include+(=join)+the
//+singer+by+the+foreign+key+"singer"
var+queryResult+=+await+this.entityManager.find(Song,+{
++relations:+['singer'],
});

//+then+use+a+library+like+lodash+to+do+the+ordering
const+songsSortedBySinger+=+_.orderBy(queryResult,+song+=>+song.singer.name);|code-block|syntax|javascript|2728525|请进一步阅读：|2728526|relations查找选项是记录在这里。|unordered-list-item|2728527|orderBy是记录在这里。|2728528|entityMap|0|LINK|mutability|MUTABLE|url|https://lodash.com/|1|https://github.com/typeorm/typeorm/blob/master/docs/find-options.md#basic-options|2|https://lodash.com/docs/4.17.15#orderBy^0|B|B|O|3|0|U|D|18|A|D|2|0|0|0|0|0|9|E|5|1|0|8|5|2|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]|$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1B|8|@$9|1C|A|1D|B|H]|$9|1E|A|1F|B|H]]|D|@$9|1G|A|1H|1|1I]]|E|$]]|$1|I|3|J|5|K|7|1J|8|@]|D|@]|E|$L|M]]|$1|N|3|O|5|6|7|1K|8|@]|D|@]|E|$]]|$1|P|3|Q|5|R|7|1L|8|@$9|1M|A|1N|B|H]]|D|@$9|1O|A|1P|1|1Q]]|E|$]]|$1|S|3|T|5|R|7|1R|8|@]|D|@$9|1S|A|1T|1|1U]]|E|$]]|$1|U|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]|12|$5|X|Y|Z|E|$10|13]]|14|$5|X|Y|Z|E|$10|15]]]]

You do not have to use the query builder if you are willing to do the ordering in-memory. (Careful: This implies fetching all data sets first and then conduct the filtering on your node server).
For this, you can delegate the task to a library like <a href="https://lodash.com/" rel="nofollow noreferrer">lodash</a>. This way, you could still use the <code>EntityManager</code> or a <code>Repository</code> to query the data.
<pre><code>// first fetch the song and include (=join) the
// singer by the foreign key &quot;singer&quot;
var queryResult = await this.entityManager.find(Song, {
 relations: ['singer'],
});

// then use a library like lodash to do the ordering
const songsSortedBySinger = _.orderBy(queryResult, song =&gt; song.singer.name);
</code></pre>
For further reading:
<ul>
<li>The <code>relations</code> find option is <a href="https://github.com/typeorm/typeorm/blob/master/docs/find-options.md#basic-options" rel="nofollow noreferrer">documented here</a>.</li>
<li>lodash's orderBy is <a href="https://lodash.com/docs/4.17.15#orderBy" rel="nofollow noreferrer">documented here</a>.</li>
</ul>

blocks|key|2097833|text|如果结果不太大，您可以使用实体挂钩来解决这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2097834|++@AfterLoad()
++sortItems()+{
++++if+(this?.sortableItems?.length)+{
++++++this.sortableItems.sort((a,+b)+=>+a.weight+-+b.weight);
++++}
++}|code-block|syntax|javascript|2097835|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could do it with a workaround with entity hooks if the result is not too large:
<pre class="lang-js prettyprint-override"><code> @AfterLoad()
 sortItems() {
 if (this?.sortableItems?.length) {
 this.sortableItems.sort((a, b) =&gt; a.weight - b.weight);
 }
 }
</code></pre>

blocks|key|1288469|text|我认为typeorm增加了对这个特性的支持。在我的代码库中，我使用了这样的语法，它根据singer.name对结果排序。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1288470|const+queryResult+=+await+this.songRepository.find(Song,+{
++relations:+['singer'],
++order:+{
++++++++'singer.name':+'ASC',
++++++},
});|code-block|syntax|javascript|1288471|entityMap^0|17|B|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I think typeorm added support for this feature. In my codebase I use a syntax like this, and it orders the results based on the <code>singer.name</code>.
<pre class="lang-js prettyprint-override"><code>const queryResult = await this.songRepository.find(Song, {
 relations: ['singer'],
 order: {
 'singer.name': 'ASC',
 },
});
</code></pre>

blocks|key|2728558|text|当您使用仓库时：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2728559|var+queryResult+=+await+this.youRepository.find(Song,+{
++relations:+['singer'],
++order:+{
++++++++name:+'ASC',
++++++},
});|code-block|syntax|javascript|2728560|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

when you use a Repository:
<pre><code>var queryResult = await this.youRepository.find(Song, {
 relations: ['singer'],
 order: {
 name: 'ASC',
 },
});
</code></pre>

I have a <code>Singer</code> entity and a related <code>Song</code> entity
<code>Singer</code> entity
<pre><code>export class Singer {

 @PrimaryGeneratedColumn()
 id: number;

 @Column()
 name: string;

 @OneToMany( type =&gt; Song, Song =&gt; Song.user )
 songs: Song[];

}
</code></pre>
<code>Song</code> entity
<pre><code>export class Song {

 @PrimaryGeneratedColumn()
 id: number;

 @Column()
 name: string;

 @ManyToOne( type =&gt; Singer, Singer =&gt; Singer.songs )
 singer: Singer;

}
</code></pre>
I want to get all <code>Songs</code> ordered by <code>Singer</code> name
I searched the docs and GitHub issues but can't find an answer
How can I solve this? better without <code>QueryBuilder</code>

TypeORM: How to order by a relation field

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我有一个Singer实体和一个相关的Song实体Singer 实体export class Singer {    @PrimaryGeneratedColumn()    id: number;    @Column()    name: string;    @OneToMany( type => Song, Song => Song.user )    songs: Song[];}Song

问TypeORM:如何按关系字段排序
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问TypeORM:如何按关系字段排序EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问TypeORM:如何按关系字段排序
EN