: Re: Get all results from a SQL call
** 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
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark
Sent: Wednesday, August 13, 2008 13:59
To: arslist@ARSLIST.ORG
Subject: Re: Get all results from a SQL call
**
Hi Frank,
Thanks for your help. Now I have run into something
--
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Frank Caruso
*Sent:* Friday, June 13, 2008 3:26 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Get all results from a SQL call
** 1. Create SQL view of the data from your Remedy
, 2008 2:08 PM
Subject: Get all results from a SQL call
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
in the format
01;02;3...
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Misi Mladoniczky
Sent: Tuesday, June 17, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Get all results from a SQL call
Hi
tried it.)
Good luck,
Dwayne Martin
James Madison University
Original message
Date: Fri, 13 Jun 2008 15:26:27 -0400
From: Frank Caruso [EMAIL PROTECTED]
Subject: Re: Get all results from a SQL call
To: arslist@ARSLIST.ORG
** 1. Create SQL view of the data from your Remedy
Caruso [EMAIL PROTECTED]
Subject: Re: Get all results from a SQL call
To: arslist@ARSLIST.ORG
** 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
discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark
Sent: Friday, June 13, 2008 2:09 PM
To: arslist@ARSLIST.ORG
Subject: Get all results from a SQL call
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
You are right! Your way is more effecient.
Dwayne
Original message
Date: Mon, 16 Jun 2008 09:22:19 -0400
From: Axton [EMAIL PROTECTED]
Subject: Re: Get all results from a SQL call
To: arslist@ARSLIST.ORG
You do realize, with this approach, that you are pulling a record set
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.
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,
11 matches
Mail list logo