Dwayne, I believe that....
If the user fails to enter a value in the Diary field then the filter (during a Set Field action, or other such reference to the field) will see the whole DB value for the field. [ This is really a function of how the 'Field' value vs 'TR.Field' vs 'DB.Field' stuff works.] So one way to "fix" this is to test to see if the 'Field' = 'DB.Field', if so then there is no addition to the field and you need to force a filter to add a "dummy entry" or throw an error and force the user to make an entry. 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/28/07, Dwayne Martin <[EMAIL PROTECTED]> wrote:
Hi Everyone, We have a call entry form. Whenever someone besides the assignee modifies the form, a filter sends an email to the assignee. The filter runs on "Modify" and "Runs If" 'Assigned To' != $USER$. One of the fields in this email is "Work Log", a diary field. The Email message says ". . .Work Log: $Work Log$. . ." (as opposed to choosing the field in "Include Fields"). What is supposed to happen is that the email includes the Work Log value written in the WUT screen, and sometimes it does. But other times it includes the whole database Work Log, complete with integer dates, and squares for unprintable characters. Any idea why it would do this and how we can stop it? (ARS 6.3, HPUX-11 server, Oracle 9.2 db) Dwayne Martin Computing Support James Madison University
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
