3.3. Table

“You’re here because you know something. What you know you can’t explain, but you feel it” – Morpheus, The Matrix

The information stored in the workflow table is accessed through the Table link in the top bar menu selecting the option View data . As this table can be arbitrarily large, the application groups the rows into pages and provides links to each of the pages at the bottom of the table. The top of the table includes a pull down menu to choose how many rows are shown per page. If the table has a large number of columns, a horizontal scroll is available to show the additional content. The order of the columns in the table can be changed by dragging them from the top row and dropping them in a new position.

The following figure shows an example of the full table view page.

../_images/table.png

The table offers the possibility of searching for a string using the box at the top right corner.

The buttons at the top of the page offer the following functions:

../_images/table_buttons.png
Row

A form to introduce a new row in the table with one field per column.

Column

Add a new column to the table. The pull-down menu also allows to add a column with values calculated with a formula and using the existing values, or a column with random values.

Views

A view is a screen showing a subset of rows and/or columns in the table. Clicking in the Views shows options to create a new view, show the data in a view, or go back to the full table view.

Dashboard

The dashboard shows a statistical summary for the columns shown in the table. This number may be too high, so you should consider using table views to reduce the amount of information shown in the dashboard.

Column statistics

This button allows to choose a non-key column and show an statistic summary of its values

CSV Download

This functionality downloads the data in the table as a CSV file. Combine this functionality with the table views to handle large tables.

Action with filter

Create an action using the restriction in the number of rows as the filter. This option is only available if the view has defined a filter condition.

3.3.1. Table Views

Due to the potentially large size of the workflow table in either number of rows or columns, OnTask offers the possibility to define Views . A view is a subset of columns and rows of the original table. You may define as many views as needed. The link Views in the main table page shows the views available and the operations to manage them.

../_images/table_view_view.png

The title at the top of the page is the view’s name. The buttons to the right of the name perform the following operations:

Edit

Edit the view: name, description, set of columns to show and row filter

Clone

Create a duplicate of this view with the prefix Copy_of added to its name. This operation is useful to create a new view with content that is similar to an already existing one (clone and edit).

Delete

Delete the view.

If the view has defined a filter condition (to select a subset of the rows), it is shown on top of the table.

When creating a view you need to provide a name (required), a description, a subset of columns to show (at least one of them must be a key column ), and an expression to select a subset of rows. This expression is evaluated with the values of every row and if the result is True , the row is included in the view. The following figure shows an example of the information that is included in the definition of a view.

../_images/table_view_edit.png

When visualising the subset of data in a view, the button with text Views at the top offers the option to go back to the Full Table , create a new view, or select any of the existing ones.