1. Database access
2. Search results
2.1 Selecting visible fields
2.2 Sorting the search results
2.3 Filtering the search results
2.4 Printing the search results
2.5 Saving the search results as CSV or XLS
2.6 Viewing the additional information
2.7 Viewing the table references & info
3. Phrase search
The database access screen allows user to search data from the ExpoFacts database. There are four steps to go through in order to get search results:
The search results screen displays the data of the selected table and provides some useful tools for sorting, filtering, printing and downloading that data. The data is displayed in a table where columns represent table fields. First row of this table consists of field headers. Field descriptions can be shown by taking mouse cursor over field headers or data values. With large data sets this is especially handy feature. Search results screen can be accessed from database access or phrase search page. Back to selections-button takes user back to the page from where the results page was accessed.
Following sub-chapters describe the features and usage of the search results screen.
By default all fields (columns) of the selected table are visible. This can be changed by pressing Select fields -button which can be found from inside the View-box.
The field selection window includes check box for each field (column) of the selected table. Checked box means that the field is visible on search results screen. Unchecking the box hides the field. Reset-button checks all check boxes (makes all fields visible). Apply-button applies the changes to field visibility at results screen and closes the window. Close-button closes the window without applying any changes to field visibility.
By default the search results are being sorted by table's key fields (data year, country, ...). Sometimes it can be useful to modify this default criteria and it can be done by pressing the Sort-button, which can be found from inside the View-box.
The sorting criteria window includes as many selection boxes as there are fields in the selected table. Each of these selections include all field headers of the selected table. This makes it possible to sort data on multiple columns (fields). Multiple column sort has an order that is marked with numbers before each selection box. Besides this there is a check box after each selection box. This check box can be used to apply descending sorting order for the column. Reset-button clears all selections and checkings. Apply-button closes the window and applies the selected sorting criteria to search results view. If all selections are empty while pressing the Apply-button then the default sorting criteria will be applied. Cancel-button closes the window without modifying the current sorting criteria.
Search results can be filtered by any value of any field (or fields) of the selected table. This is done by pressing the Filter-button, which can be found from inside the View-box.
The filter criteria window includes a selection box for each field (column) of the selected table. Each selection includes all values of the field. If a value or values are selected and applied then the search result screen shows only those rows that include selected value or values. Filtering is restricted so that only one value per field can be selected. Reset-button clears all selections. Apply-button applies the selected filter criteria to the search results screen and closes the filter window. Cancel-button closes the window without making any changes to the current filter criteria.
Search results can be displayed in more printer friendly format by pressing the Print-button which can be found from inside the View-box. This will open a new window that shows selected table's data, field descriptions and references. The table data in print view is formatted equally to search results screen (filtering, sorting etc...). Actual printing can be done by activating the window and pressing CTRL & P or by selecting Print... from the window's File-menu.
Search results can be downloaded and saved as CSV (comma separated values) or XLS (Excel) file. This is done by pressing the CSV or Excel button, which can be found from inside the Save as-box. Downloaded table data is formatted equally to search results screen (filtering, sorting etc...) containing also field descriptions and references.
Besides the actual data, a table in ExpoFacts database may have some links to additional information.
This information can be pictures, charts, articles... If any links to additional information are available
then they will be listed below Additional information-title next to the View-box.
Note: If the results page was entered from the database access page then only links for the selected country (or countries) will be displayed.
Complete listing of the table's references (sources, urls, copyrights), field descriptions and other information can be viewed by pressing the References & info-button.
Phrase search is an alternative way to access the ExpoFacts database. Phrases can be searched from table names, field descriptions and table sources. User has ability to choose which of those targets are included into phrase search. This can be done by checking the desired targets below the Search from-title. The actual phrase needs to be entered into the text field below the Phrase-title. Finally search can be executed by pressing the Search-button.
Phrase search ouputs a table of the tables that match the search criteria. First column of the table contains the names of the matching tables. The cells after each table name tells from where the searched phrase was found. Matching targets are marked with green check mark. The data of a table in the name list can be viewed by clicking on its name which opens the search results page.