Richard, Just a performance warning for you..that is an 'anywhere' like statement.and as such, CANNOT use an index, and because of that, is a horribly inefficient way to search and may cause performance issues depending on the size of the table being searched.just FYI.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Richard Copits Sent: Monday, October 18, 2010 9:24 AM To: [email protected] Subject: Re: Reminder search order... ** Great! Thank you! From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Meyer, Jennifer L Sent: Monday, October 18, 2010 10:00 AM To: [email protected] Subject: Re: Reminder search order... ** Richard, The search your workflow is currently performing is 'Full Name' LIKE "$Name%" You want to change your search to 'Full Name' LIKE "%$Name%" in order to search for anything containing that string. Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Richard Copits Sent: Monday, October 18, 2010 9:21 AM To: [email protected] Subject: Reminder search order... ** When we use Reminders and enter a user name and press Enter, it does a default search against the FullName field. If it doesn't find a match for the string starting from the beginning of the FullName field it errors out. So, if we search for "Smith" and there is no name beginning with "Smith" - no match. What we'd like to do is either show any user names containing "Smith" (John Smithson, Bob Smith, Deb Hammersmith) or at least a match on last name (Bob Smith). Is there any way we can do this? Thanks!! _____ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _____ E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _____ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
