Brent, You can either use a setfield run process, which will make additional actions wait till the process is done, but if your script takes more than 60 seconds (the maximum value of the set fields run process), then this solution won't work. If that's the case, here is my recommendation
Create an AL Guide Inside that guide create an AL that checks for the 'process done' record If it exists, have a second active link set a flag on the form saying 'don't check anymore', and refresh the table Then....create an interval based AL that checks your flag field, if it's not set, then call the guide With this process you will still have an AL that fires every 'x' seconds, but it won't do anything once the process is done It works well. Let me know if this does anything for you. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Remedy Sent: Wednesday, January 05, 2011 2:06 PM To: arslist@ARSLIST.ORG Subject: Delayed Table refresh Hey everyone. Got a problem that I can't think of how to get around. We have a Display-Only form that when it is opened, it triggers an active link that in turn executes a Run Process that runs a PL/SQL script on the server. This script basically runs through our CMDB and populates a table in the database with some data. On the Display Only form that was opened, we have a table that shows data from a View-Form that is based off the table that was populated by the script/Run-Process. The only way to display the results is by manually doing a refresh on the table. I have tried issuing a table refresh after the Run-Process, but it seems this occurs before any data has been populated by the script. How do I put in a delay before the table refresh happens, or keep refreshing the table till the data shows up. I could use an active link guide that keeps doing a SQL call looking for the results and when found, exit the guide and then do the refresh, but that would be a performance issue I would think. The script does populate a row at the end, which is used as a signal that the script is done. Any thoughts or suggestions would be a big help. The script is doing the equivalent of an impact analysis for a specified CI. Our structures are complex and have a lot of rules as what will impact something else. We are running 7.1ARS and CMDB 2.1 on a Solaris OS with an Oracle 11 database. Thanks, Brent... Sent from my iPhone ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
