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!!!
>
>
> --
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
