I have a question this query is working in pgadmin...
# orm-helpg
genedy
11/09/2021, 3:02 AMI have a question this query is working in pgadmin however it doesn't work in prisma.$queryRaw
Copy code
const queryCompanies = await prisma.$queryRaw`SELECT * FROM "Company" where "name" like '%${searchName}%' and "companyId" in (SELECT "company_id" FROM "staff" where "userId"=${user.user_id} ) OFFSET ${iSkip} ROWS FETCH NEXT ${limit} ROWS ONLY ; `r
Ryan
11/09/2021, 6:12 AM@genedy 👋
What’s the error you get when using
$queryRawg
genedy
11/09/2021, 10:05 AMsearch name format in the query
genedy
11/09/2021, 10:10 AMI couldn't write it I have the same query without search name and it works
r
Ryan
11/09/2021, 10:45 AMTry including the
%searchNameg
genedy
11/09/2021, 12:36 PMgenedy
11/09/2021, 12:37 PM Copy code
const searchKey = `%${searchName}%`
const queryCompanies = await prisma.$queryRaw`SELECT * FROM "Company" where "name" like "%${searchKey}%"and "companyId" in (SELECT "company_id" FROM "staff" where "userId"=${user.user_id} ) OFFSET ${iSkip} ROWS FETCH NEXT ${limit} ROWS ONLY ; `genedy
11/09/2021, 12:37 PM@Ryan do you mean like that ?
genedy
11/09/2021, 12:38 PM Copy code
const searchKey = `%${searchName}%`
const queryCompanies = await prisma.$queryRaw`SELECT * FROM "Company" where "name" like '${searchKey}' and "companyId" in (SELECT "company_id" FROM "staff" where "userId"=${user.user_id} ) OFFSET ${iSkip} ROWS FETCH NEXT ${limit} ROWS ONLY ; `r
Ryan
11/09/2021, 12:40 PMRemove the single quotes, they are not needed
g
genedy
11/09/2021, 12:41 PM Copy code
const searchKey = `%${searchName}%`
const queryCompanies = await prisma.$queryRaw`SELECT * FROM "Company" where "name" like ${searchKey} and "companyId" in (SELECT "company_id" FROM "staff" where "userId"=${user.user_id} ) OFFSET ${iSkip} ROWS FETCH NEXT ${limit} ROWS ONLY ; `genedy
11/09/2021, 12:41 PMgenedy
11/09/2021, 12:42 PM@Ryan same result
r
Ryan
11/09/2021, 12:45 PMWhat is the value of
searchKeyg
genedy
11/09/2021, 12:46 PMconst searchKey =
%${searchName}%r
Ryan
11/09/2021, 12:50 PMThe query runs fine. I think there might be an issue with another parameter in this case.
g
genedy
11/09/2021, 10:46 PMI solved it . and there was no error in the parameters . the problem was in queryRaw itself
genedy
11/09/2021, 10:47 PMI used this condition .
Copy code
prisma.$queryRaw``genedy
11/09/2021, 10:47 PMand this was wrong
genedy
11/09/2021, 10:47 PMthe correct was to use prisma.$queryRaw()
💯 2
genedy
11/09/2021, 10:48 PMI know that first is working , but second is more valid in complex query.
genedy
11/09/2021, 10:51 PMI am feeling thankful for you @Ryan
👍 2
3 Views