Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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 in the hithighlightedsummary column even though the title and description for the page would not contain the searched for string. I've looked at all the other columns returned and none of them would work in the FullTextSqlQuery statement.

I'd like to use the FullTextSqlQuery instead of the Keyword search in order to provide wildcard searching by using the "like" clause.

I would love to be able to use the SELECT * syntax in order to see what is available, but this isn't possible. (I know why not.)

share|improve this question
add comment

1 Answer

Theres lots of info out there on what columns you can use

http://msdn.microsoft.com/en-us/library/ms495418(v=office.12).aspx

http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2008/03/06/how-to-use-the-moss-enterprise-search-fulltextsqlquery-class.aspx

Regarding using * wildcard in query syntax see my answer here:

http://www.sharepointoverflow.com/questions/993/using-select-in-fulltextsqlquery

AFAIK you have to specifically mention the columns you want.

In the SQL query, you are allowed to use the asterisk (*) to specify that all columns in a table are to be returned. However, no defined and fixed set of properties applies to all documents. For this reason, the SQL asterisk is not permitted in the [columns] setting.

http://msdn.microsoft.com/en-us/library/ms569178.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.