Hello listers -
We've run into an interesting issue. In IM 9.0 we can select New Incident,
then fill out a caller's information.
The we select the decision tree link/button and it opens the trees.
Then when we select one it should open the branch window. It opens an empty
window.
In ITSM 8.1 it works - and it's all the same base product code. If you happen
to have ITSM 9 and a couple of seconds to spare can you try this?
Also for fun I compared the SQL and ARS 9 has a bunch of stuff I don't get -
like random "N"'s in the SQL
Older working server query:
SELECT * FROM ( SELECT
T1031.C1,C1000004224,C1000004241,C1000004130,C1000004239 FROM T1031 WHERE
((T1031.C1000004215 = 'PDT000000000002') AND (T1031.C1000004224 = 0) AND NOT
((' ' LIKE (('%' || T1031.C1) || '%'))) AND (T1031.C7 = 1)) ORDER BY
C1000004215 ASC,C1000000244 ASC, 1 ASC ) WHERE ROWNUM <= 2
New-fangled what is this stuff query:
SELECT * FROM (SELECT AR_SQL_Alias1 FROM (SELECT T1031.C1, T1031.C1000004239,
T1031.C1000004130, T1031.C1000004241, T1031.C1000004224 FROM T1031 WHERE
((T1031.C1000004215 = N'PDT000000000002') AND (T1031.C1000004224 = 0) AND (NOT
(N'%'||T1031.C1||N'%' LIKE NULL)) AND (T1031.C7 = 1)) ORDER BY
T1031.C1000004215 ASC, T1031.C1000000244 ASC, T1031.C1 ASC) AR_SQL_Alias1 > 0)
AND (AR_RowNumber_Alias$1 < 3))
William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
