diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-05-28 02:03:05 -0400 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-04 10:45:21 -0400 |
| commit | b05ccbc3aca8e008555736f25760f9f2b1b2a5e7 (patch) | |
| tree | 5033241e53cccf7a1c0659c1cf37f87e705e6d1b /packages/backend/src/server | |
| parent | add relation from user->user_profile to speed up UserEntityService.pack and p... (diff) | |
| download | sharkey-b05ccbc3aca8e008555736f25760f9f2b1b2a5e7.tar.gz sharkey-b05ccbc3aca8e008555736f25760f9f2b1b2a5e7.tar.bz2 sharkey-b05ccbc3aca8e008555736f25760f9f2b1b2a5e7.zip | |
add relations from abuse_user_report->user_profile to speed up admin/abuse-user-reports endpoint
Diffstat (limited to 'packages/backend/src/server')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/admin/abuse-user-reports.ts | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/packages/backend/src/server/api/endpoints/admin/abuse-user-reports.ts b/packages/backend/src/server/api/endpoints/admin/abuse-user-reports.ts index f052d3dd14..f9aa3b7ae5 100644 --- a/packages/backend/src/server/api/endpoints/admin/abuse-user-reports.ts +++ b/packages/backend/src/server/api/endpoints/admin/abuse-user-reports.ts @@ -120,7 +120,15 @@ export default class extends Endpoint<typeof meta, typeof paramDef> { // eslint- private queryService: QueryService, ) { super(meta, paramDef, async (ps, me) => { - const query = this.queryService.makePaginationQuery(this.abuseUserReportsRepository.createQueryBuilder('report'), ps.sinceId, ps.untilId); + const query = this.queryService.makePaginationQuery(this.abuseUserReportsRepository.createQueryBuilder('report'), ps.sinceId, ps.untilId) + .leftJoinAndSelect('report.targetUser', 'targetUser') + .leftJoinAndSelect('report.targetUserProfile', 'targetUserProfile') + .leftJoinAndSelect('report.targetUserInstance', 'targetUserInstance') + .leftJoinAndSelect('report.reporter', 'reporter') + .leftJoinAndSelect('report.reporterUserProfile', 'reporterUserProfile') + .leftJoinAndSelect('report.assignee', 'assignee') + .leftJoinAndSelect('report.assigneeUserProfile', 'assigneeUserProfile') + ; switch (ps.state) { case 'resolved': query.andWhere('report.resolved = TRUE'); break; |