Hello everyone, I’m a newbie with strapi.
Now I want to exec sql raw query for full text searching propose.
I already search in the internet, they said we can use strapi.db.connection.context.raw for strapi v4. But field context I saw in the interface of connection was not exist, I’ve use strapi.db.connection.raw like older version. But it return the error => image error below.
let { rows } = await strapi.db.connection.raw(
`SELECT id,title FROM law_posts ORDER BY ts_rank(ts, phraseto_tsquery('english', ${keyword})) DESC OFFSET ${offset} LIMIT ${limit};`
);
This query I still can exec in sql cli.
Thanks
