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 <[email protected]> wrote:
From: Rajeev <[email protected]>
Subject: Re: Filter -- Push field If Qual failing due to Null values
To: [email protected]
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 <[email protected]> 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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
