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:

• After submitting the Advanced Query, click on the OK button.
  
• You can also access the View and Request Download screen by choosing View and Request Download in the Results menu.
  

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.

• ID: displays the system generated ID for the query.
• Query/Simulation Name: displays your query/simulation name.
• View: indicates whether a query is completed and results are ready (magnifying glasse icon is displayed).
• Download: A down arrow icon to enable you to request download of the data in a zipped format.
• Delete: click on the X icon to delete the corresponding query results. This does not delete the saved query definition.
• Log: click on the document icon to open a basic information page about your query.
• Status: indicates your query's current status which can be Waiting (query is queued but not processed), Running (query is currently being processed by WITS server), Completed (processing is finished and results are ready) or Aborted (there was a problem with query and the process did not go through).
• Source: indicates the source database (UN COMTRADE, TRAINS or WTO for Advanced Queries, depending on the chosen source database, or something else for queries coming from other WITS tools).
• Date: returns the date and time the query was submitted.

Refreshing the information

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.

Opening Query Results

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.

Download Query Results

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