0
votes
1answer
755 views

How do I return similar results from a fulltextsqlquery search that are similar to what a keyword search provides?

I've set up the crawl to index pages based on rendered output, but now in the SELECT statement for the query, what column name can I use in the where clause? By using a keyword search, I get results ...
2
votes
2answers
1k views

FullTextSqlQuery returning incorrect results

We are having usual behaviour with FullTextSqlQuery and wonder if anyone can help. The following should return 3 records which represent 3 pages on the site with titles "Sample (test1)", "Sample ...
1
vote
2answers
3k views

Using SELECT * in FullTextSqlQuery

I'm writing a FullTextSqlQuery and would like to return all available columns in the result set. When I specify the columns, e.g. SELECT Title FROM scope() WHERE ("scope" = 'All Sites'), the query ...