summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/notes/mentions.ts
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2021-05-21 14:13:03 +0900
committerGitHub <noreply@github.com>2021-05-21 14:13:03 +0900
commitda34acd35fdeca50cba2de809e85de1f22eb5b70 (patch)
treed16449fb3f88a077e199a411b6eafb1e3f9b4411 /src/server/api/endpoints/notes/mentions.ts
parentUpdate deps (diff)
downloadsharkey-da34acd35fdeca50cba2de809e85de1f22eb5b70.tar.gz
sharkey-da34acd35fdeca50cba2de809e85de1f22eb5b70.tar.bz2
sharkey-da34acd35fdeca50cba2de809e85de1f22eb5b70.zip
Resolve #6563 (#7524)
* Resolve #6563 * Update note.ts * Update generate-visibility-query.ts
Diffstat (limited to 'src/server/api/endpoints/notes/mentions.ts')
-rw-r--r--src/server/api/endpoints/notes/mentions.ts4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/server/api/endpoints/notes/mentions.ts b/src/server/api/endpoints/notes/mentions.ts
index 34936c9b54..dddd08eee6 100644
--- a/src/server/api/endpoints/notes/mentions.ts
+++ b/src/server/api/endpoints/notes/mentions.ts
@@ -60,8 +60,8 @@ export default define(meta, async (ps, user) => {
const query = makePaginationQuery(Notes.createQueryBuilder('note'), ps.sinceId, ps.untilId)
.andWhere(new Brackets(qb => { qb
- .where(`:meId = ANY(note.mentions)`, { meId: user.id })
- .orWhere(`:meId = ANY(note.visibleUserIds)`, { meId: user.id });
+ .where(`'{"${user.id}"}' <@ note.mentions`)
+ .orWhere(`'{"${user.id}"}' <@ note.visibleUserIds`);
}))
.innerJoinAndSelect('note.user', 'user')
.leftJoinAndSelect('note.reply', 'reply')