I think so, you might want to wait on someone else whom is more familiar with the APIs than I am to confirm that though.
Thanks, Gary Opela, Jr. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Monty Sent: Tuesday, December 16, 2008 1:25 PM To: [email protected] Subject: Re: Select distinct from api so we need to devise a method to count after the query and filter from there? ----- Original Message ----- From: "Opela, Gary L CTR USAF AFMC 72 CS/SCBAH" <[email protected]> Newsgroups: public.remedy.arsystem.general To: <[email protected]> Sent: Tuesday, December 16, 2008 8:16 AM Subject: Re: Select distinct from api 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" ________________________________________________________________________ _______ 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"
