Specimen Table
Header Row#
Clicking a header cell will sort the corresponding column in a logical order, ascending on the first click and descending on the second. A small arrow icon will be rendered to aid in the visualization of the currently selected order direction. When there are multiple datatypes in a column, numerical values take order precedence over alphabetical ordering (i.e. 1234 is 'less than' abcd). A third click will reset the ordering.
Table Body#
Selecting a row will trigger the Specimen View to render the corresponding tuple's data. Apart from this, there is no further functionality in the Table Body.
Footer Row#
There are multiple actions available to you in the Footer Row:
Search Filter + Search Input#
The Filter and Filter Search are a paired functionality. The Filter defines the fields in which the Search input matches on the returned data. By default, the Search input matches on all fields, meaning if there is any field in a given tuple that matches the input then it will not be filtered out.
For example, if you were to narrow the filter to only match id and input a non-numerical value, then there would be no filtered results. You may construct the Filtered Fields by clicking the Filter button, which will launch the corresponding modal (see below).
You may drag any fields you would like to include in the filter to the left-hand side, the "Selected" column. As stated previously, the default is to include all fields in the filter, so when the "Selected" column is empty the filter is all. For more help, please consider the following example:
Data Set#
| id | catalogNumber | otherCatalogNumber | recordedBy | ... |
|---|---|---|---|---|
| 0 | LEP12345 | MGCL_1234567 | Your's Truly | ... |
| 1 | LEP123456 | MGCL_12345678 | Michael Scott | ... |
| 2 | LEP543210 | MGCL_7654321 | Frodo Baggins | ... |
Scenario 1#
Search Configuration#
Resulting, Filtered Data Set#
| id | catalogNumber | otherCatalogNumber | recordedBy | ... |
|---|---|---|---|---|
| 0 | LEP12345 | MGCL_1234567 | Your's Truly | ... |
Scenario 2#
Search Configuration#
Resulting, Filtered Data Set#
| id | catalogNumber | otherCatalogNumber | recordedBy | ... |
|---|---|---|---|---|
| 0 | LEP12345 | MGCL_1234567 | Your's Truly | ... |
| 1 | LEP123456 | MGCL_12345678 | Michael Scott | ... |
Scenario 3#
Search Configuration#
Resulting, Filtered Data Set#
| id | catalogNumber | otherCatalogNumber | recordedBy | ... |
|---|---|---|---|---|
Clear Query#
The Clear Query button clears the currently loaded query from the program. This will remove the data from the table and deselect any selected tuples.
Refresh Query#
The Refresh Query button will rerun the currently loaded query. If there is no query loaded, this will be disabled.
Adjust Table Headers#
The Adjust Table Headers button will open a modal in which you may alter the visible columns on the table. The default visible columns are: catalogNumber,otherCatalogNumber,order_,genus,specificEpithet. Similar to the Filter modal, you may drag and drop fields to the Selected and Available columns, and reorder the fields in the Selected Column. All changes will be immediately reflected on the Specimen Table. Below, you will find an example of the default configuration, and then the default configuration plus the addition of the id and family fields:
Show Logs#
The Warning Icon button will lauch the Error Log Modal. This is a paginated modal, where each page relates to a specific type of error. Generally, these follow specific query type errors: Select, Count, Insert, Update and Delete error types.
Help Menu#
Help Icons are spread all throughout the application, and have corresponding contexts to where they are located. In the Table Footer, this is a Global Help Modal, comprised of general SpeSQL help/tips. If you were to see the Help Icon in the Select Query Builder, you may assume that the information in the modal will be relevant to Select Queries.