Questions tagged [fulltextsqlquery]
A class of the Microsoft.Office.Server.Search.Query namespace, FullTextSqlQuery represents a SQL syntax search query.
35 questions
1
vote
1
answer
790
views
Advance Seach webpart, can i force the "Contain" to search for substrings
I added an advance search web part inside my team site inside sharepoint enterprise server 2013, as follow:-
but i am unable to understand how the contain actually works. for example i have these 3 ...
5
votes
2
answers
304
views
Custom Search webpart - How to 'drill down' into folders?
We recently deployed a new custom Search Results webpart that utilizes a search scope we setup to query specific document libraries under a site hierarchy and return the results in a web part.
The ...
- 760
1
vote
0
answers
55
views
How to search on a list using fulltextsqlquery?
SELECT Title, Path FROM Scope() WHERE \"Scope\"='All sites' AND CONTAINS(Path, '\site\Lists\ListDisplayName')
Is good syntax?
- 736
1
vote
0
answers
50
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 ...
- 11
0
votes
1
answer
219
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 ...
- 159
1
vote
1
answer
768
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,638
0
votes
2
answers
2k
views
Calendar data's storage in SQL
Hi I would like to know in which db and table the datas for sharepoint calendar ?
I need to have a reading access to these datas with another application write in php.
- 1
1
vote
1
answer
3k
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,547
2
votes
2
answers
1k
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,547
1
vote
1
answer
746
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 + "') ...
- 1,547
3
votes
1
answer
1k
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 FullTextSQLQuery ...
- 682
1
vote
1
answer
790
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 ...
- 682
1
vote
0
answers
1k
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 ...
- 341
2
votes
1
answer
452
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 ...
- 21
2
votes
0
answers
58
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,071
2
votes
1
answer
1k
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 ...
- 255
3
votes
1
answer
282
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
- 275
1
vote
1
answer
125
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,071
1
vote
1
answer
601
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 ...
- 1,071
3
votes
1
answer
2k
views
How do you escape special characters in the CONTAINS predicate of a FullTextSqlQuery in SharePoint 2010?
I am using the CONTAINS predicate in a full text SQL query in SP2010 Standard. Yes, I'd rather do a Keyword Query, but it doesn't appear to be able to handle what I need.
I have learned things like ...
- 1,423
2
votes
1
answer
663
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 ...
- 1,423
5
votes
1
answer
864
views
Possible to combine KeywordQuery and FullTextSqlQuery?
Basically I would like to get all results that would be returned for a normal keyword query, but I want to filter those results with a WHERE clause. I tried using KeywordQuery or FullTextSqlQuery but ...
- 6,755
4
votes
4
answers
909
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 (...
- 1,987
2
votes
2
answers
479
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 sites ...
- 6,755
2
votes
2
answers
169
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 ...
- 6,755
2
votes
2
answers
2k
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 fine....
- 6,755
3
votes
1
answer
324
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 ...
- 988
1
vote
1
answer
3k
views
SP 2010 FullTextSqlQuery display managed properties in query results
I have created a managed property TaskDueDate linked to ows_DueDate(Date and Time)
which I would like to display in my search query results.
However the query doesn't return any values for ...
- 723
1
vote
1
answer
337
views
Getting FullTextSqlQuery to return a permissions mask of sorts
I would like to have my FullTextSqlQuery return the permissions mask that the user running it has on the list items returned. Results are returned the same whether the user has Read or Contribute for ...
- 573
2
votes
1
answer
1k
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 ...
- 51
2
votes
1
answer
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))
...
- 2,097
5
votes
2
answers
4k
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. ...
- 5,030
0
votes
1
answer
835
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
2
answers
2k
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 (...
- 223
1
vote
2
answers
3k
views
Using SELECT * in FullTextSqlQuery
I'm writing a FullTextSqlQuery and would like to return all available columns in the result set.
When I specify the columns, e.g. SELECT Title FROM scope() WHERE ("scope" = 'All Sites'), the query ...
- 5,961