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
927 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
375 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 ...
1
vote
1answer
635 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
116 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
46 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
33 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
642 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
153 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