Skip to main content

Comparison operators

This page details the available comparison operators when writing rules as part of the search route.

= (Equal)

The = operator checks exact matches of the specified value:

{
"operator": "=",
"property": "myProperty",
"value": "myExactValue"
}

This operator can also be used to check the value of boolean properties:

{
"operator": "=",
"property": "myBooleanProperty",
"value": true
}

!= (Not Equal)

The != operator checks exact matches of the specified value and returns all results that fail to satisfy the check:

{
"operator": "!=",
"property": "myProperty",
"value": "myExactValue"
}

This operator can also be used to check the value of boolean properties:

{
"operator": "!=",
"property": "myBooleanProperty",
"value": false
}

> (Greater Than)

The > operator checks values larger than the specified value:

{
"operator": ">",
"property": "myNumericProperty",
"value": 7
}

>= (Greater Than or Equal)

The >= operator checks values larger than or equal to the specified value:

{
"operator": ">=",
"property": "myNumericProperty",
"value": 7
}

< (Less Than)

The < operator checks values less than the specified value:

{
"operator": "<",
"property": "myNumericProperty",
"value": 7
}

<= (Less Than or Equal)

The <= operator checks values less than or equal to the specified value:

{
"operator": "<=",
"property": "myNumericProperty",
"value": 7
}

isEmpty

The isEmpty operator checks if the value of the specified property is null:

{
"operator": "isEmpty",
"property": "myProperty"
}

isNotEmpty

The isNotEmpty operator checks if the value of the specified property is not null:

{
"operator": "isNotEmpty",
"property": "myProperty"
}

propertySchema

The propertySchema filter can be used with any standard operator. It allows you to filter entities based on a properties matching a specific type (for example, find all string properties with a given value):

{
"propertySchema": {
"type": "string"
},
"operator": "=",
"value": "My value"
}
tip
  • The propertySchema can be used with any Port property;
  • The propertySchema replaces the property filter when performing property schema search.

between

The between operator checks datetime values and returns entities whose relevant datetime property matches the given range:

{
"operator": "between",
"property": "$createdAt",
"value": {
"preset": "lastWeek"
}
}

Available Presets:

  • tomorrow
  • today
  • yesterday
  • lastWeek
  • last2Weeks
  • lastMonth
  • last3Months
  • last6Months
  • last12Months

The between operator also supports standard date ranges:

{
"combinator": "and",
"rules": [
{
"operator": "between",
"property": "$createdAt",
"value": {
"from": "2022-07-26T16:38:06.839Z",
"to": "2022-07-29T17:00:28.006Z"
}
}
]
}

notBetween

The notBetween operator checks datetime values and returns entities whose relevant datetime property does not match the given range:

{
"operator": "notBetween",
"property": "$createdAt",
"value": {
"preset": "lastWeek"
}
}

contains

The contains operator checks if the specified substring exists in the specified property:

{
"operator": "contains",
"property": "myStringProperty",
"value": "mySubString"
}

doesNotContains

The contains operator checks if the specified value does not exists in the specified property:

{
"operator": "doesNotContains",
"property": "myStringProperty",
"value": "otherValue"
}

containsAny

The containsAny operator checks if any of the specified strings exist in the target array:

{
"operator": "containsAny",
"property": "myArrayProperty",
"value": ["Value1", "Value2", ...]
}

beginsWith

The beginsWith operator checks if the specified property starts with the specified value**

{
"operator": "beginsWith",
"property": "myStringProperty",
"value": "myString"
}

doesNotBeginsWith

The doesNotBeginsWith operator checks if the specified property does not start with the specified value

{
"operator": "doesNotBeginsWith",
"property": "myStringProperty",
"value": "otherValue"
}

endsWith

The endsWith operator checks if the specified property ends with the specified value

{
"operator": "endsWith",
"property": "myStringProperty",
"value": "myString"
}

doesNotEndsWith

The doesNotEndsWith operator checks if the specified property does not end with the specified value

{
"operator": "doesNotEndsWith",
"property": "myStringProperty",
"value": "otherValue"
}

in

The in operator checks if a string property is equal to one or more specified string values

{
"property": "myStringProperty",
"operator": "in",
"value": ["Value1", "Value2"]
}

notIn

The notIn operator checks if a string property is not equal to all of the specified string values

{
"property": "myStringProperty",
"operator": "notIn",
"value": ["Value1", "Value2"]
}