Knowledge Base

Office Custom Property Is Not Searchable

Article ID: 197607

Article Last Modified on 5/10/2001

Microsoft Site Server 3.0 Standard Edition

This article was previously published under Q197607

SYMPTOMS

A Microsoft Office custom property is not searchable by default. Attempting to search the field results in an empty query result.

CAUSE

The schema does not contain proper information to process the custom property.

RESOLUTION

The following steps will allow you to make the custom property called "phrase2" searchable:

Open Site Server Dir\Data\Search\Config\DefineColumns.txt.

Add the following to DefineColumns.txt:

      # Custom Property for MSOffice document
      # custom_int (DBTYPE_I4) = d5cdd505-2e9c-101b-9397-08002b2cf9ae
      custom_int
      phrase2 (DBTYPE_STR | DBTYPE_BYREF) = d5cdd505-2e9c-101b-9397-
      08002b2cf9ae
      "phrase2"

Go to Schema in the MMC.
Add custom property.
For Other Property Set, enter "d5cdd505-2e9c-101b-9397-08002b2cf9ae" (without the quotation marks).
For Property ID, enter phrase2.
Select String.
Select Index, and then select Retrievable.
Select Submit.
Re-crawl the catalog.

MORE INFORMATION

The custom property is part of the property of the Office documents. For example:

Open an Office Word document
Select File and choose Property.
Click the Custom tab.

The query syntax for the custom property called "phrase2" is:

@phrase2 "the value of the phrase2"

Keywords: kbprb kbpending KB197607