Exception while using FullTextSqlQuerry Sharepoint 2007

Question

We are using Sharepoint 2007. we are using FullTextSqlQuerry in one of our page Following is the query we are using -

query = "SELECT Title,Path,Write,Rank,Size,Description FROM scope() WHERE  ((\"SCOPE\" = 'Docstudy'))";

The above query executes successfully but when I try to select other columns like "Domain", "DocumentType" then below exception occurs =>

Property doesn't exist or is used in a manner inconsistent with schema settings.

We have included Microsoft.Office.Server.Search.Query,Microsoft.Office.Server.Search and Microsoft.Office.Server assemblies.

After doing some Google we found that we need to check with managed propeties but we are not getting what and how exactly resolve this issue. What I am missing? Please help me on this.

Thanks in Advance, Rushikesh

Howard Howard · Accepted Answer · 2011-12-21T14:15:06

You need to map Crawled Properties (found by the indexer) to Managed Properties which are site columns e.g. your "Domain" column. Do this via the SSP Search configuration pages.

Exception while using FullTextSqlQuerry Sharepoint 2007

1 Answers