Yup -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Monty Sent: Tuesday, December 16, 2008 12:25 PM To: arslist@ARSLIST.ORG 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" <gary.opela....@tinker.af.mil> Newsgroups: public.remedy.arsystem.general To: <arslist@ARSLIST.ORG> 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:arsl...@arslist.org] On Behalf Of Monty Sent: Tuesday, December 16, 2008 1:12 PM To: arslist@ARSLIST.ORG 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: medwa...@marketlinx.com 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"
