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:[email protected]] Im Auftrag von Zenith Victory
Gesendet: Dienstag, 3. Februar 2009 05:10
An: [email protected]
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 <[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]
<http://us.mc01g.mail.yahoo.com/mc/[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___
__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"
