Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/thedevs-network/kutt.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorpoeti8 <ezzati.upt@gmail.com>2020-07-28 18:39:48 +0300
committerpoeti8 <ezzati.upt@gmail.com>2020-07-28 18:39:48 +0300
commit36d4386e56821b8056061108ef82cc6e74441efa (patch)
treeac10cc2aa0693e98e3cc589063c75480b070b1fd
parentf9813bb85496cf639ed843481806a2631279a0ca (diff)
fix: searching for links
-rw-r--r--server/queries/link.ts2
1 files changed, 1 insertions, 1 deletions
diff --git a/server/queries/link.ts b/server/queries/link.ts
index 47cd102..64e0912 100644
--- a/server/queries/link.ts
+++ b/server/queries/link.ts
@@ -80,7 +80,7 @@ export const get = async (match: Partial<Link>, params: GetParams) => {
if (params.search) {
query.andWhereRaw(
- "links.description || ' ' || links.address || ' ' || target ILIKE '%' || ? || '%'",
+ "concat_ws(' ', description, links.address, target) ILIKE '%' || ? || '%'",
[params.search]
);
}