diff options
| author | tamaina <tamaina@hotmail.co.jp> | 2022-02-27 13:59:10 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-02-27 13:59:10 +0900 |
| commit | e314be5b59dc5b518f114c82a67a8546decb5a80 (patch) | |
| tree | 269c4befe67f7e6c845ae975695ab4ceb0ba39ff /packages/backend/src/server/api/endpoints/notes/search.ts | |
| parent | refactor: Use ESM (#8358) (diff) | |
| download | sharkey-e314be5b59dc5b518f114c82a67a8546decb5a80.tar.gz sharkey-e314be5b59dc5b518f114c82a67a8546decb5a80.tar.bz2 sharkey-e314be5b59dc5b518f114c82a67a8546decb5a80.zip | |
Fix avatar/banner proxy (#8346)
* Fix avatar/banner proxy
Co-authored-by: mei23 <m@m544.net>
* use getAvatarUrl
* fix
* join avatar and banner to improve performance
* join
* Update hybrid-timeline.ts
* fix
Co-authored-by: mei23 <m@m544.net>
Co-authored-by: syuilo <Syuilotan@yahoo.co.jp>
Diffstat (limited to 'packages/backend/src/server/api/endpoints/notes/search.ts')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/notes/search.ts | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/packages/backend/src/server/api/endpoints/notes/search.ts b/packages/backend/src/server/api/endpoints/notes/search.ts index 1295542efd..e77892b150 100644 --- a/packages/backend/src/server/api/endpoints/notes/search.ts +++ b/packages/backend/src/server/api/endpoints/notes/search.ts @@ -56,10 +56,16 @@ export default define(meta, paramDef, async (ps, me) => { query .andWhere('note.text ILIKE :q', { q: `%${ps.query}%` }) .innerJoinAndSelect('note.user', 'user') + .leftJoinAndSelect('user.avatar', 'avatar') + .leftJoinAndSelect('user.banner', 'banner') .leftJoinAndSelect('note.reply', 'reply') .leftJoinAndSelect('note.renote', 'renote') .leftJoinAndSelect('reply.user', 'replyUser') - .leftJoinAndSelect('renote.user', 'renoteUser'); + .leftJoinAndSelect('replyUser.avatar', 'replyUserAvatar') + .leftJoinAndSelect('replyUser.banner', 'replyUserBanner') + .leftJoinAndSelect('renote.user', 'renoteUser') + .leftJoinAndSelect('renoteUser.avatar', 'renoteUserAvatar') + .leftJoinAndSelect('renoteUser.banner', 'renoteUserBanner'); generateVisibilityQuery(query, me); if (me) generateMutedUserQuery(query, me); |