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 coal tonnage within the specified range are included:

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

Note: A text/picked range node cache is calculated in 3 stages:

  1. Match all leaf nodes against the text/picked range.

  2. Pass the nodes from Step 1 through the expression filter.

  3. Invert the nodes from Step 2 if necessary.

Inline Ranges