Matthew, I haven't done this...but you might try: Lets say you want it to run every Sunday night; create a form with a table and set the table qual to be all tickets on that form for Date minus one week. Sunday night you have an escalation that runs (update a trigger field or something) to fire a Filter Guide to loop and count the table. Push this result ot a tmp field and multiply by X where X is the percentage of tickets you want to review. So if you wanted to take 10% of your 2500 tickets you'd just multiply by .01 and put this value into another field. Be sure to round the number so it doesn't screw up the forthcoming workflow. So now that you have the number of tickets you want to work with you now fire another Filter Guide. Again, you loop the table but as you loop you write an incremented value to another tmp field. When the tmp_increment field = your case % count you write whatever case details you want to a Zero-length character field and change the tmp_increment field back to zero...continue your loop to build the data in your character field. When the table loop completes and you have a field with all your case detail. Now fire one more filter to email this to you or whomever. I did something similar for a daily case digest and I encoded HTML into the character field Set Fields function and built a corresponding HTML template. If you need more detail or an example I'd be happy to provide something. This may be way more than what you're looking to do, AND, its not totally random...but its the closest I think you can get without writing a script of sorts and calling it using a Run Process function. Cheers! -Eli ________________________________
From: "Action Request System discussion list(ARSList)" [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Wollman Sent: Monday, May 21, 2007 10:42 AM To: [email protected] Subject: Random request selection ** Is there a way to select random requests from a form? For example, we want to start doning random checks on the quality of our tickets. So we want to pick 10 random resolved tickets each week from our support-groups. I figured I could create a macro or AL to query the from with a date range, group range, and select 10 random and print them to my default printer with a specified report. I looked trhogh DAB and DAA and could not find a function or process to do a Random selection. Any ideas? My fallback plan is to search for resolved tickets in a date range and group range and export the results to excel, use excel RAND function get the ticket num bers and search on those in Remedy and print those out. Matthew L. Wollman Supervisor of Faculty & Staff Help Desk Services Faculty of Arts & Sciences Computer Services Office (617) 496-8947 Cell (617) 285-6952 [EMAIL PROTECTED] Harvard University 1 Oxford Street Science Center B14E Cambridge, MA 02138 Would you like to comment about the service you receive from FASCS? Now you can! An online survey is available at: http://www.fas.harvard.edu/~fascs/survey.html __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"
