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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
