SHAREPOINTSearch.com

Hi,

I have MOSS enterprise search configured using BDC. I have created managed properties for the crawled properties exposed by BDC.

The properties are something Like CustomerName, Preferences, Customer Logo URL, Customer Location, Products. From this list of indexed properties, when I search for some search input, I don't want to search for the search terms in all the indexed fields except in the Customer Logo Url property.

 If I use the scopes, it will not solve my problem because, it has only equals operator in the property query while defining property query.

I can not completely remove/Delete the  Customer Logo Url property from the indexed fields to solve this problem, because my search results webpart will be showing the Customer Logo image based on the Customer Logo Url property. In our case we have implemented custom search webparts, where we used Sharepoint Search API to get the search results.

I can not even use Not Contains(Customer Logo Url , '<search-terms>'), because this will eliminate the results which has search input in some other indexed fields. I should elimnate the results where the only field which has search terms is Customer Logo Url .

I want to exclude the Customer Logo URL while searching, but need to get that in the search result set. 

Is there a way to solve this problem.

Thanks in Advance.

Padmaja

Hello Padmaja,

That is an easy one to answer. /ssp/admin/_layouts/schema.aspx?ConsoleView=crawledPropertiesView

Edit the crawl property and uncheck the box for "Include values for this property in the search index" and then recrawl.

 Christopher

Hi Christopher,

Thanks a lot for the quick response. I will try this.

I have a quick question on this, if i exclude that property in the search index, will that property still be available in the resultset if I use Full text sql query.

This is exactly what I want to do even after performing the above step and expect the Customer Logo Url values along with the other indexed property values once I execute the below query:

SELECT CustomerName,Preferences, Customer Logo URL, Customer Location, Products FROM Scope()
WHERE SCOPE =<search_scope> AND FREETEXT(defaultproperties, '<search_terms>')

Thanks in Advance for any valuable information.

Regards,

Padmaja

YEs that value will still be available in your result set.

Hi Christopher,

Yes, it is.

I have done with the changes to the indexed data, i have removed Customer Logo URL from indexed data, even then I am able to get the value in the resultset.

Regards,

Padmaja

Similar problem here

 HI

I have the same problem here.  We have a publishing site as our Intranet and if we search on the surname of one of the content editors the search returns all the pages created by that member of staff.

I have gone through the crawled properties and unchecked the "Included in index" checkbox for anything that looks similar to a 'created by', 'modified by', 'author' but still after a full crawl the same results show.

When I click on a metadata property, (eg ows_Description in the Sharepoint category) the sample data shows as  
            Sample documents:
 
            There are zero documents in the index using this property.
 Is this an indication that something is not working?

Am I missing something?

Also, does anyone know of a resource indicating what all the metadata properties are, it would be very helpful for the numeric ones in each category, eg Office:10, Office11...

Thanks

Andy 

check out http://www.codeplex.com/SPSearchBench

it might help to get a better handle on it.

Hi

 Thanks Christopher, although the application requires .Net 3.5 framework and I am unlikely to be able to install it on there.  Is there any other way to see what is going on, I only starting looking at Moss search last week.

I did run the MOSSSearchManager application on the server and the same output is displayed as shows in the SSP metadata screens.

As we have a team collaboration site also on the same Moss server and using the same SSP I am reluctant to remove the managed properties for "Created By", "Publishing Contact" as I believe this would affect the Team Site.  Am I right here?

Basically I have two content sources set up in the SSP, one for the Intranet, one for the Team Site & ssp3.

There is a scope set up for each site, the Intranet one includes the Intranet Content Source, STS_Web & STS_Document and excluding Mysites & SPSPeople.

 
But as the crawled properties and managed properties are for both sites am I totally missing something or is the search configuration seems to be a bit restricted in the functionality,

 
Thanks

Andy
 

i usually go directly to the sql databases when i need to figure something like that out. But you would need to understand the SharePoint schemas for that to be of any use.

Changing the default managed properties for sharepoint would indeed effect other content. Your idea of having different managed properties by content source is interesting but that would be counter intuitive to the Enterprise Search concept where commonalities between the content sources are best merged to provide a single UI with shared searching. If there is a field called Client in 2 different content sources, you would still want to be able to just search on that one field in the UI called Client.