I guess...:) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Tuesday, December 16, 2008 12:11 PM To: arslist@ARSLIST.ORG Subject: Re: Fw: Select distinct from api
LJ, I kind of agree, but .... If you use the AR API(Server) to issue the SQL then you can write to one API instead of potentially multiple RDBMS API's. If you use the AR API(Server) to issue the SQL then you could even do it via a prepared AR System application instead of using a full AR administrator account too. (Which I think is required to use the Server.GetListSQL() API call.) If you use the AR API(Server) you can do other things that are "harder" to do via the RDBMS API too. ( Like trigger notifications, inform the support process of exceptions, etc..) However, when the AR System does not fully implement all of the features that the RDBMS has and you need those features, then you need to "drop down" to the lower level and use the tools that you need to use to get the job done. You just may not have to set up any additional libraries/utilities/infrastructure to tap into those RDBMS features for one or two things that you need to do. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Dec 16, 2008 at 1:06 PM, LJ Longwing <lj.longw...@gmail.com> wrote: > ** > 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:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Tuesday, December 16, 2008 9:39 AM > To: arslist@ARSLIST.ORG > 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 <medward...@comcast.net> 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 ____________________________________________________________________________ ___ 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"
