Actually, that would fire any time the Billing_End_Date didn't change or was set to NULL (TR.Billing_End_Date will always be NULL unless the value is being changed to something non-null). He doesn't need to determine when it's null, just if it is being changed. In that case, since it does correctly fire in one case (where it's null in the DB but no in the updated record), it should also fire the other way around as well. If it doesn't, then that would probably be a bug and not be related to the NULL value relational Algebra. I think the relational Algebra discussion relates more to searches and may not apply here in this context. (I could be wrong on that point, but my first point above is correct.)
Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Charles Baldi Sent: Monday, September 28, 2009 3:23 PM To: [email protected] Subject: Re: Stumped - Need some fresh eyes ** If NULL is a valid value then you will need to test for it explicitly. Your qualification will be undefined if your field is NULL which will result in that clause being FALSE. See the "NULL value, relational Algebra" section of the Workflow Objects guide. Your qualification should be more like: 'Billing_End_Date' != 'DB.Billing_End_Date' OR 'TR.Billing_End_Date' = $NULL$ Regards, Chuck Baldi On Mon, Sep 28, 2009 at 5:14 PM, Lyle Taylor <[email protected]<mailto:[email protected]>> wrote: Perhaps it's a filter phasing issue. Probably any filters that update the record (in order to trigger this filter) need to be named with `! at the end to override filter phasing. Lyle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of PRUITT, CHRISTOPHER Sent: Monday, September 28, 2009 3:11 PM To: [email protected]<mailto:[email protected]> Subject: Stumped - Need some fresh eyes We are stumped on a filter that does not want to fire correctly. Here is the situation. We have an Asset record that has no billing end date set. We set the Billing End Date to the current date/time along with other fields and the filter with the Run If Qualification: 'Billing_End_Date' != 'DB.Billing_End_Date' fires, as expected. This filter is just setting a Audit Trail entry. Right after that, on the same record about 3-5 seconds later we set the Billing End Date back to NULL along with other fields and the same filter does not fire. This is happening inside of a Filter Guide process that calls two different Filter Guide. The first is Set the Asset to Inactive, the second is Set Asset to Active along with new Data. All the data gets set correct including the Billing End Date We do a move by first setting the data for the current Asset record that has Active Billing to Inactive and Set the Billing End Date along with other fields. Later in the Filter Guide process we take that same record and update the new data and reactivate the billing under the new person and set the Billing End Date to NULL. It should work right? Now here is the rub. If we set the Asset record by itself to Inactive and Set the Billing End Date the filter with the Run If Qualification: 'Billing_End_Date' != 'DB.Billing_End_Date' fires. Then is we set the Asset record by itself to active and Set the Billing End Date to NULL the filter with the Run If Qualification: 'Billing_End_Date' != 'DB.Billing_End_Date' fires. But not when we do it inside of a Guide. Anyone ever see this happen before? Our environment is: Oracle 10g Remedy 7.1.00 Build 200708221849 SunOS 5.9 Christopher Pruitt HP Enterprise Services Bank of America Account | CIA - Integrated Applications | IW Infrastructure Team 972.605.7702 office | [email protected]<mailto:[email protected]> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> Platinum Sponsor:[email protected]<mailto:sponsor%[email protected]> ARSlist: "Where the Answers Are" NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> Platinum Sponsor:[email protected]<mailto:sponsor%[email protected]> ARSlist: "Where the Answers Are" _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
