0

This query works well on the database, however I'm not able to make it work by using typeorm createQueryBuilder.

SELECT *
FROM content 
INNER JOIN FreeTextTable(content, *, 'text') AS KEY_TBL
    ON content.id = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

Could you please help me out here?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sina Hosseini
  • 36
  • 3
  • Thanks for your reply. I'm trying to use typeorm on a nodejs backend to query my sql database, however I wasn't able to use "freetexttable" to query data. My question is how should I do that? – Sina Hosseini May 03 '22 at 12:32

1 Answers1

0

For those facing the same issue. I was unable to find a solution to use FREETEXTTABLE with typeorm, so I had to implement it using raw SQL.

Sina Hosseini
  • 36
  • 3