Combined full text search / field based search - Sharepoint

This is a discussion on Combined full text search / field based search - Sharepoint ; Hello, we have developed a custom webservice for SharePoint Portal Server 2003. The Webservice is used by Windows rich clients. Our customers require a combined search, i.e. allowing full-text search and field-based search at the same time. Currently our custom ...

+ Reply to Thread
Results 1 to 5 of 5

Combined full text search / field based search

  1. Default Combined full text search / field based search

    Hello,

    we have developed a custom webservice for SharePoint Portal Server 2003.
    The Webservice is used by Windows rich clients.

    Our customers require a combined search, i.e. allowing full-text search and
    field-based search at the same time.

    Currently our custom webservice performs two search operations to do this:
    1. a fulltext search calling SPWeb.SearchDocuments
    2. a field-based search calling SPList.GetItems

    The CAML query used in the 2nd step combines the results of the 1st step and
    the field-based filter criteria.

    The problems are:
    the result depends on the rowlimit value of the 1st call.


    I have two questions:

    Is there in SharePoint Portal Server 2007 an API that does a combined search
    like the required one?

    Does anybody has a better solution for the task?


    Thank you



  2. Default RE: Combined full text search / field based search

    Hi,

    As I know, there is no proper way to combine these two methods in one step.
    Why do you need to use two different query? Will the full text not return
    all results you need?

    Sincerely,

    Luke Zhang

    Microsoft Online Community Support
    ==================================================
    Get notification to my posts through email? Please refer to
    http://msdn.microsoft.com/subscripti...ult.aspx#notif
    ications.

    Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
    where an initial response from the community or a Microsoft Support
    Engineer within 1 business day is acceptable. Please note that each follow
    up response may take approximately 2 business days as the support
    professional working with you may need further investigation to reach the
    most efficient resolution. The offering is not appropriate for situations
    that require urgent, real-time or phone-based interactions or complex
    project ****ysis and dump ****ysis issues. Issues of this nature are best
    handled working with a dedicated Microsoft Support Engineer by contacting
    Microsoft Customer Support Services (CSS) at
    http://msdn.microsoft.com/subscripti...t/default.aspx.
    ==================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.



  3. Default Re: Combined full text search / field based search

    Hi Luke,

    thank you for quick answer.

    The problem is, the full text search will return too many results!

    As your answer implies, even the API of SharePoint Portal Server 2007 does
    not support such a combined query.
    Is this correct?

    Do you have any suggestions for a solution?

    Thank you
    Wolfgang


    "Luke Zhang [MSFT]" <lukezhan@online.microsoft.com> schrieb im Newsbeitrag
    news:PK5lj7RZHHA.4084@TK2MSFTNGHUB02.phx.gbl...
    > Hi,
    >
    > As I know, there is no proper way to combine these two methods in one
    > step.
    > Why do you need to use two different query? Will the full text not return
    > all results you need?
    >
    > Sincerely,
    >
    > Luke Zhang
    >
    > Microsoft Online Community Support




  4. Default Re: Combined full text search / field based search

    Hello,

    Even in MOSS 2007, there is still no similar combined query. MOSS 2007
    provide two kinds of search classes:

    Microsoft.SharePoint.Search.Query.KeywordQuery class
    Microsoft.SharePoint.Search.Query.FullTextSqlQuery class

    Maybe you can use KeywordQuery for better result.

    Sincerely,

    Luke Zhang

    Microsoft Online Community Support
    ==================================================
    Get notification to my posts through email? Please refer to
    http://msdn.microsoft.com/subscripti...ult.aspx#notif
    ications.

    Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
    where an initial response from the community or a Microsoft Support
    Engineer within 1 business day is acceptable. Please note that each follow
    up response may take approximately 2 business days as the support
    professional working with you may need further investigation to reach the
    most efficient resolution. The offering is not appropriate for situations
    that require urgent, real-time or phone-based interactions or complex
    project ****ysis and dump ****ysis issues. Issues of this nature are best
    handled working with a dedicated Microsoft Support Engineer by contacting
    Microsoft Customer Support Services (CSS) at
    http://msdn.microsoft.com/subscripti...t/default.aspx.
    ==================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.



  5. Default Re: Combined full text search / field based search

    Hello Luke,

    thank you for your answer.


    Sincerely
    Wolfgang


    "Luke Zhang [MSFT]" <lukezhan@online.microsoft.com> schrieb im Newsbeitrag
    news:KTsIZmuZHHA.296@TK2MSFTNGHUB02.phx.gbl...
    > Hello,
    >
    > Even in MOSS 2007, there is still no similar combined query. MOSS 2007
    > provide two kinds of search classes:
    >
    > Microsoft.SharePoint.Search.Query.KeywordQuery class
    > Microsoft.SharePoint.Search.Query.FullTextSqlQuery class
    >
    > Maybe you can use KeywordQuery for better result.
    >
    > Sincerely,
    >
    > Luke Zhang
    >
    > Microsoft Online Community Support
    > ==================================================
    > Get notification to my posts through email? Please refer to
    > http://msdn.microsoft.com/subscripti...ult.aspx#notif
    > ications.
    >
    > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
    > where an initial response from the community or a Microsoft Support
    > Engineer within 1 business day is acceptable. Please note that each follow
    > up response may take approximately 2 business days as the support
    > professional working with you may need further investigation to reach the
    > most efficient resolution. The offering is not appropriate for situations
    > that require urgent, real-time or phone-based interactions or complex
    > project ****ysis and dump ****ysis issues. Issues of this nature are best
    > handled working with a dedicated Microsoft Support Engineer by contacting
    > Microsoft Customer Support Services (CSS) at
    > http://msdn.microsoft.com/subscripti...t/default.aspx.
    > ==================================================
    >
    > This posting is provided "AS IS" with no warranties, and confers no
    > rights.
    >
    >




+ Reply to Thread

Similar Threads

  1. Full Text Search - characters limit
    By Application Development in forum PHP
    Replies: 1
    Last Post: 09-24-2007, 09:50 PM
  2. MOSS 2007 Full Text Search
    By Application Development in forum Sharepoint
    Replies: 5
    Last Post: 05-04-2007, 03:54 PM
  3. ASP full-text search tutorial/example?
    By Application Development in forum Inetserver
    Replies: 0
    Last Post: 10-23-2006, 05:00 AM
  4. Which vendor has the FASTEST Full-Text Search Engine?
    By Application Development in forum Inetserver
    Replies: 0
    Last Post: 08-27-2005, 02:01 PM
  5. Full Text Search with OPENROWSET
    By Application Development in forum Inetserver
    Replies: 2
    Last Post: 01-28-2004, 03:59 PM