Supported $filter Comparison Operators - EcoSys - Administration & Configuration - Hexagon PPM

EcoSys Smart API

Language
English (United States)
Product
EcoSys
Search by Category
Administration & Configuration
EcoSys Version
9.0

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