0
votes
1answer
35 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 ...
1
vote
1answer
1k 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 ...
2
votes
2answers
637 views

FullTextSqlQuery - cant add ContentType to Query

I'm using FullTextSqlQuery to perform search on a specific list. Query returns results properly, but when I try to add ContentType column to select clause SELECT Title,ContentType,Path FROM SCOPE() ...
1
vote
1answer
240 views

Malformed search query

I'm trying to perform search on a single list using FullTextSqlQuery. I found example here, but given this query: "SELECT Title,ContentType,Path FROM portal..scope() WHERE freetext('" + query + "') ...
2
votes
1answer
728 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 ...
1
vote
1answer
276 views

using FullTextSqlQuery to pull users and display hire date

I'm pulling a list of employees from SharePoint into a web part. I did the following: mapped the Hire Date user profile property to the createTimeStamp AD property created a managed property in the ...
1
vote
0answers
453 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 ...
2
votes
0answers
42 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
1answer
895 views

FullTextSqlQuery QueryText format

I'm working on creating a 100% custom search page, and I'm using FullTextSqlQuery to query my site to find what I'm looking for. My query works fine but what I need is a way to show the user a small ...
1
vote
0answers
138 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
1
vote
1answer
103 views

Indexing fields for search even if they're all null

When running a FullTextSQLQuery - it will fail to bring back any columns that are not populated. So, for example, if the crawl didn't detect any PublishedStartDate's were populated - it wouldn't allow ...
1
vote
1answer
490 views

Searching Pages Library using FullTextSqlQuery

Can anybody please point me in the right direction of searching the Pages library using FullTextSqlQuery? I've successfully instanced a new FullTextSqlQuery and have dealt with all of the necessary ...
2
votes
1answer
482 views

Can a FullTextSqlQuery in SharePoint use the “This Site” contextual scope?

I want to limit my full text SQL query to a single site collection and I am calling the SharePoint search.asmx web service directly from Javascript. Is there some way to limit this using something in ...
4
votes
4answers
679 views

How to “Search by Code” in Sharepoint Foundation 2010 items with a custom column

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 ...
2
votes
2answers
402 views

In a FullTextSqlQuery what does SiteContext refer to?

I thought it would limit where you search, but when I tried to do something like this: fullTextSqlQuery.SiteContext = new Uri("http://test.myUrl.com/nc/mySite"); It returned results from other ...
2
votes
2answers
144 views

Is there any way to find documents with similar titles using FullTextSqlQuery?

Say I have a document with the title, Calendar events for December and another document with the title Month of December Calendar of Events. Is there some way to determine that these are very similar ...
2
votes
1answer
782 views

“Error HRESULT E_FAIL has been returned from a call to a COM component” when executing FullTextSqlQuery?

I am using a FullTextSqlQuery to grab some data from a SharePoint instance. Initially I had a fairly simple where clause in which I filtered the results by the content type and everything worked ...
3
votes
1answer
252 views

How to Search custom columns for a content type and display in SPGridView

I have a custom task content type based on the task content type which has a custom priority column, custom assigned to column etc. There are many instances of the task list in multiple site ...
1
vote
1answer
927 views

Using FullTextSqlQuery to order by date

I am using the FullTextSqlQuery object to search results from my SharePoint 2010 server with a specific query. When I order by the created date (a new metadata property I have created myself of the ...
2
votes
1answer
1k views

Sharepoint 2010 FullTextSqlQuery using LIKE predicate does not find anything

I'm trying to execute a search in SharePoint 2010 with the FullTextSqlQuery class: using (SPSite site = new SPSite("http://localhost")) { using (FullTextSqlQuery query = new FullTextSqlQuery(site)) ...
5
votes
2answers
3k views

People Search FullTextSqlQuery with CONTAINS on PastProjects managed property

I am developing a Web Part for SharePoint 2010 that uses FullTextSqlQuery to perform People Search using a CONTAINS clause on the PastProjects managed property. I am not getting any results back. ...
0
votes
1answer
735 views

How do I return similar results from a fulltextsqlquery search that are similar to what a keyword search provides?

I've set up the crawl to index pages based on rendered output, but now in the SELECT statement for the query, what column name can I use in the where clause? By using a keyword search, I get results ...
2
votes
2answers
1k views

FullTextSqlQuery returning incorrect results

We are having usual behaviour with FullTextSqlQuery and wonder if anyone can help. The following should return 3 records which represent 3 pages on the site with titles "Sample (test1)", "Sample ...