RE: Lookup field search

Tech-Archive recommends: Fix windows errors by optimizing your registry

Javier,

What you are trying to is a common problem with a lot of WSS users. The
problem is that WSS uses SQL full text indexing for searching at the
web/library level, because SQL is doing the searching it’s not aware of
SharePoint Services internal storage methods and can not transform a users ID
(what is stored internally in the database) to a user name. You could try
and use SharePoint Portal server’s searching as this is can crawl a WSS web
internally or via http (which would produce the results you are after).

Craig Harrowfield
Senior Solutions Consultant - OBS
Blog: http://harrowfield.blogspot.com


"Javier" wrote:

> I created a list for customer issues and instead of typing the customer name
> I created a lookup field to select the customer from the contacts list. This
> works really well but if I do a seach the record does not show since the
> customer name was not actually typed. This happens too with calculated
> fields. Is there a way to make the lookup info and calculated fields to be
> stored on the record so it can be searched???
.

Relevant Pages

  • Re: Lookup field search
    ... With the restriction that SharePoint Portal Server's searching is only ... > What you are trying to is a common problem with a lot of WSS users. ... >> I created a list for customer issues and instead of typing the customer ... Is there a way to make the lookup info and calculated fields to ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Search in sites (Full Text Search)
    ... After the installation of Full-text searching in SQL and enabling it at WSS ... central administration page, this feature should be available to you by ...
    (microsoft.public.sharepoint.portalserver.development)
  • Ixprim CMS 1.2 Remote Blind SQL Injection Exploit
    ... # header> Ixprim 1.2 Remote Blind SQL Injection Exploit ... # status> Searching if someone posted a comment ...
    (Bugtraq)
  • Re: Writing custom stored procs against the WSS database
    ... But the Url property of the SPSearchResult object is the WSS ... I know Sharepoint Portal Server has more robust searching ... But this will hit the WSS database at least one more time ...
    (microsoft.public.sharepoint.windowsservices)
  • Pass-thru SQL performance vs Stored Proc
    ... answers to my question searching Google Groups. ... pass-thru SQL code? ... I thought I read somewhere that SQL-Server will cache in-line SQL calls ... Right now all our code is in stored procs. ...
    (microsoft.public.sqlserver.programming)