A document library or a list is not returned in the search results when you use an SQL query to sort search results in SharePoint Server 2007

Article ID: 937775 - View products that this article applies to.
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986
(http://support.microsoft.com/kb/256986/ )
Description of the Microsoft Windows registry
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario. You use an SQL query to search for content in a document library or in list in Microsoft Office SharePoint Server 2007. The SQL query uses the ORDER BY clause to sort the search results by a property or by a column. However, the document library or the list is not returned in the search results. You experience this symptom even though the document library or the list contains the content for which you are searching.
Back to the top | Give Feedback

CAUSE

This problem occurs if the document library or the list does not have a value that is defined for the property or for the column that is specified in the ORDER BY clause. For example, this issue occurs if the following conditions are true:
  • The SQL query uses the ORDER BY clause to sort the search results by description.
  • The document library or the list does not have a description. That is, the value of the Description column for the document library or for the list is null.
Back to the top | Give Feedback

RESOLUTION

How to obtain the hotfix

This issue is fixed in the SharePoint Server 2007 Hotfix Package that is dated May 15, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
937208
(http://support.microsoft.com/kb/937208/ )
Description of the SharePoint Server 2007 hotfix package: May 15, 2007

Enable the hotfix

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To enable the hotfix after you apply it, add the OuterJoinDocPropsOnSorting registry entry to the following registry subkey, and then set the value of the registry entry to 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\
GUID
\Query
To do this, follow these steps:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Click the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\GUID\Query
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type OuterJoinDocPropsOnSorting, and then press ENTER.
  5. Right-click OuterJoinDocPropsOnSorting, and then click Modify.
  6. Type 1 in the Value data box, and then click OK.
  7. On the File menu, click Exit to exit Registry Editor.
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top | Give Feedback

Properties

Article ID: 937775 - Last Review: October 8, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Office SharePoint Server 2007
Keywords: 
kbmoss2007postrtmfix kbqfe kbbug kbfix KB937775
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top