Open Modes for Data Tables and Views

<< 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.







Open just the table or view (with no data). Set filters on desired columns, then select the Refresh Refresh0.5x button to retrieve just the data for the established filters. This mode is ideal for retrieving a small subset of data.

Table (all rows in facility)

Open the table or view with all of the rows for the current facility, excluding records from other facilities.

Table (all rows in database)

Open the entire table or view, regardless of which facility the data belong to. Use this option only when necessary, since opening an entire table or view may take a long time and consume a large amount of system resources.  RT_* tables do not show this, and ALS users may also see restrictions here.


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.


Note: For non-administrator ALS users, table display may be limited based on the Effective Permissions of the user.


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 Refresh0.5x 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.


Note: When using the Filter row to filter a data table in Table mode, a user may receive an error if special characters such as "#" or "," are used. As a workaround, please use a custom filter instead, as discussed in the Using Custom Filters on Data Tables page.




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 Refresh0.5x icon.


Note: The FACILITY_ID is filtered to the current facility by default.