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
852 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
358 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
2k views

SharePoint 2010 - get list item from search result

I'm using FullTextSqlQuery to search items on specific list. Query returns results properly. Now I'd like to get SPListItem from search results. As I searched Internet, I found couple of examples, but ...
1
vote
1answer
584 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
103 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 ...
0
votes
1answer
330 views

NULL Filter against FullTextSQLQuery Search Query in Sharepoint 2010

I need to get results from scope where DueDate is not NULL. I applied Condition for this. here is the code for getting results from scope, but when I apply condition for DueDate, an exception is ...
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
23 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
566 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
147 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