That would be using the Remedy API to instruct the remedy server to issue the sql statement for you...which I think kind of defeats the purpose of even using the Remedy API...but that's just my opinion.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Tuesday, December 16, 2008 9:39 AM To: [email protected] Subject: Re: Fw: Select distinct from api ** You could try using Server.GetListSQL() in .NET On Tue, Dec 16, 2008 at 2:12 PM, Monty <[email protected]> wrote: ** Subject: Select distinct from api How would I accomplish a select distinct from the remedy api? all i can find in the documentation is get entry seems arsperl had more functionality however we are moving to .net (easier to find qualified programmers for) and need to move this to that platform. SELECT DISTINCT UserID, COUNT(RequestID) AS cntFROM MLSRequestWHERE SystemID = 'AUS'AND CONVERT(char(10), DateAdd(second, CreateDate, '12-31-1969 19:00:00'), 111) Between '2008/12/01' AND '2008/12/01'Group by UserIDOrder by cnt DESC Monty Edwards Web Developer Associate I would love to change the world, but they won't give me the source code MarketLinx 1901 West Cypress Creek Road Suite 400 Ft. Lauderdale, FL. 33309 Toll Free: 1-888-825-5472 Direct: 954-492-8465 Fax: Email: [email protected] A First American Company | www.firstam.com <http://www.firstam.com/> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
