That might not really get the exact number of N tickets... What I would do is use the EXTERNAL keyword and use a field containing a qualification for the last n ticket say ztmpLastNTickets in a character display only field with ID 1005..
Another field ztmpNEXTID can be set from a Direct SQL Select nextid from arschema where name = "'$SCHEMA$'"; Hold the value for N in ztmpN. Set Field ztmpN = ($ztmpNEXTID$ - $ztmpN$ - 1) Set the field ztmpLastNTickets with 'Request ID' >= "$ztmpN" Use this result in the EXTERNAL keyword on 1005.. It should get what you want... The result will differ however if some rows were deleted in between... Hope this helps and my explanation isn't as cloudy as the sky out here in Virginia.... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: Roney Samuel <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, January 18, 2007 1:13:02 PM Subject: Re: ticket query ** Dear Richard, You can achieve this on the user client if you want to do this process manually, You can go to Tools--->Options ---->Behaviours---->Limit Number of Items returned. Set this Field with the number of records you would like the search to return now you can create a simple macro to search on the create date field to get the appropriate number of last N tickets. Hope this helps. Another way is to create a .bat file which would take the Variable N as a parameter and set the SchemasToRemember value for the ar.ini file for the current user. Hope this helps. Regards, Roney Samuel Varghese On 1/12/07, Richard <[EMAIL PROTECTED]> wrote: Hello, How would I go about querying the last "N" tickets? Meaning, I'd like to create a macro with a variable ("N") to pull up just the last 10, 20, 50, 100 , etc. records recently created. Thanks kindly, Richard ____________________________________________________________________________________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
