Advanced Query The Status Window
As indicated in Advanced Query UN COMTRADE - Introduction, a submitted advanced query is not instantly available. When your query is sent to WITS server, it is queued with other advanced queries run by other users. The rule is first come first serve, but depending on the size of the query, you query may be completed before other queries.
Overall, time required to get results ready depends on the size of your query, its rank in the queue and the size of all other queries. It may take from few seconds to several hours (infrequently) before results are ready.
To see if your query is completed and to access results, use the View and Request Download window.
Opening the View and Request Download
You can open the View and Request Download screen in two different ways:
Both options display the View and Request Download screen
The View and Request Download screen lists your advanced queries. The results form other WITS menu can also be accessed from the same screen.
Queries are listed in rows, starting with the last one you submitted (first row). For each query, the system provides a set of information. We will describe those which are relevant.
Let's say your query is not ready when you first check the View and Request Download screen. Since the job is not ready the magnifying glass icon will not be displayed in the View column. Moreover, the Status column will indicate Waiting or Running. It may also indicate Aborted and in such a case the magnifying glass will never be displayed.
Information in the Status window is not automatically updated but is refreshed when you click on the Refresh button.
After a while your query will be completed and results ready as indicated by the magnifying in the View column.
Results can be accessed only when your query is completed. To open the Result window, click on the magnifying glass in front of the specific query.
Results can be downloaded by clicking on the download icon (down arrow) in the View and Request Download screen. You will be shown a screen to enter a Job Name, Job Description, File Format csv, excel 97-2003 or tab separated, Columns to be downloaded" and optional pivot details for the download job. Click on Download button to request download or Cancel button to cancel the download request. Once you click on download button you will get an option to go to the Download Results screen to download the data. The download results screen will show you the download job name and once the status is complete you can click on the Save icon to download the data. This screen also gives you details on the size of the file to be downloaded.
Next: Advanced Query Results
WITS Online Help
The World Bank, 2010