PrintTariff Records: Search Syntax
The Tariff Records screen provides a Search Box. You may enter search criteria into the Search Box to filter the list of Tariff Records displayed. This help article describes the syntax for entering search criteria.
In its simplest form, search criteria consist of a single word. If you want to search for a string containing a space character, specify this string in quotation marks. Without quotation marks, words separated by the space character are treated as individual conditions (using the OR logical operator by default).
You can search against a specific column by preceding a search string with the column's display name plus a colon character.
ColumnDisplayCaption:SearchString
Instead of the complete name, it is possible to partially specify the display name, using the initial characters of a column's display name. A search will be performed against the first found column whose display name starts with the specified substring.
Precede a condition with "+" to select records that match this condition. Other records will be excluded from the result. The "+" specifier allows you to implement the logical AND operator.
Precede a condition with "-" to exclude records that match this condition from the result set.
Here are search criteria examples.
| Search Criteria | Description |
|---|---|
| section | Displays rows that contain the string "section" in any column. |
| part 2 | Displays rows that contain either "part" or "2" in any column. |
| "part 2" | Displays rows that contain the string "part 2" in any column. |
| part +2 | Displays rows that contain both strings "part" and "2" in any column. |
| part +2 -etymology -movies | Displays rows that contain both strings "part" and "2" in any column, excluding rows that contain "etymology" or "movies". |
| ferc:4 | Displays rows that contain "4" in the FERC Record Id column. |
| rec:3.1 | Displays rows that contain "3.1" in the Record Number column. |
