Supported $filter Comparison Operators - EcoSys - Customization & Programming - Hexagon

EcoSys Smart API

ft:locale
en-US
Product
EcoSys
Search by Category
Customization & Programming
EcoSys Version
9.3

The following operators can be used along with the filter OData query options.

Operator

Description

Example

eq

Equal

CostObjects?$filter=CostObjectID eq 'SmartAPI CO 1'

ne

Not equal

CostObjects?$filter=CostObjectID ne 'SmartAPI CO 1'

gt

Greater than

CostObjects?$filter=CreateDate gt 2019-01-01

lt

Less than

CostObjects?$filter=CreateDate lt 2020-12-31

ge

Greater than equal

CostObjects?$filter=CreateDate ge 2020-12-31

le

Less than equal

CostObjects?$filter=CreateDate le 2020-12-31

and

Logical and

CostObjects?$filter=CreateDate ge 2019-01-02 and CreateDate le 2020-12-31

or

Logical or

CostObjects?$filter=CreateDate ge 2019-01-02 or CreateDate le 2020-12-31

contains

Contains

CostObjects?$filter=contains(CostObjectID,'SMARTAPI')

notcontains

Not contains

CostObjects?$filter=not contains(CostObjectID,'SMARTAPI')

In

In

CostObjects?$filter=CostObjectStatus in ('Planning')

Not In

Not In

CostObjects?$filter=not (CostObjectStatus in ('Planning'))