try this ( $Disp Val$ = 'SS Disp Name' ) AND (( $Soft Version$ = 'SS Version' ) or (($Soft Version$ = $NULL$) and ('SS Version' = $NULL$))) Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Zenith Victory Gesendet: Dienstag, 3. Februar 2009 05:10 An: arslist@ARSLIST.ORG Betreff: Re: Filter -- Push field If Qual failing due to Null values ** Hello! Below is the actual push fields if qualification. No problems with the first part of the qualification and as it is a required field and values always exist. If the version is null then on both the target and source forms, then it is not able to find the existing entries. ( $Disp Val$ = 'SS Disp Name' ) AND ( $Soft Version$ = 'SS Version' ) Thanks! Vicky --- On Mon, 2/2/09, Rajeev <t239...@gmail.com> wrote: From: Rajeev <t239...@gmail.com> Subject: Re: Filter -- Push field If Qual failing due to Null values To: zenith_vi...@yahoo.com Date: Monday, February 2, 2009, 9:54 PM Hi Vicky, Have you tried comparing the field with the keyword $NULL$ ? If you dont mind, can you paste the qual and I am sure that someone if not me woudl respond with the modification that you would need in the qual. Having said that , what you need to add in your qualification is perhaps "AND 'Field X' != $NULL$ Hope this helps. Regards Rajeev On Tue, Feb 3, 2009 at 8:47 AM, Zenith Victory <zenith_vi...@yahoo.com <http://us.mc01g.mail.yahoo.com/mc/compose?to=zenith_vi...@yahoo.com> > wrote: ** Hello! Need help with the following. Environment: ARS 6.3;Oracle;AIX;ITSM 5.5 Trying to create a new request(record) by a 'Push Fields' filter action in the target form, basing on the 'Push Fields If' qualification.If 'Field 1' valuein Source form 'A' is equal to 'Field X' value in Target form 'B' AND 'Field 2' value in Source form 'A' is equal to 'Field Y' value; then; 'If No Requests Match' -- Create a new request; 'If any requests match' -- Take no action. Above qualification is working fine as long as the value is not equal to null. We have recurring examples of where 'Field 2' and 'Field Y' are 'null' values. During which, the push field if qualification is not able to identify an existing record and thereby this filter is creating a new record everytime resulting duplicate records. I ran the corresponding query in the database. 'Field 1 = NULL is not returning any records. 'Field 1' IS NULL is returning the exact matching records.What is the Remedy syntax/qualification that I can use in the push field if qualification to achieve the 'IS NULL' result where it is idenfying the existing records with null values. Your assistance is appreciated. Thanks! Vicky __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"