diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-02-13 06:57:43 -0500 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-02-13 16:56:32 -0500 |
| commit | a95bfb7241ca2ea139413fae92e65e5ae5aaf225 (patch) | |
| tree | 906dd26e0ab69781bd75493242d68eabda77a732 | |
| parent | merge: Add new note search file types (module, flash), optimize search query,... (diff) | |
| download | sharkey-a95bfb7241ca2ea139413fae92e65e5ae5aaf225.tar.gz sharkey-a95bfb7241ca2ea139413fae92e65e5ae5aaf225.tar.bz2 sharkey-a95bfb7241ca2ea139413fae92e65e5ae5aaf225.zip | |
search notes with denormalized userHost field
| -rw-r--r-- | packages/backend/src/core/SearchService.ts | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/packages/backend/src/core/SearchService.ts b/packages/backend/src/core/SearchService.ts index a8c6ac61f3..9fb057e7b2 100644 --- a/packages/backend/src/core/SearchService.ts +++ b/packages/backend/src/core/SearchService.ts @@ -287,9 +287,9 @@ export class SearchService { if (opts.host) { if (opts.host === '.') { - query.andWhere('user.host IS NULL'); + query.andWhere('note.userHost IS NULL'); } else { - query.andWhere('user.host = :host', { host: opts.host }); + query.andWhere('note.userHost = :host', { host: opts.host }); } } |