...
| 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> |
Usage
The Time Series Lister enables users to inspect the database. Database records are visualized as individual rows, which can be selected. Once selected, records can be browsed through (all columns) or their values can be inspected via a graph (scalar series) or the spatial display (grid data).
In the top window, workflows are available. When a workflow is selected, the lower part of the screen shows the records that have been written to the database in this selected workflow. Individual rows in this lower part can also be selected. All meta-information and statistics are calculated on-the-fly and are not stored. Within selections or filters (e.g., on start/end time), the content of the visible columns is updated immediately.
There are many columns that can be viewed: general columns about module instance, location, parameter, disk space, and all kinds of relevant meta-information about the selected record(s). Besides the general metadata, the basic statistics of that row can be inspected. These basic statistics include sum, average, maximum, minimum, etc.
The remaining columns describe the quality of the data. For example, if the user wants to know how many values are 'unreliable' and how many 'periods' of unreliable data are available, this information can be retrieved. The same is true for all kinds of combinations of doubtful, completed, and corrected data. This same functionality (number of records, periods) is available for primary and secondary validation results. This means that the user can inspect the number of records and periods of, e.g., hard maximums, flag comparison, or series comparison.
When many records (rows) are available, the user can filter the results. Double-clicking a cell will automatically filter for that value. If you want to filter on, e.g., a location, select the location (name or ID) column and press F8 or double-click it. The background color of the cell will turn blue (indicating there's a filter on it). This filter mechanism is applicable to all available columns, including Start and End Time. When the user changes the start and/or end time, the visible columns will be updated accordingly.
Context Menu Options (lower table)
...
The Graphical User Interface contains a number of context menu options for selection/filtering and inspection of data. Right-click the mouse on one of the cells to access the context menu.
Menu option | Shortcut | Functionality | Alternative | Remark | Visible effect |
|---|---|---|---|---|---|
Filter for selection | <insert> | Uses the cell content as a filter | Double-clicking the cell | You can set different filters in different columns | Cell background turns blue |
Remove filter for column | <F3> | Show all timeseries (again) for this column | Double-clicking the blue cell | Cell background turns white | |
Remove all filters | <F6> | Show all timeseries (again) | Double-clicking the blue cell | Cell background turns white | |
Sort column | <F7> | Sort the content of the column | Clicking the header | ||
Select columns | <F8> | Opens a dialog for selecting the columns | |||
Show Timeseries Dialog | <F10> | Opens the TimeSeriesDialog and shows | |||
Show Spatial Display | <F11> | Opens the Spatial Display and shows | |||
| Show Rating Curve | SHIFT + <F12> | Opens the TimeSeriesDialog and shows the details of the selected rating curve | |||
Copy TimeseriesSet.xml to clipboard | Copies the TimeSeriesSet in XML format | Shows the XML in popup | |||
Highlight in workflow navigator | Highlights selected time series in workflow navigator | Workflow navigator will be shown | |||
Export to CSV | Exports the tabular overview of (filtered) time serie(s) to a CSV file | For exporting the data to a CSV file, use the Timeseries Dialog (select the data in the table and use context menu / save as...) | File dialog opens for saving the CSV file |
Special Filter option: Start time / End time
Two columns have special features: the Start and End Time columns can be used to increase or limit the view period. If you adjust these, all statistical columns or columns showing information about quality flags and (secondary) validation will be adjusted automatically.
Double-clicking in these time columns will provide the user with additional options, as shown in the figure below.
Figure 3: Special filter in the Start/End time columns
...