Reference 360

Back Next

Filter criteria

You can filter code values in a code list and export the results.

You can filter values for the code attribute or the attributes that are configured as display attributes. For example, you can filter values for the code attribute with

001

Supported filter operators and filter values for fields

The filter operators depend on the field type of the attribute.

The following table describes the filter operators that you can use for each field type:

Field Type	Supported Filter Operators	Filter Values
Boolean	_equals _notEquals _isEmpty	Boolean
Decimal or Integer	_equals _notEquals _isEmpty _greaterThan _greaterThanEquals _lessThan _lessThanEquals	Number
String	_equals _notEquals _isEmpty _startsWith _endsWith _contains _doesNotContain	Text
Date	_equals _notEquals _isEmpty _from> _to _range	ISO 8601 date For example, 2019-12-24 .
DateTime	_equals _notEquals _isEmpty _from _to _range	ISO 8601 date and time For example, 2019-12-15T14:17:04Z .
Reference Data	_equals _notEquals _isEmpty _in	Values in the Code attribute or values in the display attributes for the reference data.

Filter examples

To filter assets with fields that are equal to NY, you can use the following filter operator:

{
   "state":{
      "_equals":"NY"
   }
}

To filter assets with fields that are not equal to NY, you can use the following filter operator:

{
   "state":{
      "_notEquals:":"NY"
   }
}

To filter assets with numeric fields that are greater than 68, you can use the following filter operator:

{
   "age":{
      "_greaterThan":68
   }
}

To filter assets with numeric fields that are greater than or equal to 68, you can use the following filter operator:

{
   "age":{
      "_greaterThanEquals":68
   }
}

To filter assets with numeric fields that are less than 68, you can use the following filter operator:

{
   "age":{
      "_lessThan":68
   }
}

To filter assets with numeric fields that are less than or equal to 68, you can use the following filter operator:

{
   "age":{
      "_lessThanEquals":68
   }
}

To filter assets with fields that match any of the specified values, you can use the following filter operator:

{
   "state":{
      "_in":[
         "NY",
         "CA"
      ]
   }
}

To use multiple field operators, you can use the _and or _or operators.

To filter assets with fields that match all the specified values, you can use the following filter operator:

{
   "_and":[
      {
         "state":"CA"
      },
      {
         "age":68
      }
   ]
}

To filter assets with fields that match at least one of the specified values, you can use the following filter operator:

{
   "_or":[
      {
         "state":"CA"
      },
      {
         "age":68
      }
   ]
}

When you use a comma in the code, the comma acts like an

_and

operator. For example, the following code filters the state "NY" and people of age "68":

{
   {
      "state":"NY"
   },
   {
      "age":68
   }
}

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Filter criteria

Filter criteria

Supported filter operators and filter values for fields

Filter examples