Because of a 'bug' that functions 'as designed' in the Remedy code that replaces null values with the character string " "
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, July 13, 2009 10:08 AM To: [email protected] Subject: Re: Allowing users to enter leading characters in search menu field SOLVED ** Thanks, Conny! That works! But WHY does it work? There is no space in the Department field. Dwayne From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Conny Martin Sent: Monday, July 13, 2009 11:53 AM To: [email protected] Subject: AW: Allowing users to enter leading characters in search menu field ** 'Department' LIKE ($1000000000$ + "%" ) or $1000000000$ = " " don't forget the blank between the double quotes HTH Kind Regards Conny _____ Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von [email protected] Gesendet: Montag, 13. Juli 2009 17:35 An: [email protected] Betreff: Allowing users to enter leading characters in search menu field ** Dear List, I have a "Department" field (field ID 1000000000), with choices listed in a "Department Form." I want users to be able to either click on the Menu button and see all choices, or enter one or more leading characters and see the choices that begin with those letters. (Eg, type in "Eco" and then see "Ecology" and "Economics" in the menu.) If I have no qualifications in my menu it shows all choices. If my qualification says: 'Department' LIKE ($1000000000$ + "%" ) It works if the user enters a leading letter or two, but if there are no leading letters it says, "(No entries in menu)." I tried: $1000000000$ = $NULL$ OR 'Department' LIKE ($1000000000$ + "%" ) But still got "(No entries in menu)." 'Department' LIKE ( "%" + $1000000000$ + "%" ) works if there are no leading characters, but if there are leading characters, it offers choices in which the leading characters appear anywhere in the Department name. (Workable, but not ideal.) Any suggestions? (ARS 7.1 p3, RH Linux server, Oracle 10.2) Dwayne Martin James Madison University _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
