TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Alt Names search
From:
David Lowe <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 13 Mar 2014 15:37:55 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (710 bytes) , text/html (1037 bytes) 
I just added a bunch of Alt Names by using a SQL Insert function. These
names correctly appear in the Constituent records now. However searching on
these alt names doesn't return any hits.

For instance: Volney Isbell is (Name Type) Business Partner for the
studio Zeller & Isbell.
When I Find Constituent (Contains) "Volney", I get Zeller & Isbell.
When I Find Constituent (Contains) "Isbell", I get Zeller & Isbell
BUT when I Find Constituent (Contains) "Volney Isbell", I get nothing.

Any thoughts?

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2