• Hello,
    I'm trying to read System.Search.QueryFocusedSummary from the SystemIndex.
    I get a "column does not exist" error message. I am able to read other
    columns such as: System.Search.AutoSummary.

    I am using the Microsoft Windows Search 3.x SDK download
    (Windows.Search.Interop.dll) on a Windows 7 operating System and Windows
    Search 4.0.
    My query is:
    SELECT TOP 25 System.QueryFocusedSummary From SystemIndex where
    CONTAINS('microsoft') ORDER BY System.ItemDate DESC
    How can I get the query working with System.Search.QueryFocusedSummary?
    The code is as follows:

    using System;
    using System.Collections;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.OleDb;
    using System.IO;
    using System.Security.Permissions;
    using System.Text;
    using Microsoft.Search.Interop;
    namespace QueryFocusedSummaryTest
      class Program
      static void Main(string[] args)
        string sqlQuery = "select top 25 System.Search.QueryFocusedSummary from SystemIndex where contains('microsoft') order by System.ItemDate DESC";
        CSearchManager manager = new CSearchManager();
        ISearchCtalogManager catalogMaager = manager.GetCatalog("SystemIndex");
        ISearchQueryHelper queryHelper = catalogManager.GetQueryHelper();
        using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(queryHelper.ConnectionString))
          using (OleDbCommand command = new OleDbCommand(sqlQuery, conn))
            OleDbDataAdapter ds = new OleDbDataAdapter(command);
            DataSet ds = new DataSet();
            //By now it has thrown the exception

    Many thanks for any help.



    Monday, May 16, 2011 2:35 PM

All replies

  • Hi Ravi,

    I have been researching the same for days. according to System.Search.QueryFocusedSummary is not a column but is supposed to be used only ' when consuming the values in your application, not for providing values to a property handler.' i find it strange that no one from Microsoft can answer what that means.

    Monday, July 25, 2011 3:10 AM
  • I to would very much like to figure out how to access this. From the field title, I assume it would contain the context of the match within a document similar to hithighlightedsummary on sharepoint?

    Doing a quick tests with procmon and windows search, I can see that when I do a windows search and  have the context on, windows does not read the file, so I would assume the data must be somewhere in the search system.

    Same question from over a year ago, still withn ow answer:


    Tuesday, August 16, 2011 2:46 PM
  • I have been searching for a solution that will give me System.Search.QueryFocusedSummary‎ and have failed. Regrettably no one from Microsoft seems to care. out of all posts (many people have been looking for the same) NO ONE has been given an answer! this is really poor poor support considering that the last thing i hear d from Balmer was that he loves developers and their new song is 'developers developers developers'
    Saturday, September 17, 2011 7:17 AM