Works like a charm.
Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Tuesday, October 16, 2007 12:08 PM To: [email protected] Subject: Re: show records from external database in table field? ** Create an Oracle view of the data in the ARSystem tablespace, Then create a View Form using that Oracle view and attach it to your table field. On 10/16/07, Andrew Hicox <[EMAIL PROTECTED]> wrote: Hi Everyone: I have a situation where I need to show records from an external non- ARS database in a table field. We have an external Oracle database that contains customer POC information. Because our remedy backend is also an Oracle database, we simply have a DB link to the external database inside the ARSystem tablespace. This works fine in most all circumstances, when we need data from the external database, we can select it over the database link from an SQL setfields action. However, now I have a situation where I need to display a list of customer POCs and have a user pick one. The natural thing seems to be to display the POC records in a table field, and have the user click one. But I can't figure out how to do this. The only thing I can think of is to have an active link fire off an SQL setfields and use the "if multiple records match,, display list" option. But that's not really the behavior I'm after, as the results list pops up in a separate window, and that's going to confuse the user, etc. What I want is a list of those records in a table field. So ... has anyone out there in Remedy-land finagled some shim-sham like this before? let me know, thanks, -Andrew ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
