Dan, Or... You could change the returned value to have an embedded separator that an Active Link "finds" and moves the "value" off to where ever it needs to go and the Label part to the "right place" too.
So if the menu is... this\ that\'Status' = "Foo" other\'Status' = "Bar" Then you could make the menu this... this\ that\that!!!'Status' = "Foo" other\other!!!'Status' = "Bar" Make an active link move the part before the "!!!" separator and/or move the part after the separator. Just a few STRSTR() and SUBSTR() functions to get the task done. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Wed, Aug 6, 2008 at 9:37 AM, Reiser, John J <[EMAIL PROTECTED]> wrote: > ** > Dan, > Character menus are designed to show the Label and post the value. > If this is an aesthetics issue then you need to change the menu type or use > some trickery. > Overlay the character menu with a character field, hide it and make it > appear when you select the menu item. You will have to add an Active > Link with an SQL set fields action to fill the new filed with the menu > label. > The Character Menu ID is stored in the char_menu table and the menu items > are in the the char_menu_list table. > > psuedoSQL here. > > SELECT label from char_menu_list WHERE value = '$menufield$' and > charMenuId = (select charNumId from char_menu WHERE name = '<name of your > character menu>') > You will have to play around with the syntax because your $menufield$ will > equal things like 'Status' = "open" and the ticks and quotes need to be > delimited. > > Once you get the select statement correct you set the new overlay field with > the return value and show it with a change action. Sizing it correctly will > make the transition seamless to the end user. > > HTH, > > > > John J. Reiser > Software Development Analyst > Remedy Administrator/Developer > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of ARS Dummie > Sent: Wednesday, August 06, 2008 5:08 AM > To: [email protected] > Subject: Re: Displaying search menu's label after selecting it > > ** > Hi John, > > thanks for the explanation. > > I am using a character menu. Means a menu which should only run hardcoded on > that specific form. Sorry for the misunderstandings before. I just want to > run this menu on that form and I would not like to use another form to fill > in the data to that menu (as a search menu would do). For sure this is much > nicer and flexible. > > But I was just wondering if there is no way to display the menu label > instead of the menu value after selecting an entry from the menu. > > Dan <snip> >>> ----- Original Message ---- >>> From: ARS Dummie <[EMAIL PROTECTED]> >>> To: [email protected] >>> Sent: Monday, August 4, 2008 12:36:13 PM >>> Subject: Displaying search menu's label after selecting it >>> >>> ** >>> Hi listers, >>> >>> actually I think it should be easy... >>> >>> I have a search menu with different labels than values (I wanna use the >>> values as an EXTERNAL qualification of a table field). >>> How can I get the search menu's label displayed in the selection field >>> after the user selected an entry from the menu? After selecting an entry >>> there is always the value displayed. >>> For example: I have a menu label ... All open tickets ... and a menu >>> value ... 'Status' = "open" ..., and after selecting this value there is >>> always the qualification displayed instead the label "All open tickets". >>> >>> Thanks for your help in advance. >>> >>> Dan _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
