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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
