A class of the Microsoft.Office.Server.Search.Query namespace, FullTextSqlQuery represents a SQL syntax search query.

learn more… | top users | synonyms

2
votes
1answer
961 views

fulltextsqlquery exclude records with blank department

The following FullTextSQLQuery returns results: SELECT PreferredName, Department, WorkEmail, HireDate FROM SCOPE() WHERE \"scope\" = 'People' ORDER BY HireDate DESC The following ...
2
votes
1answer
385 views

FullTextSQLQuery with a Taxonomy GUID in Where Clause

I've created a few documents and tagged them with various Taxonomy Terms from a Term Set. The terms I have chosen are children of other Terms. I've executed a crawled and created a Managed Property ...
2
votes
1answer
668 views

Possible to combine KeywordQuery and FullTextSqlQuery?

Basically I would like to get all results that would returned for a normal keyword query, but I want to filter those results with a WHERE clause. I tried using KeywordQuery or FullTextSqlQuery but ...
0
votes
1answer
128 views

Why FullTextSqlQuery doesn't return the same results as web front end searching?

I'm creating FullTextSqlQuery to find some phases in files content. I have some test files uploaded on one of SPSite with content that match my query conditions. When I search in web browser, I'm ...
2
votes
0answers
47 views

Unexpected ListItem in Scope

I've defined a new scope for a search service application. The scope's got one simple rule - content type = particular content type. I'm finding that when I query this scope (FullTextSQLQuery) it's ...
1
vote
0answers
39 views

Handling Numerous OR conditions in Sharepoint 2010 FullTextSQLQuery

I have below requirement There are lacks of documents in SP library.These are belongs to staff(170 nationals approx) in my organization. Users of this application are HRs in my Organization. Set of ...
1
vote
0answers
692 views

Increase KeywordQuery QueryText max length in SP 2010

I am using SharePoint Server 2010. I faced some difficulties with the Core Search Results Web Part. The issue was that my query length was to be about 2500 characters. This long query served to filter ...
1
vote
0answers
158 views

Syntax to search on modified date and creation date column of document library using FullTextSqlQuery

In sharepoint 2007 please let me know how to perform FullTextSqlQuery on document library date column