One possible approach:
In active-link #1 - set a date/time field with $TIMESTAMP $ plus ## seconds. - Display a message to the user. In the message include text such as 'Please wait ## seconds' before clicking OK' In active -link #2 - Run If: $TIMESTAMP $ < $zTmpDateTime$ - Set $zTmpInt$ to $zTmpDateTime$ minus $TIMESTAMP $ - Set Fields with the wait command using the remaining seconds. HTH Stephen ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Friday, August 10, 2007 1:50 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow SOLVED ** Hi Stephen/Dwayne I was trying the SQL statement, but the problem I have is; I do a Set Fields in a field, something like Please Wait... and then call the WAITFOR DELAY command, but instead of the field being set with the message frst and THEN the delay happening, the delay happens first and the message gets displayed afterwards!! completeley backwards! I tried doing with 2 seperate Active Links, no luck, it goes into the delay immediately, and displays the message afterwards. Any ideas? thanks a lot shafqat Dwayne Martin <[EMAIL PROTECTED]> wrote: The "set fields" option worked! In the active link I set a display field to equal "$PROCESS$ @@:/opt/remedy/HelpDesk/pause 3". (Anything over 3 seconds and the action would time out.) The filter was the same but without the "@@:". In both cases the hour glass displayed for three seconds then I got the message. I tried Stephen's "WAITFOR DELAY '00:00:10'" option, but I got "invalid SQL statement". Is that an Oracle statement? I looked in my Oracle book but can't find any "wait" command. Anyway, Thank you Stephen and Fred. You've solved my problem. Dwayne Martin ---- Original message ---- >Date: Thu, 9 Aug 2007 16:46:02 -0400 >From: "Heider, Stephen" >Subject: Re: Inserting pause in workflow >To: arslist@ARSLIST.ORG > >Another option is to use your RDBMS. For SQL Server, > >Set Fields SQL > WAITFOR DELAY '00:00:10' > >Stephen > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W >Sent: Thursday, August 09, 2007 4:43 PM >To: arslist@ARSLIST.ORG >Subject: Re: Inserting pause in workflow > >Do the PROCESS inside of a Set Fields Action > >A Run Process action does not wait. A PROCESS inside of a Set Fields >action waits for the external program to complete. > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 >CS/SCCE >Sent: Thursday, August 09, 2007 3:23 PM >To: arslist@ARSLIST.ORG >Subject: Re: Inserting pause in workflow > >I could be mistaken about this, but I believe the way it works is, when >Remedy runs an external process, it does NOT wait for the external >process to finish executing before it continues workflow processing. > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Thursday, August 09, 2007 3:05 PM >To: arslist@ARSLIST.ORG >Subject: Inserting pause in workflow > >Hello Everyone, > >(ARS 7.01 patch 2, Linux server, Oracle 10.2 db) > >How do you insert a pause in an active link or a filter? > >I have heard that you should run a process then call that process. So I >have a "pause" program on our server that says "sleep $1". On the >server if I enter "/opt/remedy/HelpDesk/pause 10" it waits ten seconds >then returns the cursor. > >So I set up both an active link and a filter to do the "pause 10" >command then send a message. >The active link does a "Run Process" of "@@:/opt/remedy/HelpDesk/pause >10". The filter is the same but without the "@@:". In both cases I get >the message right away. > >The active link log shows: > Process: /opt/remedy/HelpDesk/pause 10 > Success > >The filter has a "`!" after it to make it run in phase 1, and the filter >log shows it running before the message, but the message still appears >right away. > >What am I doing wrong? > >Is there a better way of solving this altogether? It seems like pausing >is such a normal thing to do that there should be a built-in Remedy >function. > >Dwayne Martin >Computing Support >James Madison University > >_______________________________________________________________________ _ >_______ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >the Answers Are" > >_______________________________________________________________________ ________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Dwayne Martin Computing Support James Madison University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Shafqat Ayaz "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.." ________________________________ Be a better Heartthrob. Get better relationship answers <http://us.rd.yahoo.com/evt=48255/*http:/answers.yahoo.com/dir/_ylc=X3oD MTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTklf MzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545433> from someone who knows. Yahoo! Answers - Check it out. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"