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