Re: Allowing users to enter leading characters in search menu field

[Rohini Prasher]

** Unsubscribe From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Joe DeSouza [joe_rem...@yahoo.com] Sent: Monday, July 13, 2009 10:59 PM To: arslist@ARSLIST.ORG Subject: Re: Allowing users to enter leading characters in search menu field ** Never tried it as yet but this does sound like an awesome feature..   Joe From: "marti...@ad.jmu.edu" <marti...@jmu.edu> To: arslist@ARSLIST.ORG Sent: Monday, July 13, 2009 1:20:12 PM Subject: Re: Allowing users to enter leading characters in search menu field ** Sounds great!  One more reason to keep moving in that direction.   Dwayne   From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Monday, July 13, 2009 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Allowing users to enter leading characters in search menu field   ** Another solution would be to upgrade to AR System 7.5.00 – which includes the Auto-complete capability on the web. Auto-completion in menus For forms that are viewed in a web browser, you can turn on an “automatic complete” feature for character fields that have a menu attached to them. When this feature is turned on for a field and a user begins typing text into the field, a list of values that match the text appears. When multiple values are presented, the user can change the selection with the up and down arrow keys or using the mouse. To select a highlighted option, the user presses Enter or clicks it.   To enable this feature, select the field in BMC Remedy Developer Studio, and set the Auto Complete and Auto Complete Match By properties accordingly. See the “Automatically completing menu entries” section of the Form and Application Objects Guide.   -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc.   The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc.   From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of marti...@ad.jmu.edu Sent: Monday, July 13, 2009 8:35 AM To: arslist@ARSLIST.ORG Subject: 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: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ DISCLAIMER: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ----------------------------------------------------------------------------------------------------------------------- _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_