Accessing custom crawled property in fulltextsqlquery

Question

My manage property is named like e/m/BioOffice/Text, e/m/BioPosition/Text. When I try to execute the following code:

 string queryTxt = "SELECT URL, e/m/BioOffice/Text,e/m/BioPosition/Text FROM SCOPE() where \"scope\"='ektron25056203187' And FREETEXT(*,'" + TextBox1.Text.Trim() + "')";


                var query = new FullTextSqlQuery(searchApplicationProxy)
                {   
                    QueryText = queryTxt,
                    ResultTypes = ResultType.RelevantResults,
                    ResultsProvider = SearchProvider.Default,
                    TrimDuplicates = false,
                    EnableStemming = true
                };

                ResultTableCollection resultsTableCollection = query.Execute();
                ResultTable searchResultsTable = resultsTableCollection[ResultType.RelevantResults];                   
                DataTable resultsDataTable = new DataTable();
                resultsDataTable.TableName = "Results";
                resultsDataTable.Load(searchResultsTable, LoadOption.OverwriteChanges);

                Label1.Text = "Total results Count : " + resultsDataTable.Rows.Count;

It give me the exception : Your query is malformed. Please rephrase your query. Please help how I can access those properties.

score 1 · Answer 1 · answered May 16 '12 at 12:30

1

Hi gaurav test your query in Search Service Tool

The SharePoint Search Service Tool is a rich web service client that allows a developer to explore the scopes and managed properties of a given SharePoint Search SSP, build queries in either Keyword or SQL Syntax, submit those queries and examine the raw web service results. This tool can be useful in troubleshooting and verifying the behavior and configuration of a SharePoint environment.

you can fiend that tool in codeplex

http://sharepointsearchserv.codeplex.com/

answered May 16 '12 at 12:30

V_B

1,571
5
16
37

Thanks V_B. Still i'm not able to access managed property named as "e/m/BioOffice/Text". please help me in accessing that – gaurav May 16 '12 at 12:56
1

While executing the query in Sharepoint Search Service Tool I got the following error: ERROR_BAD_QUERY Your query is malformed. Please rephrase your query. – gaurav May 16 '12 at 14:29
See this If custom property http://sharepoint.stackexchange.com/questions/27241/sharepoint-2010-search-asmx-query-problem/27268#27268 – V_B May 17 '12 at 11:51

score 1 · Answer 2 · answered Jan 21 '13 at 16:22

Search Server interprets this as a malformed query due to the forward slashes ('/') in your managed property names. These property names should be surrounded with double quotes (") so that Search Server's query parser interprets them literally. (Note how the 'scope' property is referenced in the WHERE clause later in the expression.)

string queryTxt = "SELECT URL, \"e/m/BioOffice/Text\",\"e/m/BioPosition/Text\" FROM SCOPE() where \"scope\"='ektron25056203187' And FREETEXT(*,'" + TextBox1.Text.Trim() + "')";

I also see that you are likely integrating an Ektron site with Search Server. I would recommend using Ektron search API to ensure that your queries are well-formed. (Reference: AdvancedSearchCriteria)

Accessing custom crawled property in fulltextsqlquery

2 Answers2