Another option would be to create a serialized query function or stored proc
and then execute it from a SQL Set Fields.
For example:
DECLARE @eid_list varchar(255), @eid_entry varchar(20)
DECLARE eid_cursor CURSOR FOR
SELECT Request_ID FROM User_x
OPEN eid_cursor
FETCH NEXT FROM eid_cursor
INTO @eid_entry
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @eid_list = @eid_list + @eid_entry + ';'
FETCH NEXT FROM eid_cursor
INTO @eid_entry
END
CLOSE eid_cursor
DEALLOCATE eid_cursor
SELECT @eid_list AS Result_List
This would return all the Request ID's from the User form in the format
"00000000000001;00000000000002;0000000000003..."
-----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,
If you can hook it up as a View Form, you can just as well create a
Filter-Table-Loop to fill create the result. No external program would be
needed.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Mark,
> If you have a view form set up in ARS to access the table in the external
> DB, there is an old utility from ESP (Elegant Software Producers) called
> ESP
> "Query List" that you could use to return the results of the query to a
> character field (see attached for description). ESP hasn't been around
> for
> quite some time now, but I was able to archive the web site and all of the
> free utilities before it was taken down. If you would like to give it a
> try, let me know.
>
> Regards,
>
> Thomas
>
> ----- Original Message -----
> From: "Brittain, Mark" <[EMAIL PROTECTED]>
> Newsgroups: gmane.comp.crm.arsystem.general
> To: <arslist@ARSLIST.ORG>
> Sent: Friday, June 13, 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. 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
____________________________________________________________________________
___
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"
