I've got a site collection on a Sharepoint Foundation 2010. I've Search Express also installed.. When i wrote down in the search box something like "Parameter:Value" it returns me the right elements (so i've configured well column and crawler)..
Now i want (by code) write a query that gets every item with that column and respect some value.. So, make the same thing, but coding it!
string searchQuery = "select Title from scope() WHERE Tag = 'Value' "; // Execute the query. FullTextSqlQuery query = new FullTextSqlQuery(SPContext.Current.Site); query.ResultTypes = ResultType.RelevantResults; query.QueryText = searchQuery; ResultTableCollection searchResults = query.Execute();
It cannot execute the query... Tag is the field i've defined and works writing down the Tag:Value from search box!
Can anyone suggest me what's wrong with my query?
Thank you very much!!