'Typeorm of sql query
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?
Solution 1:[1]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Sina Hosseini |