Hi,
Try turning on all kinds of logging on the client to see what happens.
Maybe you have som active link that modifies the search criteria?
When I do something like this, I typically do it in a single step.
1. Open form in search mode and press cntrl-e to clear everything
2. Fill in your query in the advanced search
3. Turn on macro recording
4. Choose Tools -> Reporting
5. Choose/define your report layout
6. Report -> Export -> To File
7. Save your macro
I do not know if this will help you...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
