There's a way, but it's not a good way.
-- Using the user client, set the sort options for your form to sort on the 'Request ID' field, descending. -- Set your Behaviors preferences to Limit the number of Items returned to "N" -- Run a time-based query (such as 'Create Date' > $DATE$) As long as the above query returns more than "N", you'll just receive the last N records created. I told you it wasn't a good way. I much prefer a simple time-based query: 'Create Date' > $TIMESTAMP$ - 60 -Aaron * Phone: (610) 722-4486 * Fax: (610) 993-2689 * Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Thursday, January 25, 2007 10:56 AM To: [email protected] Subject: Ticket Query (part deux) 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___ SunCom is the wireless company that's committed to doing things differently. Things we want you to know. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by the attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
