<< Click to Display Table of Contents >> Navigation:  Professional > Tables & Views > Open Modes for Data Tables and Views

•Table (all rows in facility) Mode

•Table (all rows in database) Mode

•Table Mode

 

For EQuIS Professional administrators (Application Level Security admin or direct SQL connection), there are three modes for opening a Data table or view. Access these through the Open drop-down within the Open Window.

 

 

 

To open an already-open table in a different mode, remove the table from the Workspace by right-clicking on the name of the table and selecting Remove item. Simply closing the table and reopening it opens it in the same mode it was originally opened in.

 

 

Table (all rows in facility) Mode

 

The Open drop-down defaults to the Table (all rows in facility) option. When a table is opened in this mode, rows show the data pertinent to that facility (i.e. the FACILITY_ID in that table equals DT_FACILITY.FACILITY_ID for 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 in the current facility will be displayed, but all other locations in the database, from different facilities, will not be shown.

 

The Table (all rows in facility) option is only available if the table has a FACILITY_ID column. Some tables do not contain a FACILITY_ID column and are potentially large (such as DT_LOGGER_DATUM). Open a subset of the table by adding a related child table to a parent table (such as DT_LOGGER or DT_LOGGER_SERIES).

 

 

Table (all rows in database) Mode

 

The Table (all rows in database) option opens the selected table without considering facility. The table opened will simply display all rows in the database, regardless of what facility they belong to. This option may take longer to open a table, depending on factors like the number of facilities in the database, the table being opened (e.g. DT_RESULT typically contains many more rows than DT_LOCATION), and network speed.

 

When logged in with Application Level Security, only users in the Admin role can see the Table (all rows in database) option.

 

 

Table Mode

 

Based on the row counts, a user may want to open the table without data so that it loads faster. The Table mode does not show any records upon opening and thus loads quickly compared to a table with many records. Use Table mode as follows:

1.In the Open window, select a data table.

2.Click the Open drop-down under the table listing, then select the Table option.
 

 

3.Open the table. The columns will appear, but no records.

4.Add filters to columns as desired.

5.Click Refresh in the grid toolbar to display only the records that meet the criteria.

 

This mode of operation exists for efficiency; for example, opening over 10,000 records, compared to just a subset of data, could cause performance issues. Users must be familiar with the table’s data to effectively use this mode.

 

 

Example

 

To illustrate the use of this mode, consider reviewing water levels in a specific well, B-34, after 1996. Instead of opening the DT_WATER_LEVEL table and displaying hundreds or thousands of records and narrowing that information down to B-34 and 1997 onwards, first indicate those parameters and then display just the information of interest. Follow the steps below. 

1.Open the DT_WATER_LEVEL table with "Table" selected under the "Open:" drop-down under the list of tables.

2.With the filter row turned on, type "B-34" under SYS_LOC_CODE.

3.Click on the '=' sign on the left side of the 'measurement_date' filter cell.

4.Change it to 'Greater than or equal to'.

5.Type in the date for the first day of 1997, formatted to match how dates display in your database based on your regional settings (e.g. '01/01/1997' or '1997-01-01'). 

6.To display the data, click the Refresh icon.