Yup – true that.. and that sounds a lot more favorable than calculations in SQL as an upgrade would still preserve that customization just in case an upgrade on the DB changes the way that calculation needs to be done..
Joe From: Grooms, Frederick W Sent: Wednesday, May 09, 2012 10:00 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Direct SQL question - in Log file ARACTSQL("xxx",0,-1,-2,1000000161) ** True, but smiley could do something like Action 1 Set Fields setting a display only integer field to $SERVERTIMESTAMP$ Action 2 Direct SQL using the display only integer field (so there is no calculations in the direct SQL) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Tuesday, May 08, 2012 10:35 PM To: [email protected] Subject: Re: Direct SQL question - in Log file ARACTSQL("xxx",0,-1,-2,1000000161) ** 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"
