One of the most powerful features in OTbase Inventory is the capability to filter results using numerous criteria.
You are be able to filter records in most tables so that only records with matching characteristics are shown. For example, if we only want to see the newer ControlLogix PLCs, we can filter through the Model column using the string 1756-L7.
Note: The list is filtered as you type. You don't have to hit Enter to start your filtering.
You can combine filter criteria across multiple columns to produce complex queries; values entered are not case sensitive.
Filtering operators
The filter field accepts compact expressions that let you refine results far beyond simple equals matches. By adding a few special characters, you can:
- Negate a term to exclude it entirely
- Match values that are empty / non‑empty
- Set prefix, contains, or minimum‑length conditions
The table below lists the available operators, how to type each one, and explains what they return. Use these in any column that offer free‑text filtering, and combine multiple columns for even more precise queries.
| Filter Expression | Meaning |
|---|---|
| abc | Returns values that start with abc (exact prefix match). |
| %abc | Returns values that contain abc (% is a wildcard for any preceding characters). |
| !abc | Returns values that do not start with abc (negated prefix match). |
| !%abc | Returns values that do not contain abc (negated contains match). |
| _ | Returns non‑empty values (_ represents any single character). |
| ___ | Returns values with at least three characters (each _ is one required character). |
| !_ | Returns empty values (negation of the single‑character placeholder). |
| !___ | Returns values with fewer than three characters (negation of the three‑character requirement). |
In the following example, we want to limit the output to only show safety PLCs. This can be easily accomplished by adding %safety to the filter expression.
Comments
0 comments
Please sign in to leave a comment.