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"

Reply via email to