Custom Field Update Rule changed in upgrade to K1000 7/8
We just updated to the latest version of K1000 server and I see the documents about the changes but I don't understand how to get my UPDATE query to work on my rule to add a site location-being pushed from AD.
Can anyone provide a bit more guidance?
Here is what I have now (to add a site location-being pushed from AD):
SELECT HD_TICKET.ID AS ID FROM HD_TICKET
JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID)
WHERE HD_TICKET.SUBMITTER_ID <>0
UPDATE HD_TICKET T
JOIN USER S ON (S.ID = T.SUBMITTER_ID)
SET T.CUSTOM_FIELD_VALUE1 = S.LOCATION WHERE T.ID=<TICKET_IDS>
I see that the column is no longer located where it was but I cannot figure out the proper SQL syntax. It seems to fail on the UPDATE Query according to the logs.
New Location of Custom Fields
(this is from the support document)
JOIN ASSET on USER.LOCATION_ID = ASSET.ID