'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