Those will work when used within Filter or AL workflow on with most other actions besides Direct SQL. I do not think those are available for use with Direct SQL.
From: Chuck Sent: Tuesday, May 08, 2012 7:54 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Direct SQL question - in Log file ARACTSQL("xxx",0,-1,-2,1000000161) ** So for my edification, why aren't you using the AR Time Functions? On Tuesday, May 8, 2012 2:20:28 PM UTC-5, smiley wrote: 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!!! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
