From cd8f207a8ea3fecd5697ee9b24a968c2c0c140c4 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Thu, 3 Feb 2022 10:24:48 +0100 Subject: [PATCH] Case insensitive search on tags --- server/models/video/sql/videos-id-list-query-builder.ts | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/server/models/video/sql/videos-id-list-query-builder.ts b/server/models/video/sql/videos-id-list-query-builder.ts index 76aafb883..098e15359 100644 --- a/server/models/video/sql/videos-id-list-query-builder.ts +++ b/server/models/video/sql/videos-id-list-query-builder.ts @@ -545,7 +545,7 @@ export class VideosIdListQueryBuilder extends AbstractRunQuery { ' EXISTS (' + ' SELECT 1 FROM "videoTag" ' + ' INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + - ` WHERE lower("tag"."name") = ${escapedSearch} ` + + ` WHERE lower("tag"."name") = lower(${escapedSearch}) ` + ' AND "video"."id" = "videoTag"."videoId"' + ' )' -- 2.41.0