Yes there is a limitation in affect right now on the server. Here is an example of what we are doing, but of course the code is not 100% correct:
said syntax error ? SELECT "HPD:HelpDesk"."Assigned To Group+", "HPD:HelpDesk"."Assigned To Individual+", "HPD:HelpDesk"."Assignee Login Name", "HPD:HelpDesk"."Case ID+", "HPD:HelpDesk".Source, "HPD:HelpDesk".Status, "HPD:HelpDesk"."Submitted By" FROM "HPD:HelpDesk" "HPD:HelpDesk" WHERE ("HPD:HelpDesk"."Assignee Login Name"='Jack Zaldivar') AND ("HPD:HelpDesk".Status<>'Resolved' And "HPD:HelpDesk".Status<>'Closed') AND ("HPD:HelpDesk"."Create Time"<SYSDATE) ORDER BY "HPD:HelpDesk"."Case ID+" 11:11:11 AM ? that's just an example 11:11:23 AM ? not what we REALLY want 11:11:30 AM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Friday, December 14, 2007 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy SQL query assistance... Please Help. ** I think he mentioned that the SERVER has been limited to 1000. On Dec 14, 2007 11:03 AM, Evans.Randy <[EMAIL PROTECTED]> wrote: ** Change your preferences to unlimited while you run the macro. You probably don't want to go against the database itself. Remedy has a tendency to store dates as long integers based on the number of seconds since 1/1/1970. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 9:47 AM To: arslist@ARSLIST.ORG Subject: Remedy SQL query assistance... Please Help. ** Can anyone assist me in either in connecting an ODBC connection to Remedy through Access or with creating a SQL search query for $DATE$ function? I am needing to grab all submitted tickets for current day based on certain submitters. I already have a remedy macro created but it would be easier with a SQL query. I had to split the macro up several times due to the server being limited to only 1000 line return. ************************************************************************ * This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************ * __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"