Introduction 
The database viewer is a debug configuration support tool for inspecting the contents of the FEWS database (localdatastore). It shows the content (=values) and statistics of scalar or gridded timeseries. The database viewer is available in two different modes:
- workflow based database viewer - for each available workflow, all timeseries written to the database in that workflow can be inspected. From the Explorer, the Database Viewer can be accessed using <F12> + J.
- timeseries lister - for the selection made in the Data Viewer or Forecasts (Explorer Tabs) all available timeseries in the database are listed and can be inspected. To open this mode, some configuration is required
The Database Viewer provides an overview in a tabular form which specifies many different meta data elements (columns) are specified. Rows can be selected and filtered
Meta Data Elements
The meta data elements are grouped as follows.
- General (e.g. moduleinstanceId, location, parameter, timestep, blobsize etc.)
- Basis Statistics (Sum, Mean, Median, Standard Deviation, Percentile-5, Percentile-95)
The below mentioned groups give an overview of number of values and periods based on quality flags, primary and secondary validation.
- Missing
- Original Reliable
- Corrected Reliable
- Completed Reliable
- Original Doubtful
- Corrected Doubtful
- Completed Doubtful
- Original Unreliable
- Corrected Unreliable
- Completed Unreliable
- Soft Min
- Soft Max
- Hard Min
- Hard Max
- Same Reading
- Rate of Change
- Temporary shift
- Series Comparison
- Flag Comparison
- Spatial Homogeneity
Configuration (mode: timeseries lister)
| No Format |
|---|
<explorerTask name="Timeseries Lister">
<iconFile>tableInfo.jpg</iconFile>
<taskClass>nl.wldelft.fews.gui.plugin.timeseriestableviewer.TimeSeriesTableViewer</taskClass>
<toolbarTask>true</toolbarTask>
<menubarTask>true</menubarTask>
<allowMultipleInstances>false</allowMultipleInstances>
<accelerator>ctrl T</accelerator>
</explorerTask>
|
Context Menu Options
The Graphical User Interface contains a number of context menu options for selection/filtering and inspecion of data. 
Menu option | Functionality | Alternative | Remark | Visible effect |
|---|---|---|---|---|
Filter for selection | Uses the cell content as a filter | Doubleclicking the cell | You can set different filters in different columns | Cell background turns blue |
Remove filter for column | Show all timeseries (again) for this column | Doubleclicking the blue cell |
| Cell background turns white |
Remove all filters | Show all timeseries (again) | Doubleclicking the blue cell |
| Cell background turns white |
Sort column | Sort the content of the column | Clicking the header |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|