index > Team Foundation Server - Work Item Tracking > Query results window is cached ?

Query results window is cached ?

When you run a query, open the result in MS Excel, make changes to the work items, publish them and then run the query again from within VS, you get the same results as before the change and publish from MS Excel.
It seems that the query is just not run because there is already an existing results window.
How can i make sure that the query runs every time even if there was already a resuls window for that specific query ?

paso

When query is refreshed we do clear the results and run query again. Is this not what you are seeing? If you try closing and opening results view, do you see right results? If not, pls give me repro steps to try.

Thanks

http://blogs.msdn.com/narend

Naren Datha - MSFT

Steps for repro:
- double click on a query --> results window is displayed
- right-click on same query and select "Open in Microsoft Excel"
- change some fields in Excel
- publish changes
- switch back to VS
- double click on the query --> same results window as before changes in Excel is shown
Results are OK if you select the results query window and then press the run button.

paso

When you doubleclick on a query we check to see if that query is already in a opened query window. If so, we just move the focus there. That seems to be the reason why you are not seeing any updates. Rerunning query by clicking on run button does update the results, so does it solve your issue?

Thanks.

http://blogs.msdn.com/narend

Naren Datha - MSFT

Yes this is a workaround, but I consider it a bug that the result window is not refreshed when already open and double-clicking on the query. What the user sees is completely out of sync with what's in the database and I think this is unacceptable !

paso

Thanks for your feedback. I'll track this issue in our db and hopefully this behavior will change.

http://blogs.msdn.com/narend

Naren Datha - MSFT

reply 6