summaryrefslogtreecommitdiff
path: root/src/server/api/common/generate-visibility-query.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/common/generate-visibility-query.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/common/generate-visibility-query.ts')
-rw-r--r--src/server/api/common/generate-visibility-query.ts2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/server/api/common/generate-visibility-query.ts b/src/server/api/common/generate-visibility-query.ts
index 72ed1c46ea..00a50f8211 100644
--- a/src/server/api/common/generate-visibility-query.ts
+++ b/src/server/api/common/generate-visibility-query.ts
@@ -22,7 +22,7 @@ export function generateVisibilityQuery(q: SelectQueryBuilder<any>, me?: { id: U
// または 自分自身
.orWhere('note.userId = :userId1', { userId1: me.id })
// または 自分宛て
- .orWhere(':userId2 = ANY(note.visibleUserIds)', { userId2: me.id })
+ .orWhere(`'{"${me.id}"}' <@ note.visibleUserIds`)
.orWhere(new Brackets(qb => { qb
// または フォロワー宛ての投稿であり、
.where('note.visibility = \'followers\'')