Skip to main content
All CollectionsSearch
Advanced Searches - Syntax
Advanced Searches - Syntax

Get better results

Mike Maat avatar
Written by Mike Maat
Updated over 4 months ago

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

  • Combine with any option and as many times as required.

  • No grouping options (single level).

  • AND takes priority over OR.

Examples

12345 OR 78910

  • Returns all assets/tasks where an element contains 12345 and/or 78910.

​Nektar AND "HR Employee

  • Returns all assets/tasks with elements that contain Nektar and HR Employee.

Truck OR Skidsteer AND Dozer

  • Returns all assets/tasks where an element contains Truck or contains 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)

  • {Created Date}:

  • {Last Modified}:

  • {Username}:

  • {Project Name}:

  • {Latitude:}:

  • {Longitude}:

  • {Asset Number}:

Header Columns (Asset Only)

  • {Asset Definition ID}:

  • {Asset Definition}:

Header Columns (Task Only)

  • {Task Operation}:

  • {Task Name}:

  • {Asset Identifier}:

  • {Work Order}:

All other column names are derived from element Definition Names/Mobile Labels.

Examples

{username}: johndoe.nektar

  • Returns all assets/tasks where column Username is johndoe.nektar.

​{id #}: E58 OR {id #}: E56

  • Returns all assets/tasks where column id # contains E58 or where column id # contains E56.

{asset definition}: Trucks AND {status}: Broken

  • Returns all assets where asset definition contains Truck and column Status equals Broken.

Alterations (optional)

Apply criteria to the searched value. The operation must be in CAPS.


​Must be the leading field (before column/value).

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: '..')

Examples

NOT {username}: johndoe.nektar

  • Returns all assets/tasks where column Username is not johndoe.nektar.

{asset definition}: Trucks AND UNDER {Fuel (Litre)}: 20

  • Return all assets where the definition contains Truck and column Fuel (litre) under 20.

{last modified}: "9/13/2023" TO "9/20/2023"

  • Returns all assets/tasks that were modified between today and last week.

{asset definition}: Employee AND {favorite number}: 5 .. 10

  • Returns all assets where the definition contains Employee and column favourite number between 5 and 10.

{task name}: Payroll AND OVER {hours}: 8

  • Returns all tasks where the definition contains Payroll and column hours is greater than 8


Related articles

Did this answer your question?