Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 951249 - Last Review: July 8, 2008 - Revision: 1.0
You do not receive search alerts when you use the FullTextSqlQuery object to perform a full-text search of a server that is running SharePoint Server 2007
SYMPTOMS
You use the FullTextSqlQuery object to perform a full-text search of a server that is running Microsoft Office SharePoint Server 2007. When you do this, you receive the initial search alert that states that the particular search alert was created. However, you do not receive the search alerts for the following searches.
RESOLUTION
To resolve this problem, apply hotfix 952288.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
952288Â
(http://kbalertz.com/Feedback.aspx?kbNumber=952288/
)
Description of the Windows SharePoint Services 3.0 hotfix package: May 8, 2008
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
The following code is an example of how to use the FulltextSqlQuery object to perform a full-text search of a server.
String siteUrl = "http://localhost";
String queryText = "SELECT Title FROM Scope() WHERE FREETEXT(defaultproperties, 'xyz')";
SPSite spSite = new SPSite(siteUrl);
Query alertQuery = new FullTextSqlQuery(spSite);
alertQuery.QueryText = queryText;
alertQuery.ResultTypes = ResultType.RelevantResults;
alertQuery.TrimDuplicates = true;
alertQuery.Execute();
//Creating search alerts
SearchAlert searchAlert = new SearchAlert(spSite, alertQuery);
searchAlert.ChangeType = AlertChangeType.Discovered;
searchAlert.InnerAlert.AlertFrequency = SPAlertFrequency.Daily;
searchAlert.InnerAlert.EventType = SPEventType.All;
searchAlert.InnerAlert.Title = "FirstSearchAlert";
searchAlert.InnerAlert.User = spSite.OpenWeb().AllUsers[@"domain\username"];
searchAlert.Update();
The
AlertFrequency property should be set to "Daily" instead of "Immediate." "Immediate" alerts are not supported for searches.
APPLIES TO
- Microsoft Office SharePoint Server 2007
| kbprb kbqfe kbexpertiseinter KB951249 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please