Using SharePoint search in an ASP.NET application with noise filtering

Recently we needed to implement search functionality into a content web site. This has always been a pain for me, but with SharePoint, it was very simple. I had a hard time working with the full text TSQL query I needed to submit to the SharePoint web service, but I finally got it working. To view the details, with code samples, follow the link below.

[July 26, 2004 update] Found a few links on a recent post by SharePoint blogger Mark Harrison that will help with this task:

» SPS2003 Object Models and Search
» MSSQLFT Syntax School (unless you're on my project team, you wouldn't know how much I wanted this link at the time)

[July 27, 2004 update] When it rains it pours... TechNet article posted in late June 2004 that I just noticed. Good info:

Portal site administrators can manage updates to the content index for the site directory, as well as the searches of sites crawled and included in that content index, by scoping indexing and searching to content source groups. These content source groups can be used in large organizations to manage the crawling and indexing of large site directories that may have thousands of sites. This paper describes the general process and some best practices for scoping and configuring the content index for the site directory.
» Scoping and Configuring the Content Index for the Site Directory in SharePoint Portal Server 2003

posted on Thursday, July 15, 2004 2:06 PM

Feedback

# Integrate SharePoint Server 2003 Search into a CMS site using a WebService 7/17/2004 7:45 PM Mark Harrison

One negative aspect of the search functionality provides by the CMS Connector for SharePoint is there is no ability to select a particular content source or customise how the results are rendered ...

re: Using SharePoint search in an ASP.NET application with noise filtering 10/23/2004 9:46 PM Jody Robert Ford

Is it possible to modify SPS search in such a way that certain content is never returned in a search?

For example; say I have indexed a folder on my server containing word documents. Some of these word documents have the word "robert" in them. I would like to modify SPS in such a way that a document with the word "robert" is never returned.

I was thinking of possibly using the search web service to do this. Anyone have a thought on this?

Thanks!

# 11/2/2004 8:25 AM andrew connell

# re: Using SharePoint search in an ASP.NET application with noise filtering 10/25/2004 7:53 PM Andrew Connell

SPS2003's search functionality is very customizeable and I am pretty sure you can filter out certain file types. Take a look in the newsgroup (microsoft.public.sharepoint.portalserver) for some more info on search. Although I'm not sure that the search will be as customizeable as what you're looking for.

With that being said, you can use a crafted SQL full text search to exclude documents that have exactly what you're stating. Look at some of the references in my post for this.

Post Feedback

Title:
Name:
Email:	(email will not be displayed)
Url:
Comments:
Please add 8 and 8 and type the answer here: Remember Me?

All Comments Are Filtered & Moderated
Unfortunately comment spammers are just too effecient and are constantly dirtying up blogs with irrelivant and unwanted comments trying to improve their standing on search engines. All comments on this blog are moderated. I do not censor comments, but I don't approve comments with vulger language or those soliciting products. Most of the time comments are approved within a few hours of being submitted with the only exception when I'm traveling.

Why are you asking for my email address?
The only reason I'm asking for your email address, which isn't required to submit a comment, is to provide a gravatar if you've created an account for yourself and associated your email address with a small image. If you have a gravatar created for the email address you submit, it will appear next to your comment. Otherwise nothing will appear.

What is a gravatar?
A gravatar is a "globally recognized avatar." You can get more information about gravatars, as well as create your own for free, at www.gravatar.com. You can also view my gravatar here.

This work is licensed under a Creative Commons License
Site design by Heather Solomon.