Well after more testing I still can't get this to work. Seems to work sometimes but not others. We have about 5 differerent email lists (aremail belongs to the lists) , when email is sent to one of these addresses it will open a ticket, the problem is the address could be anywhere in the To field, the CC field or the Bcc field. I first had a form that would hold all of the different lists and then the filter would look at the To, CC, and Bcc to see if the email address matched in the list if so it set a temp field that would be used to cut the ticket., but this didn't work on the filter I kept getting an error that said
"MessageType: 2 MessageNum: 313 MessageText: Data types are not appropriate for relational operation AppendedText: Message will be deleted without logging in email messages form because there is an error on submit." So I gave up on the separate form, and just tried to hardcode the addresses into a filter (I hate doing this) then looking at the To, CC, and Bcc fields, and setting a temp field to yes, then looking at this field to create the ticket, but this only worked the first couple of times and only if the address I was looking for was the first address in the field. It seems it doesn't read anything past the semicolon, and doesn't seem to read the Bcc field at all. I tried using like in the filter but no luck. ((( "%" + $To$) + "%" ) LIKE 'Incoming FCIRT Email Address') OR ((( "%" + $CC$) + "%" ) LIKE 'Incoming FCIRT Email Address') OR ((( "%" + $BCC$) + "%" ) LIKE 'Incoming FCIRT Email Address' I know all the lists have a Return-path: [EMAIL PROTECTED] If I look at the email's property details, but can't figure out if there is a way to use this. Of course all this has to be done and in production by this Friday. So at this point I guess I'm not even sure if this can be done. If anyone has any ideas, I would appreciate it. Thanks, Linda Blomberg Fermi National Accelerator Laboratory [EMAIL PROTECTED] _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, November 30, 2006 8:57 AM To: [email protected] Subject: Re: Filter help ** Instead of doing an equal match could you not do a like match: ( $To$ like '%Incoming FCIRT Email Address%') OR ( $CC$ like '%Incoming FCIRT Email Address%') OR ( $BCC$ like '%Incoming FCIRT Email Address%') (I am assuming here that Incoming FCIRT Email Address is the field from your email list form) However, this would not indicate where the email address was found - in the TO, CC or BCC field. Not sure if that is necessary. You might have to break this out into three seperate calls. On 11/30/06, Linda Blomberg <[EMAIL PROTECTED]> wrote: ** ARS 6.3 patch 18 Windows 2000 I need to have a filter that looks at the AREmail messages form to determine if a specific email address is somewhere in the To, CC, or Bcc fields, I have a form that holds all the email addresses that are valid, then in a filter on the set field if action I have ( $To$ = 'Incoming FCIRT Email Address') OR ( $CC$ = 'Incoming FCIRT Email Address') OR ( $BCC$ = 'Incoming FCIRT Email Address') This sets a temp field on AREmail messages form that I look for when the Helpdesk ticket (this is a home grown helpdesk form) gets created. But so far this only works if the first entry in the To, or CC field is a valid address if it's the second, third, etc, or a BCC it doesn't work at all. Any idea how I can get this to work? Any help is greatly appreciated. Please let me know if more information is needed. Thanks, Linda Blomberg Fermi National Accelerator Laboratory [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com <http://www.specificintegration.com> 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
