Hi all -
I thought maybe I have my Direct SQL sort of working now. But I can't find
any evidence of an Update occuring. Any ideas?
Here is the Update statement in the Direct SQL:
UPDATE HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date =
DATEDIFF(second,'1970-01-01 00:00:00','$TIMESTAMP$')-144000 WHERE
Incident_Number = '$Incident Number$' AND Incident_Number != '' AND
UM_Opened_By = '';
In the Log file, (I'm on Mid-Tier ITSM 7.6.03) my Active Link got past the
Run If Qualifications and says it will run the Action 0. Then I get this
mysterious line in the log file -- ARACTSQL("<name of my AL>",0, -1,-2
1000000161)
Nothing past that, and the next active links run.
Here is the actual log file:
. . .
ActiveLink: +UM:HPD:INC:OnOpen_510_OpenedBy_Upd
True actions:
action 0
ARACTSQL("+UM:HPD:INC:OnOpen_510_OpenedBy_Upd",0, -1,-2, 1000000161)
. . .
Does anyone know where I find out what these parameters are? I know the
'1000000161' is the field id for Incident Number.
I'm looking in ARUtilities in the SQL part to see if the Update occured and
the 2 fields I'm trying to update are still blank:
SELECT
Incident_Number,UM_Opened_By,UM_Opened_Date,Last_Modified_By,Last_Modified_Date
FROM HPD_Help_Desk where Incident_Number='INC000000031823';
Thank you for any help!!!
--
View this message in context:
http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-question-in-Log-file-ARACTSQL-xxx-0-1-2-1000000161-tp7540392.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
