Wow, that's a really cool problem you have. Can you find the select statement that gets generated when you hit F5? Do this either by turning on database logging from your WUT or SQL logging from the system administration console. I'd be interested in finding out what got changed. My guess is the time portion of $DATE $.
Julie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of MCrawford Sent: Wednesday, June 04, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: ARS 7.1 Macro Recording and Reporting Oddity Greetings, I have run across something rather strange in regards to recording macros and exporting the data returned to csv. When I record a macro for an incident query/search it returns the correct results, however when I export the data to .csv it is only exporting a fraction of the items shown in the results window. Furthermore, when I run these macros as said before the correct results are returned, but when I press F5 to refresh the results it shows those 'fractions of the results' that are being reported. It's difficult to explain, but I will walk you through my process. To create these macros I do the following: 1. Open Incident in Search mode. 2. Click the macro record button. 3. Click 'Advanced' button to display advanced search bar. 4. Paste a query into the Advanced search bar: 'Submit Date' > ( $DATE $ - ( 60 * 60 * 24 * 1 ) ) AND 'Status*' < "Resolved" AND '260000001' = "NYA" 5. Click the 'Search' Button and the results appear (in this example ~ 125 results) 6. Click the macro save button, and name the macro. To run the Macro: 1. Click the macro name from the drop down list. This displays the same ~125 results. However, when I select all 125 items, and export the items to a .csv file it only shows ~15 results. I go back to the macro results and run them again, same ~125 results. This time I hit the F5 key and the results drop down to ~15. This is very very strange. I tried the query manually, and it returns ~125 results. Then I hit F5 and the results stay the same, and I can report on the entire list. What am I doing wrong? I can create a video of this if needed. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
