Monty, To the best of my knowledge, there is no 'select distinct'. To ensure distinct you would need to getListEntry (or the .net api equivalent), loop through the entries, and programmatically move the 'unique' entries to another list, and then use the unique list.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Monty Sent: Tuesday, December 16, 2008 12: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"
