What database are you using?
On Dec 14, 2007 11:33 AM, Martinez, Raul (ISD, IT) <
[EMAIL PROTECTED]> wrote:
> **
>
> 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___
> __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"
