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"

Reply via email to