Yes, it should work. If you format the LIKE statement correctly, it should work.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Wednesday, September 05, 2007 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu many thanks for this feedback. I believe it will most probably work this way. How ever, I am working on something pretty close to this idea. And I am encountering a problem which I believe I will also have when trying your solution. It is the following: in the field where users type in, they insert email addresses. They do so by typing each email address on a new line. And at the moment what I don't get the Remedy do is to compare correctly something like (("%" + $CC list$) + "%") with the $mailing-list$ field. That doesn't simply work. I am wondering whether this is my mistake somewhere or this because of the every line on my original field ?!? Will it work correctly with the solution you are giving ?? ... Serouche Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > Does this have to stay as a file? If not, save a copy of the file as a > CSV. Then create a new support form with one field on it. Call that > field "Email" or whatever you want. Use the import tool to import the > email addresses in the file (which is now a CSV) into the form. Now you > have one Remedy record for every entry in the file. > > Now just automate what you want to do with workflow. Put a hidden field > under your character field on form B, and on Submit (or whatever event > you want), do a SET FIELDS. Set the hidden field if... > > Character Field on Form B = Record in New Form You Just Created > > Then have a second active link that throws an error if the hidden field > is not null. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour > Sent: Wednesday, September 05, 2007 7:54 AM > To: arslist@ARSLIST.ORG > Subject: Re: how to read the whole content of a drop-down menu > > what I mean is that Remedy users type in what they are by policy not > allowed to type i.e mailing-lists > these mailing-lists are in a file outside the Remedy > so my problem is: how can I make the Remedy read the file, compare the > content with what people type. And every time a user type in something > which is found in that file, the Remedy should say "error guy !" > The file is about 900 lines with one value per line. Of course I could > change the format of the file (still being always on my Unix box). > The field where people type in is a character field. > Any help ? > > > > Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > >> What do you mean by "...bounce people from adding mailing-lists into >> the CC list field"? Do you mean you want to force people to use the >> values as presented in the menu and prevent them from typing stuff in? >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour >> Sent: Wednesday, September 05, 2007 2:43 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: how to read the whole content of a drop-down menu >> >> maybe I shall give more details on my problem and the situation: >> I have a file with a list of mailing-lists >> I have created a form (A) with one character field which reads the >> > file > >> and displays it as a menu >> I have another form (B) with a character field where people add emails >> > > >> (CC list). >> What I'd like to do is to bounce people from adding mailing-lists into >> > > >> the CC list field. :-) >> ... >> I can't get it :-( >> ... >> any help ? >> Thanks >> Serouche >> >> >> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >> >> >>> Or better yet, create a form specifically for the menu items and then >>> importing the items from the file into the form? Then field >>> > validation > >>> is extremely easy...and you don't have nitnoid separate files to >>> maintain. >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser >>> Sent: Tuesday, September 04, 2007 12:24 PM >>> To: arslist@ARSLIST.ORG >>> Subject: Re: how to read the whole content of a drop-down menu >>> >>> ** >>> Have you tried pulling the file that your menu reads from into an >>> unlimited length, display only field and then using string functions >>> (such as STRSTR) to find if the value entered is in the list? >>> >>> If that doesn't work maybe a run process utilizing grep or find? >>> >>> Thad Esser >>> Remedy Developer >>> "Argue for your limitations, and sure enough, they're yours."-- >>> >>> >> Richard >> >> >>> Bach >>> >>> >>> >>> "Serouche Rahimpour" <[EMAIL PROTECTED]> >>> Sent by: "Action Request System discussion list(ARSList)" >>> <arslist@ARSLIST.ORG> >>> >>> 09/04/2007 08:33 AM >>> Please respond to >>> arslist@ARSLIST.ORG >>> >>> To >>> arslist@ARSLIST.ORG >>> cc >>> Subject >>> Re: how to read the whole content of a drop-down menu >>> >>> >>> >>> >>> >>> >>> I just tried with $MENU$ and the browser (because it has to be on the >>> > > >>> web) returns $MENU$ in the field. >>> I checked afterwards in the Admin tool. It has corrected $MENU$ for >>> "$MENU$" >>> Another idea ? >>> >>> >>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >>> >>> >>> >>>> I'm not sure if it works with menus built from external files, but >>>> >>>> >>>> >>> have >>> >>> >>> >>>> you tried $MENU$? >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour >>>> Sent: Tuesday, September 04, 2007 10:19 AM >>>> To: arslist@ARSLIST.ORG >>>> Subject: how to read the whole content of a drop-down menu >>>> >>>> hi, >>>> >>>> let say I have a drop-down menu which values come from a Menu which >>>> reads itself from a file. >>>> Let say on another form I have a character field and I want to check >>>> >>>> >>>> >>> the >>> >>> >>> >>>> content of this field (what users type in) is or is not in the >>>> >>>> >>>> >>> drop-down >>> >>> >>> >>>> menu. >>>> I tried with different filters and AL but each time I am not able to >>>> > > >>>> read the whole list (about 900 entries in the drop-down list.) >>>> Any idea/help/questions? >>>> Many thanks. >>>> Cheers >>>> Serouche >>>> >>>> >>>> >>>> >>>> > ________________________________________________________________________ > >> >> >>> >>> >>> >>>> _______ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> >>>> >>>> >>> ARSlist:"Where >>> >>> >>> >>>> the Answers Are" >>>> >>>> >>>> >>>> >>>> > ________________________________________________________________________ > >> >> >>> _______ >>> >>> >>> >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> >>>> >>>> >>> ARSlist:"Where the Answers Are" >>> >>> >>> >>>> >>>> >>>> >>>> >>> >>> > ________________________________________________________________________ > >> >> >>> _______ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> >>> >> ARSlist:"Where >> >> >>> the Answers Are" >>> >>> >>> >>> >>> ***IMPORTANT NOTICE: This communication, including any attachment, >>> contains information that may be confidential or privileged, and is >>> intended solely for the entity or individual to whom it is addressed. >>> >>> >> If >> >> >>> you are not the intended recipient, you should delete this message >>> > and > >>> are hereby notified that any disclosure, copying, or distribution of >>> this message is strictly prohibited. Nothing in this email, including >>> any attachment, is intended to be a legally binding signature.*** >>> >>> >>> __20060125_______________________This posting was submitted with HTML >>> >>> >> in >> >> >>> it___ >>> >>> >>> >>> > ________________________________________________________________________ > >> _______ >> >> >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> >>> >> ARSlist:"Where the Answers Are" >> >> >>> >>> >>> >> > ________________________________________________________________________ > >> _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > ARSlist:"Where > >> the Answers Are" >> >> >> > ________________________________________________________________________ > _______ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > ARSlist:"Where the Answers Are" > >> >> > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
