I'm working upgrading ITSM from 7.6.04 to 9.1.02 and after getting
everything installed and started testing 9.1 only returns one support group
where as 7.6 returned both support groups assigned covering those
OpCats from the template search in Incident Management. I started digging
into the workflow and logging to see what the differences were. Aside from
the table qualification being different, the resulting SQL has a different
value in the SELECT part of the query. There are multiple columns in the
tables so I expected multiple fields in the SELECT part. I feel like I'm
just missing a basic bit of functionality of table fields, but I can't for
the life of me figure out how that is determined. Obviously the table
qualification makes up the WHERE clause, but how is the SELECT portion
determined if not by the columns(fields) selected in the table field?
Below are the two different queries.
7.6 -
SELECT TOP 3 T2074.C1 FROM T2074 WITH (NOLOCK)
WHERE ((T2074.C1000001437 = 'ESS Remedy ARSystem - Other') AND
(T2074.C4 = 'bgillock') AND (T2074.C1000000580 = 1)) ORDER
BY 1 ASC
9.1 -
SELECT DISTINCT TOP 302 T2074.C1000001437 FROM T2074
WHERE ((T2074.C4 = 'bgillock') AND
(T2074.C7 = 1) AND
(T2074.C1000000100 = 1) AND
(T2074.C1000000580 = 1) AND
(T2074.C1000001437 LIKE '%ESS Remedy ARSystem - Other%'))
ORDER BY 1 ASC
I created a new form with a table field just for my own sanity and it
behaved as I would expect, the SELECT contained all the fields I selected
to return to the table.
Thank you in advance!
--
Brian Gillock
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
