Listers,
Posting again - there was an error in my earlier post + added more details.
------
I have come across an issue, possibly a bug.
I have a filter on a regular form that is doing a set fields action
The set fields is doing a lookup from a join form to bring the values
The Set Fields If (earlier post had Run If) qualification looks something like
this:
('Instance ID' = $Instance ID$ AND (EXTERNAL ($External Qual$))
The $External Qual$ value is based on user preference settings and cannot be
modified. The fields used in the $External Qual$ are referencing the Join Form.
The option to change the field types on any of the forms does not exist.
As an example the 'External Qual' field has the value: ('Status' = "Assigned"
AND 'Work Log Type' != "General Information")
-- 'Status' is a selection field and coming from the primary form that
makes up the join
-- 'Work Log Type' is a selection field and coming from the secondary form
that makes up the join.
When the qualification has a selection field that is coming from the primary
form that makes up the join, then the set fields behaves as expected, bringing
the values back that match the Set Fields If qualification
However, when the qualification has a selection field that is coming from the
secondary form that makes up the join, then the set fields behaves as though
that selection field part of the qualification does not even exist.
Not sure any of you have come across this issue and if there is a workaround or
another way to overcome this issue. Any suggestions/input is valuable
Here's the environment details:
AR Server 7.1.0 Patch 6 on Linux
Oracle 10g R3 on Linux
ITSM 7.0.1 Patch 9
Thanks in advance,
--
Shyam
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
