Combined full text search / field based search

Combined full text search / field based search

Post by Wolfgang W » Tue, 13 Mar 2007 21:50:26


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
 
 
 

Combined full text search / field based search

Post by lukezha » Wed, 14 Mar 2007 12:22:36


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://www.yqcomputer.com/ #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 analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://www.yqcomputer.com/
==================================================

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


{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi,
\par
\par 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?
\par
\par Sincerely,
\par
\par Luke Zhang
\par
\par Microsoft Online Community Support
\par ==================================================
\par Get notification to my posts through email? Please refer to http://www.yqcomputer.com/ #notifications.
\par
\par 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 analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://www.yqcomputer.com/
\par ==================================================
\par
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par
\par }

 
 
 

Combined full text search / field based search

Post by Wolfgang W » Wed, 14 Mar 2007 18:31:26

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]" < XXXX@XXXXX.COM > schrieb im Newsbeitrag
 
 
 

Combined full text search / field based search

Post by lukezha » Fri, 16 Mar 2007 19:06:08


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://www.yqcomputer.com/ #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 analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://www.yqcomputer.com/
==================================================

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


{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hello,
\par
\par Even in MOSS 2007, there is still no similar combined query. MOSS 2007 provide two kinds of search classes:
\par
\par Microsoft.SharePoint.Search.Query.KeywordQuery class
\par Microsoft.SharePoint.Search.Query.FullTextSqlQuery class
\par
\par Maybe you can use KeywordQuery for better result.
\par
\par Sincerely,
\par
\par Luke Zhang
\par
\par Microsoft Online Community Support
\par ==================================================
\par Get notification to my posts through email? Please refer to http://www.yqcomputer.com/ #notifications.
\par
\par 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 analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://www.yqcomputer.com/
\par ==================================================
\par
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par
\par }
 
 
 

Combined full text search / field based search

Post by Wolfgang W » Tue, 20 Mar 2007 06:06:50

Hello Luke,

thank you for your answer.


Sincerely
Wolfgang


"Luke Zhang [MSFT]" < XXXX@XXXXX.COM > schrieb im Newsbeitrag