Data Tables

When a data table is selected from the list the data stored in that table is displayed. These entries can be:

• Sorted;
• Searched; and
• Viewed

Data is sorted by column. To sort the available users only need to click on the column they want to sort by. For number columns the sorting starts from 0 and goes to the maximum number. For strings, the sorting goes A-Z. Each column also displays the datatype the data is stored under. This is useful when diagnosing reporting issues and data type errors.

The Data View Search box allows the user to search the data set, using a Sql like syntax, eg "scenarioname"='Scenario' will filter on the scenario called Scenario. Note we enclose the scenarioname column name in double quotes. This is because there is the possibility that columns are case sensitive, and double quotes are required to enforce the case sensitivity in the database engine.