question on Incident Console Window Open vs. Search Incident Window Open

hello all! I am having difficulty with a process I'm trying to add to the Incident page (HPD:Help Desk) when the Window has been Opened on an Incident. (Active Link on Window Open) Evidently, in ITSM (version 7.6.03, mid-tier, windows), if one Searches for an Incident and single or multiple

Direct SQL in Active Link problems

Hi all - This Direct SQL seems like it should work, but I am getting an error message (in Mid-Tier, 7.6.03). UPDATE HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date = DATEDIFF(second,'01/01/1970 00:00:00','$TIMESTAMP$') +14400 WHERE Incident_Number = '$Incident Number$' ; The

Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

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

to commit or not to commit... that is the question

Hi all - I would like to know if the following will automatically 'commit' to the database for me or not: -- Direct SQL with an Update command -- Push fields (destination=Server, Form = Same form as the AL's Primary Form) Or do I have to specifically request a commit? I am hoping that the

Re: to commit or not to commit... that is the question

okay I see that Direct SQL will do a 'commit' for me. (I'm in ITSM 7.6.03 on MS sql server) In an Active Link. But I don't see why 'Push Fields' wouldn't do a commit for me too. So if they both do 'commits' for me without being specified, I think the Direct SQL will NOT trigger the filters

Re: to commit or not to commit... that is the question

I'm looking at the Help documentation about Direct SQL's: (note it says 'non-AR' databases... but I need to update an AR database...) Use the Direct SQL action to submit any legal SQL command to a non-AR System database. Use this command only if it is required for integration with another

Re: to commit or not to commit... that is the question

So how would I format this SQL statement??? There doesn't seem to be any info there about updating a field on an AR system form... example: UPDATE HPD:Help Desk SET UM_Opened_By = '$USER$' WHERE '$Incident Number$' = 'Incident Number'; Since they (BMC) don't want you to do it, then they don't

Re: Odd thing - 2 AL's - One runs other doesn't, same Execution options

Found it! One of the AL's had 2 forms defined in the 'Associated Forms' area. Therefore the 2nd form caused that AL to run, and the other AL was never invoked because its 1 form was not opened. -- View this message in context:

Re: to commit or not to commit... that is the question

Hi all - Wow - I was able to run a SQL statement in ARUtilities! SELECT * FROM HPD_Help_Desk And I can see all the column names but have no clue how to map them to the name of the fields... (Thank you JLBess and Axton for your replies!!!) how can I find the name of my new columns so I can

Re: to commit or not to commit... that is the question

Hi Joe! I only did the Select * because I'm trying to find out the NAMES of the COLUMNS so I can find my fields. I hope to use the Direct SQL to update my fields as to who is in the incident and at what time-stamp. so my final SQL will be something like: UPDATE HPD_Help_Desk SET $xxx$ = $USER$

Re: to commit or not to commit... that is the question

Yes! that is it! Thank you!!! -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7535900.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

Re: to commit or not to commit... that is the question

well close but still no cigar. I'm in ARUtilities in the SQL section, to see the views and columns. If I do a simple SQL like this - SELECT * FROM HPD_Help_Desk --- what I see are rows with COLUMN names. The COLUMN NAMES are: Column 1, Column 2, etc until I see Column 237... which

Re: to commit or not to commit... that is the question

Hi again - Here is my (hopefully) correct Direct Sql (which is an Action within my Active Link): UPDATE HPD_Help_Desk SET C95018 = $USER$, C95019 = $TIMESTAMP$ WHERE C100161 = $Incident Number$ The 'C' numbers are my Field ID's. I'm not sure if I'm supposed to indicate the form

Re: to commit or not to commit... that is the question

Hi Dave - I need to NOT trigger the Filters when I set this field. The purpose is to set a field that says hey! I'm already opened by this user id! back off!... :) Hope that helps -- View this message in context:

Re: to commit or not to commit... that is the question

Yes. Sorry don't know another way to reply. It looks fine to me in nabble because I'm using 'Threaded' view. :) -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536404.html Sent from the ARS

Re: to commit or not to commit... that is the question

oh yes I get the emails too... so you Reply to the email? -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536442.html Sent from the ARS (Action Request System) mailing list archive at

Odd thing - 2 AL's - One runs other doesn't, same Execution options

Hi! This is so odd. I did a flush cache on our server, and I have 2 Active links that BOTH are Enabled, order 220 and order 222, 'Display' and 'Window open'. Regardless of the Run If Qual, they should BOTH show up in my log file! Only the 1st one does. (it fails the qualification - but that

Re: Odd thing - 2 AL's - One runs other doesn't, same Execution options

Hi! Same permissions on both. same associated form on both. thanks I'm just now changing the names to be more different have to flush cache for that to 'take'. -- View this message in context:

Re: Odd thing - 2 AL's - One runs other doesn't, same Execution options

I had both 'Display' AND 'Window open' for BOTH of the AL's. But since you said that, I just changed both of them to 'Display'... since I care only about if it has a Row. I'll flush cache in 2 min's and then test again and we'll see... on the closing AL, i had 'Window Close' but maybe I really

Re: Odd thing - 2 AL's - One runs other doesn't, same Execution options

More Oddness!!! I changed the names of the Active links... and I flushed the Cache, and synced it. my new names are not in my log file... still the old name - and still only the 220, not the 222 Active link. I've heard we have to flush cache multiple times for something to take, but this is

Re: Nested Active Links

HI I think I sort of did this with Filters. But anyway, it sounds like you want to Loop the Loop. How about you have the 1st loop (the one you have already) at order 400 - in an Active Link calling an Active Link Guide that loops through the 1st table field. Then have the 2nd loop (the one you

Re: BMC Communities request

This ARSList is so much better than BMC Communities. Easier to use... Faster responses... I think you should just ask this group for ideas on how to do this task, not say 'has anyone done this before'... chances are they haven't but they know how to start. Just my opinion! -- View this message

How to Delete a row in Active Link

Hi all - I'm on 7.6.03. I'm trying to produce a popup message in Incident Mgt when a user opens an existing Incident While another User has it already open. (doesn't matter if they are updating it or not) I'm not allowed to change the Last Modified date, so I figured I needed another form to

question on when a Filter with Modify option will run

Hi all - I'm having some trouble with a filter not running as expected. I have an Escalation that runs every X nbr of minutes, and it sets a flag on a form. And I have a Filter that needs to pick up that the flag on that form is set now - the value has changed. I thought that the Filter would

Re: question on when a Filter with Modify option will run

I found it! I looked for a filter on that form, that had Execute on Modify, and had an error message. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/question-on-when-a-Filter-with-Modify-option-will-run-tp7496015p7496670.html Sent from the ARS (Action