Hi - thank you for responding. Actually I am trying NOT to update the original form HPD:Help Desk. That is why I created a 2nd form and a Join form - which joins HPD:Help Desk and the 2nd form.
I like the idea of using a Direct SQL though... because then I could have my new field on HPD:Help Desk form without causing all the filters to get triggered --- AND I would not have to Delete a row (not an Incident...) from that 2nd form. I could just blank out the userid value in the hidden field - via sql. I'll try that and see what happens. thanks -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, May 02, 2012 11:10 AM To: arslist@ARSLIST.ORG Subject: Re: How to Delete a row in Active Link I see more than one problem with that approach of 'pushing' info into that field that you create. This would mean that every time someone opens or closes a form (since the requirement is that it doesn't matter if they are updating it or not), there will be an update on the Last Modified Date as well as Last Modified By field as a result of the Push Fields action. The other problem I see with Push Fields is, that you unnecessarily would have to have the AR application to process the entire list of Filters on the incident form while performing that Push Fields, which would mean that you would need to modify a ton of workflow for certain conditions that might have actually prevented the modification of that record for whatever reasons (data validations being most of them). While the use of Direct SQL is not greatly encouraged in ARS development in your workflow, it is the ideal candidate for this requirement. A Direct SQL to set that flag will not alter the core user stamp and time stamp fields.. What I fail to understand is the need for deleting the incident? Can you shed some light as to why you need an incident to be deleted and the conditions under which you want that incident record to be deleted? Also what do you mean by 'new form name for the schema' in your syntax for the Application-Delete-Entry command?? Something tells me that you are 'expecting' this operation to do something way different than it is designed for.... Joe -----Original Message----- From: smiley Sent: Wednesday, May 02, 2012 10:32 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: 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 put my 'openedBy' field. I also added a Join form to join the new form to the HPD:Help Desk form. I added 2 filters - one on the Join form (on GetEntry - hope that works...) where the OpenedBy is Not Null, which produces the message. The other filter is on the Join form again - also on GetEntry - where the OpenedBy is Null. If it is null, then it does a Push Fields to update the new form with the OpenedBy =$user$, and OpenedDate = $timestamp$, and incident number and SRID and a couple other interesting fields. Qualification is Incident number = Incident number, if no match then create a new request. Now comes the problem that I'm stumped on. I added an Active Link (because it has the option for 'Window Closed') -- it has a Run if of Z1G Reopen Incident is not Reopen in Current --- AND Incident number not Null. The action is 'Run Process' command line Application-Delete-Entry "<new form name for the schema>" $Incident Number$. However.... I ONLY want to Delete the row if the Incident number matches AND the UserID matches the 'OpenedBy' value too!! Is there a way? Any other ideas?? Thanks for any help !!! __________________________________________________________________________ _____ 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"