Richard, I replied to you before on how this would work. I even worked it up on my dev box and got it working.
Create a Display Only form with a field on it for a query (queryField) and a field for number tickets returned (numTktsReturned). Drop a table on the D/O form that runs EXTERNAL($queryField$) Use Active Link guide to loop through the table, incrementing a tmpCounter field until you tmpCounter = numTktsReturned and set tmpRecordId = record id of the current ticket. Exit the loop when tmpCounter = numTktsReturned Next, append to $queryField "and 'Record ID' >= $tmpRecordId$ Next, do a window open and slap $queryField as the qualification for the open window action. Close window action to close the D/O form. You should be able to record a macro that would take in user input for the query and the numTktsReturned, then let workflow do the rest. Thanks, Gary _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Crosby Sent: Thursday, January 25, 2007 9: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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
