I'm an Oracle guy,new to Remedy, but in oracle I'd do where ticket_id > max(ticket_id) - N Does remedy have a max function?
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Morgan Sent: Thursday, January 25, 2007 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: Ticket Query (part deux) ** I'd probably be looking in the area of loading the lastID from the database (hint sql select statement), taking "n" away from it and then piping it to a query like ticket-id > "n" taking into account the prefixes etc. May not be possible in macro's but eminently do-able in workflow / display-only form.... regards Dave Morgan Tiberone Technologies Limited Index House St Georges Lane Ascot Berkshire United Kingdom SL5 7EU Mobile. +44 (0) 7876 450 102 Telephone. +44 (0) 1344 636 375 Fax. +44 (0) 870 831 0381 www.tiberone.com ________________________________ From: Action Request System discussion list(ARSList) on behalf of Richard Crosby Sent: Thu 25/01/2007 15:55 To: arslist@ARSLIST.ORG Subject: Ticket Query (part deux) This is a multi-part message in MIME format. ------_=_NextPart_001_01C74099.4443CFBF Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, =20 I posted this question before and it did not elicit any responses. Therefore, I asked BMC support and the response I received was, "I am sorry I just dont know of a way you can limit the returned entires." (punctuation and spelling errors left intact). =20 The question was: =20 How would I go about querying the last "N" tickets? Meaning, I'd like to create a macro (or know the syntax) with a variable ("N") to pull up just the last 10, 20, 50, 100 , etc. records recently created. =20 Can anyone help answer if this is do-able or not? =20 Thanks, Richard =20 =20 =20 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ------_=_NextPart_001_01C74099.4443CFBF Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40";> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <style> <!-- /* Font Definitions */ @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Verdana; color:windowtext; font-weight:normal; font-style:normal; text-decoration:none none;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>Hello,<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>I posted this question before and it did not elicit = any responses. Therefore, I asked BMC support and the response I received = was, “I am sorry I just dont know of a way you can limit the returned = entires.” (punctuation and spelling errors left = intact).<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>The question was:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>How would I go about querying the last = "N" tickets? Meaning, I'd like to create a macro (or know the syntax) with a variable ("N") to pull up just the last 10, 20, 50, 100 , etc. records recently created.<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>Can anyone help answer if this is do-able or = not?<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>Thanks,<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>Richard<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><o:p> </o:p></span></font></p> </div> </body> </html> __20060125_______________________This posting was submitted with HTML in it___ ------_=_NextPart_001_01C74099.4443CFBF-- __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
