BAM! and it works! thanks a million , guys.
-Andrew
On Oct 16, 2007, at 11:17 AM, Nall, Roger wrote:
**
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___
__20060125_______________________This posting was submitted with
HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
