I'm not well versed with the APIs, but I doubt you could do a SELECT DISTinct, you would likely have to really work some other routes to get the same effect.
Gary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Monty Sent: Tuesday, December 16, 2008 1:12 PM To: [email protected] Subject: Fw: Select distinct from api ** 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
