I think David's suggestion to use the Drop-Down List option is the best solution for you. This was a great addition to ARS in my opinion (version 7 I think?) and eliminated the need for pattern matching against $MENU$ almost everywhere for me at the time.
-Rick ___________________________ Rick Westbrock QMX Support Services -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Thursday, February 21, 2013 7:17 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 Heba, If someone hasn't mentioned already, you could try setting the Display Type property of the field to "Drop-Down List". That should only allow people to select from the list. I had some issue with $MENU$ a while back, maybe on 6.x - but maybe it was my fault (user error). If you want to pursue it, maybe check the patches for your version to see - David Durling University of Georgia > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson, Douglas W. > Sent: Thursday, February 21, 2013 9:46 AM > To: arslist@ARSLIST.ORG > Subject: Re: $MENU$ pattern Problem in Remedy 7.6 > > >SQL might give you better clues directly. Suggest you turn on > >database logging, generate the error, then look in the log file to > >see what command was actually being sent to the database & resulted in the error. > > > >If the pattern match is not going to work, you can accomplish the > >same result via workflow. It's just more work. > > > >Best, > >Doug Anderson > >Mayo Clinic > > > > > >Original message: > >Date: Wed, 20 Feb 2013 12:52:41 +0000 > >From: "Heba Hashem, Vodafone Egypt" > <heba.has...@vodafone.com> > >Subject: $MENU$ pattern Problem in Remedy 7.6 > > > >Dears, > > > >Please I need a support form you as when I put $MENU$ pattern in some > >fields in Remedy 7.6 I can't submit any record on this form as I got > >the below error although when I remove them,it's working well. > > > >ARERR [552] The SQL database operation failed. : 536870935 > > > >ARERR [552] The SQL database operation failed. : 536870981 > > > > > >Heba Hashem > >SYSTEM ANALYST > >Customer Management > >Vodafone Egypt Telec. SA > >Mobile: +20 (10) 07033053 > >Email: heba.has...@vodafone.com > > > > > >[Vodafone]<http://www.vodafone.com.eg/> > > > >vodafone.com.eg <http://www.vodafone.com.eg > ><http://www.vodafone.com.eg/>> > > > > > > > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the > Answers Are, and have been for 20 years" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
