Whereas a standard filter enables you to specify a set of boreholes to output, a range filter enables you to screen for records at a lower level in the table hierarchy. They also provide a useful querying feature that lets you find items within particular depth ranges, hence the name. For example, you may want to see data from SAMPLE records with depths between 10 and 20 feet, or test records for all specimens from a particular lithology layer.
Note: To perform the exercises in this wiki requires the use of these training project and library files: gINT Std Training Library & Project.zip.
IMPORTANT: Ensure that the current library is training.glb. If not, select File -> Change Library.
Go to INPUT. Click the List icon.
In the PROJECT DATA TABLES dialog box, uncheck the Hide checkbox for the TESTS table, and click OK.
Click the Tests tab to view the contents of the TESTS table. Note that for a particular borehole (specified in the object selector) there is a set of records containing test values, one record at each of several depths.
Go to OUTPUT -> Text Tables. Select ‘TEST SUMMARY’ in the object selector if not already selected.
Preview the report and zoom in on the text. Notice that 15 records appear, five each for each of three boreholes.
Close the preview.
We would like to only see test data from lithology layers with clay soils (USCS code of ‘CL’). Enter the following query specifications, using the Data Tool beneath Filters.
We would like to see if any tests in the clay layers indicated unstable soil, as shown by a plastic limit higher than 50. In the standard filter grid (to the left of the range filter grid), enter the following:
Preview the report, and zoom in. Notice that only one record appears, and it has a plastic limit value of 51. Any conditions you specify in the standard filter grid are “AND-ed” with those in the range filter grid.
Close the preview, change the Criteria setting in the standard filter to ‘>40’, and preview and zoom again. Now there are two records, one with a plastic limit of 51 in ‘B-1’, and one with 47 in ‘B-2’. Close the preview.
You can save and retrieve range filters. Click the Save button above the range filter grid, and enter a Name of ‘CLAY SOILS’, then click OK. Click the drop-down arrow under Stored Range Filters. Notice that the range filter ‘CLAY SOILS’ appears in the list. You can open this range filter again at a later time by selecting it from this drop-down list.