Forget the last 4 lines. Just do a query on the Request ID field of > the integer value.
So taking Johns solution do a set fields from arschema on the nextid, deduct the number 10,20,50 whatever from it and then query Request ID > integer value. It will find all the tickets after that number. If, however, some have been deleted you may not get the full amount you asked for. Brian Bishop _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: 25 January 2007 22:36 To: [email protected] Subject: Re: Ticket Query (part deux) This is just expanded off of what Dave Morgan wrote. And it works I tested all but the Open window part. This is all done on the form in question. You could set an integer field with select nextID from arschema where name = '$SCHEMA$' by returning $1$ - 10 Then set a character field to $IntegerField$ Then use the Character field ( with appropriate trapping and LPAD for a Prefix) to query 'Request ID' >= $CharacterField$ Fire the Open window with a Button or Menu choice. Last 10 records returned. HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, January 25, 2007 4:04 PM To: [email protected] Subject: Re: Ticket Query (part deux) ** You could always use a table field. Not sure the context of what you are trying to accomplish. Axton On 1/25/07, Richard Crosby <[EMAIL PROTECTED]> wrote: ** Hello, 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). The question was: 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. Can anyone help answer if this is do-able or not? Thanks, Richard __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 ARSlist:"Where the Answers Are"
