Nektar allows for the use of advanced search phrases. This is helpful when a normal search returns too many results or when you are looking for something very specific. Advanced search phrases work on the web and mobile apps, as well as through the API, but must follow a specific syntax.
All searches are constructed with the following components.
Option | Details |
Search Value | Find the value in assets and tasks. Can consist of an Element value or an Asset Number (e.g. 11 digit ID). For multiple word/digit values, put quotes around the search value (e.g. "Ford Truck"). |
Operations | Join multiple search options. Search terms must include the operation in CAPS. AND (alternative notation: '+') OR (alternative notation: '|') Use
Examples12345 OR 78910
Nektar AND "HR Employee
Truck OR Skidsteer AND Dozer
|
Columns (optional) | Directs the search to look for a value in a specific column (by name). If the column provided is invalid, the default behaviour is to ignore the column specification. Notation - where the value in square brackets is replaced by the desired column name. {[COLUMN_NAME]}: "Search Value" Header Columns (Asset/Task)
Header Columns (Asset Only)
Header Columns (Task Only)
All other column names are derived from element Definition Names/Mobile Labels.
Examples{username}: johndoe.nektar
{id #}: E58 OR {id #}: E56
{asset definition}: Trucks AND {status}: Broken
|
Alterations (optional) | Apply criteria to the searched value. The operation must be in CAPS.
NOT (alternative notation: '!') Must be used on columns of type numeric or date (before column/value). OVER (alternative notation: '>') UNDER (alternative notation: '<') Must be between two search values and column must be specified (before column/value). TO (alternative notation: '..') ExamplesNOT {username}: johndoe.nektar
{asset definition}: Trucks AND UNDER {Fuel (Litre)}: 20
{last modified}: "9/13/2023" TO "9/20/2023"
{asset definition}: Employee AND {favorite number}: 5 .. 10
{task name}: Payroll AND OVER {hours}: 8
|