The TO, CC, and BCC fields on the Email Messages form are all 32,000 characters long.
You probably need to create 4 display only temp fields to hold your ConfigRecord addresses. Use 2 filters. The first just gets the ConfigRecord data into the display only fields. The second does a comparison in the Run-If to set your final fields. This way you are not comparing long fields in an SQL lookup. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, March 23, 2007 8:19 AM To: [email protected] Subject: Re: Filter qualification help Linda, I have not looked at your search conditions in your Set Field action(s), but I would bet that you are trying to do an equal search on a "long text field" on the remote form. If you look at the fields that your searching on you will likely find that there length is "large". ( I think >4000 will cause the message. ) BTW: This is an RDBMS "thing" and has nothing to do with ARS code. And as such the limits/effect may be varied based on the RDMBS your using. :) 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 3/22/07, Linda Blomberg <[EMAIL PROTECTED]> wrote: > I am trying to run a filter on the AR system Email Messages form. > This filter will run on all incoming email messages. I'm doing a set > field that is reading the value from another form (FCIRT:ConfigRecord) > that has 4 different email addresses in it, if anywhere in the To, CC > or BCC fields there is an address match in the FCIRT:ConfigRecord then > two fields zTmp (Character field) field should be set to the submitter > and field zTmpClientName (Character field) should be set to FCIRT, > then I have other workflow that should fire if zTmpClientName equals > FCIRT. The problem is the email is getting an error in the AR System > Email Error Log saying Message Type SEVERE, Message Number 4952 > 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. > > I've been working with Remedy on this for about a week, but we don't > seem to be getting anywhere. Can anyone tell me what I might be doing wrong? (I've attached the filter in question) We are running ARS, and aremeail 6.3 patch20. > Any help would be greatly appreciated. > > Thanks, > Linda Blomberg > Fermi National Accelerator Laboratory > [EMAIL PROTECTED] ________________________________________________________________________ _______ 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"
