diff options
| author | piuvas <piuvas@proton.me> | 2024-11-15 13:40:53 -0300 |
|---|---|---|
| committer | piuvas <piuvas@proton.me> | 2024-11-15 13:40:53 -0300 |
| commit | eaad96aae30d0e1ab1ae05b5c0fef908cd002d79 (patch) | |
| tree | 7e8bb3de9f678bcd310d5d4fdc4b26e9053c65bd /packages/backend/src | |
| parent | merge: Revert "Experimental: dont mark backfetched notes as silent" (!703) (diff) | |
| download | sharkey-eaad96aae30d0e1ab1ae05b5c0fef908cd002d79.tar.gz sharkey-eaad96aae30d0e1ab1ae05b5c0fef908cd002d79.tar.bz2 sharkey-eaad96aae30d0e1ab1ae05b5c0fef908cd002d79.zip | |
edit query
Diffstat (limited to 'packages/backend/src')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/emojis.ts | 15 |
1 files changed, 5 insertions, 10 deletions
diff --git a/packages/backend/src/server/api/endpoints/emojis.ts b/packages/backend/src/server/api/endpoints/emojis.ts index 46ef4eca1b..8054de3d95 100644 --- a/packages/backend/src/server/api/endpoints/emojis.ts +++ b/packages/backend/src/server/api/endpoints/emojis.ts @@ -50,16 +50,11 @@ export default class extends Endpoint<typeof meta, typeof paramDef> { // eslint- private emojiEntityService: EmojiEntityService, ) { super(meta, paramDef, async (ps, me) => { - const emojis = await this.emojisRepository.find({ - where: { - host: IsNull(), - }, - order: { - category: 'ASC', - name: 'ASC', - }, - }); - + const emojis = await this.emojisRepository.createQueryBuilder() + .where('host IS NULL') + .orderBy('LOWER(category)', 'ASC') + .orderBy('LOWER(name)', 'ASC') + .getMany() return { emojis: await this.emojiEntityService.packSimpleMany(emojis), }; |