Text Range

New Range

When a Data Table is open and the window has focus, you can set up the ranges that will be used to filter your table data.

  1. On the Home tab, in the Settings group, click the ellipsis [...] button to the right of the Range selection drop-down:

  1. To create a new Text Range, in the Setup Ranges window, right-click on the Ranges node (or a folder) and select Add | New Text Range.

Creating a Text Range which you update with your Equipment Source Path, can be a useful way of keeping a visualisation of your work in progress.

Tip: You can also save an Inline Range as a Text Range. See: Text Range from Inline Range

The Text and Picked Ranges that have already been created are listed on the Ranges tab of the Select Range dialog. Icons help identify the type of range:

Icon Range
Picked
Text

An Expression Filter allows for an alternate or additional filtering process to apply to Picked, Ranges From Field Values and Text Ranges. The Expression should result in a True or False (an IF statement is not necessarily required).

In the example below, only records with a waste volume greater than 1000 BCM are included in the range:

Inverse ranges allow you to set a range that includes everything BUT what is picked. Useful for selective exclusion.

Inline Ranges