Skip to main content
All CollectionsTips & TricksSearch
Advanced Searches - Syntax
Advanced Searches - Syntax
Mike Maat avatar
Written by Mike Maat
Updated this week

Nektar allows for the use of advanced search phrases in search. This is helpful when a normal search provides too much data or when you are looking for something very specific. Advanced search phrases work on both 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

The search value to find in assets/tasks

Can consist of an 'Element' value or a 'Asset Number' (11 digit ID)

For multiple word/digit values, put quotes around search value (i.e. "Ford Truck")

Operations

Used to join multiple search options together. Options include (Must be CAPS):

AND (alternative notation: '+')
OR (alternative notation: '|')

Usability:

  • Can be used in combination with any other option

  • Can be used 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 that have elements contains '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)

Indicates a specific column (by name) to look for desired value in. If the column provided is invalid, default behavior is to ignore column specification.

Notation (Where value in square brackets is replaced by 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)

Used to apply a criteria to the value being searched. Options include (Must be CAPS):
​Must Be 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

Returns: All assets where 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 definition contains 'Employee' and column 'favorite number' between 5 and 10

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


Returns: All tasks where definition contains 'Payroll' and column 'hours' greater than 8

Did this answer your question?