1. Create SQL view of the data from your Remedy database. 2. Create a View form in Remedy using that SQL view 3. Create a table field using that new View. Now when the table refreshes it will have a local copy of all of the records and you can table walk it.
On Fri, Jun 13, 2008 at 3:08 PM, Brittain, Mark <[EMAIL PROTECTED]> wrote: > Hi All & TGIF, > > I need to do a SQL query to a database outside of Remedy and gets all of > the contact records for a customer and drop them into a field in a > ticket. Of course I can get the first or display a list if there are > multiple. There has to be a way to get all records that meet the > criteria. > > ARS 6.3 patch 20 > Oracle 9.2 > SunOS 5.9 > > Any ideas? > > Thanks > Mark > > Mark Brittain > Remedy Developer > NaviSite ESM Operations > 315-453-2912 x5418 (Office) > 315-317-2897 (Cell) > > > This e-mail is the property of NaviSite, Inc. It is intended only > for the person or entity to which it is addressed and may contain > information that is privileged, confidential, or otherwise protected > from disclosure. Distribution or copying of this e-mail, or the > information contained herein, to anyone other than the intended > recipient is prohibited. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

