Open a Data Table
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
A Data Table may be opened in one of three modes. Clicking on the name of a Data Table in the Open dialog will display a drop-down list at the bottom of the dialog with the choices below.
•Table (all rows in facility)
•Table (all rows in database)
These options only pertain to Data Tables. They do not exist for System Tables, Reference Tables, Views or Reports.
The second option is the default, Table (all rows in facility). When a table is opened in this mode, rows are displayed containing the data pertinent to that facility (i.e. FACILITY_ID in that table is equal to DT_FACILITY.FACILITY_ID where DT_FACILITY.FACILITY_CODE is the name of the current facility). For example, if several different facilities exist within a single database and the DT_LOCATION table is opened using the Table (all rows in facility) mode, every location belonging to the current facility will be displayed, but all other locations in the database in different facilities, will not be shown.
The third option, Table (all rows in database), opens the selected table with no regard to the current facility. The table opened will simply display all rows in the database, regardless of what facility they belong to. Be aware that this option may take longer to open a table, depending on the number of facilities in the database, table being opened (e.g. DT_RESULT typically contains many more rows than DT_LOCATION), and speed of the network over which the server is being accessed.
The first option, Table, merits additional explanation. When any table is opened using this mode, no data is displayed at all, but each column in the table is filterable. The concept behind this mode is that once the desired data is determined, then, based on the information provided, those data are displayed. The reason for this mode of operation is, again, efficiency. For any given table, it is likely that the rows of interest are a subset of that table. Rather than returning all of the rows in the table, which could be a time-consuming operation, and then narrowing the information down to the rows of particular interest, first narrow down the data of interest and then display just those rows. Of course, in order to effectively use this mode, it is necessary to be familiar with the data in the table.
EQuIS Professional contains a few useful features to let you visually scan your data tables and asses the number of records they contain. Within the Open dialog, empty data tables have their names displayed in black, while those containing data are highlighted in blue. Also, within the icon for each table there is a color-coded scale bar indicating its relative size (going from small and blue, indicating a few records, to high and yellow, indicating many records). Finally, hovering your mouse over a data table will open a bubble that will show you the row count for that table.
•When logged in with application-level security, this option is not available unless the user is part of the Admin role. It is only possible to open the table with rows for the current facility.
•This option is only available if the table has a FACILITY_ID column. For a potentially large table without a FACILITY_ID column, (e.g. DT_LOGGER_DATUM), in order to open a subset of the table, first open a parent table, (e.g. DT_LOGGER or DT_LOGGER_SERIES), select the desired row and then right-click and add Child Table DT_LOGGER_DATUM. Only the subset data of the selected parent will display as shown below.
•If the table has more than 10,000 records it may cause performance issues if the entire table is opened. Open: Table mode is available to load the empty table, then load data by filter input.
To illustrate the use of this mode, consider reviewing water levels in a specific well, B-34, during March of 1996. Instead of opening the DT_WATER_LEVEL table and displaying hundreds or thousand of records and narrowing that information down to B-34 and March 1996, first indicate those parameters and then display just the interesting information. Follow the steps below.
1.Click on the filter symbol in the SYS_LOC_CODE column header.
2.Select Custom from the drop-down list.
3.Select Like from the Operator list.
4.Type B-34 In the Operand list.
Enter the filter parameter for the field MEASUREMENT_DATE in a similar manner.
1.If the filter row is already visible, you must first disable the filter row:
a.Click the arrow next to the Filter icon in the toolbar for the Filter drop-down selection.
c.Uncheck the 'User Filter Row'.
2.Click on the filter symbol in the MEASUREMENT_DATE header.
3.Select Custom from the drop-down list.
4.Select Greater than or equal to from the Operator list.
5.Type 3/1/00 in the Operand list.
6.Click Add a condition.
7.Select Less than from the Operator list.
8.Type in 4/1/00 in the Operand list.
Note: The FACILITY_ID is filtered to the current facility by default.
To display the data, click Refresh. To open a table that has already been opened in a different mode, remove the table from the Workspace. Simply closing the table and reopening it, opens it in the same mode it was originally opened in. To remove it from the Workspace, right-click on the name of the table and select Remove item.