hat, I bet they've more clues :)
~james
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Ravi
> Sent: Thursday, May 22, 2008 8:43 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Populating Table field with sql que
James: I have been trying to do something similar. One question. If the
table on which I want to run the sql query is on a different database,
what do I have to do within Remedy so it can connect to a table in that
database.
Thanks
Ravi
Russell, James C wrote:
**
Hello Victor;
I don't know t
**
Hello Victor;
I don't know that this is what you're looking for, but I run a series of sql
queries in a single escalation to populate a 'current state' kinda form--I'm
using one query per field; might not be the most effective way in the world,
but it works.
This has MS SQL date conversions
Victor,
It is not the same as an ARS table field... but
What if you write workflow that walks the data and builds a dynamic
HTML page that is displayed in a View field?
(Which by the way is basically what the CI viewer does, only it uses a
Data Visualization Field which has a few more bells a
On Sunday 18 of May 2008 22:39:03 Grooms, Frederick W wrote:
> Have your SQL Query populate a table in the database and have a View
> form pointing to that table.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of
*Hi Victor,
*On search in doc, I found related doc for you.
To pull information from external tables, you can use the Set Fields
action with the "Read Value for Field From" set to "SQL". This allows
you to send an SQL |SELECT| command to the database and assign the
return values to AR System
Have your SQL Query populate a table in the database and have a View
form pointing to that table.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Victor
Sent: Sunday, May 18, 2008 12:47 PM
To: arslist@ARSLIST.ORG
Subject
7 matches
Mail list logo