Robert, Ok, but can you make a view form on top of the data from the Remote DB?
There is some RDBMS voodoo that you need to do, but in most cases it _is_ possible. How much voodoo depends on the RDBMS, network performance, data set size, data details, etc... And all of that might be well beyond most "ARS developers" too. However that is the first step in my plan. So if you can not do Step 1, then the rest of the steps are useless to you. If you can not achieve Step 1.... I would go to the command line. Use RDBMS command line tools/API tools to get the data and loop over it and "submit/update" records in ARS from the Remedy API (one record at a time). -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/29/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:
It be easy if everything was in a form. lol Sadly, the data that I need is in another database and that is the problem. The Push Fields doesn't handle SQL at all. If it did, it would be easier then. I've tried throwing some sql into the Push Fields "push if" qualification and it gave me a relational error and the sql was valid. I guess I'll just have to handle one at a time. Thanks though Carey =) Bob Halstead -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, September 29, 2006 7:07 AM To: arslist@ARSLIST.ORG Subject: Re: Database results Bob, Make a view form that you can do an equivalent search to your "SQL query". Then you could: Create a table field that searches this view form with the correct search conditions. Use an active link loop over the table and for every row push a new record to the target form. OR you could: Do a push to modify all matching rows in the view. Then have filters on the view form do a push to the target form. NOTE: ARS is not a "set based language". It is "single record" tranactional in nature. Even the Push to "Modify All" really processes each record one by one. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/28/06, Halstead, Robert <[EMAIL PROTECTED]> wrote: > ** > > I would like to handle multiple results from a sql query in remedy. > The query I want to run may return multiple results in which I would > like to push each result to a form. Is this possible? > > > > Bob Halstead __20060125_______________________This posting was > submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org