Search partial words on WSS lists, How can i do?

Hi

i am trying to search partial words on WSS issue lists , using the
serach box on the allitems page (not the global one in the top right
corner) to limit the search to the view.

How can i do ?. It works if i search full words like "house" or "bike"
but not if i use partial words ("hous" or "bik") , it does not work
with wildcards either ("hous*","bik*")

This looks a bit strange for a "full text" engine ...

ps: the search box in the list areas seems to be calling a different
stored procedure than the search box in the top right corner... so i
cant apply "carl lewis" suggestions on the stored procs...


Any body has an idea how to turn this partial serach ON? I have the
premium edition of SBS 2003

is it a programming issue or a param issue?

thanks
philippe

Lam
Tue Dec 13 19:44:10 CST 2005

Hi P.

As far as I know, WSS uses only full text search and does not allow
wild card search, espcially just on one list. Having said that, you
might want to look at this post if you feel like doing some coding:

http://groups.google.com/group/microsoft.public.sharepoint.windowsservices/browse_thread/thread/94ec93f5f6409c84/fbfcfabae5c4619f?lnk=st&q=sharepoint+wss+wildcard+search&rnum=6#fbfcfabae5c4619f

On the SPS side, there is an article on MS2D2 that help:

Adding wildcard search to SharePoint Portal Server
http://msd2d.com/newsletter_tip.aspx?id=95cb2617-e920-42f7-8cec-c148e623c33a&section=SharePoint


Regards,
Lam Le
store.bamboosolutions.com

philippehenri wrote:
> Hi
>
> i am trying to search partial words on WSS issue lists , using the
> serach box on the allitems page (not the global one in the top right
> corner) to limit the search to the view.
>

philippehenri
Fri Dec 16 12:03:26 CST 2005

Hi Lam Le

thanks for your answer.

i did the coding already and when searching i.e for "display",
Sharepoint returns also the document "displayform.aspx" and that kind
of documents !!! which obiously is not what we are searching !!! how
can we tell it not to search site pages !?

and also it does not limit the search the the current view. For example
it returns all history issues of an issuelist and not only the ones
with "current =3D Yes" ... :( which is not very cool either :(

any other brilliant idea?
thanks
philippe henri



Lam Le a =E9crit :

> Hi P.
>
> As far as I know, WSS uses only full text search and does not allow
> wild card search, espcially just on one list. Having said that, you
> might want to look at this post if you feel like doing some coding:
>
> http://groups.google.com/group/microsoft.public.sharepoint.windowsservice=
s/browse_thread/thread/94ec93f5f6409c84/fbfcfabae5c4619f?lnk=3Dst&q=3Dshare=
point+wss+wildcard+search&rnum=3D6#fbfcfabae5c4619f
>
> On the SPS side, there is an article on MS2D2 that help:
>
> Adding wildcard search to SharePoint Portal Server
> http://msd2d.com/newsletter_tip.aspx?id=3D95cb2617-e920-42f7-8cec-c148e62=
3c33a&section=3DSharePoint
>
>
> Regards,
> Lam Le
> store.bamboosolutions.com
>
> philippehenri wrote:
> > Hi
> >
> > i am trying to search partial words on WSS issue lists , using the
> > serach box on the allitems page (not the global one in the top right
> > corner) to limit the search to the view.
> >

philippehenri
Fri Dec 16 12:03:33 CST 2005

Hi Lam Le

thanks for your answer.

i did the coding already and when searching i.e for "display",
Sharepoint returns also the document "displayform.aspx" and that kind
of documents !!! which obiously is not what we are searching !!! how
can we tell it not to search site pages !?

and also it does not limit the search the the current view. For example
it returns all history issues of an issuelist and not only the ones
with "current =3D Yes" ... :( which is not very cool either :(

any other brilliant idea?
thanks
philippe henri



Lam Le a =E9crit :

> Hi P.
>
> As far as I know, WSS uses only full text search and does not allow
> wild card search, espcially just on one list. Having said that, you
> might want to look at this post if you feel like doing some coding:
>
> http://groups.google.com/group/microsoft.public.sharepoint.windowsservice=
s/browse_thread/thread/94ec93f5f6409c84/fbfcfabae5c4619f?lnk=3Dst&q=3Dshare=
point+wss+wildcard+search&rnum=3D6#fbfcfabae5c4619f
>
> On the SPS side, there is an article on MS2D2 that help:
>
> Adding wildcard search to SharePoint Portal Server
> http://msd2d.com/newsletter_tip.aspx?id=3D95cb2617-e920-42f7-8cec-c148e62=
3c33a&section=3DSharePoint
>
>
> Regards,
> Lam Le
> store.bamboosolutions.com
>
> philippehenri wrote:
> > Hi
> >
> > i am trying to search partial words on WSS issue lists , using the
> > serach box on the allitems page (not the global one in the top right
> > corner) to limit the search to the view.
> >