Using Multiple Filter Operators - EcoSys - Administration & Configuration - Hexagon PPM

EcoSys Smart API

Language
English
Product
EcoSys
Search by Category
Administration & Configuration
EcoSys Version
8.7

Using multiple filters operators on same column are not supported, except for the following cases:

  • columnname eq value1 or columnname eq value2

  • columnname ne value1 and columnname ne value2

  • columnname eq value1 or columnname eq value2 or columnname eq value3 or columnname eq value4…

  • columnname ne value1 and columnname ne value2 and columnname ne value3 and columnname ne value4…

  • columnname gt value1 and columnname lt value2 (where value1<value2)

  • columnname lt value1 and columnname gt value2 (where value1>value2)

On different columns, only AND operators are supported.

For example,

columname1 eq value1 and columnname2 eq value2 and columnname3 eq value3......

Invalid Combinations of using filter operators

  • columname1 eq value1 and columnname2 eq value2 or columnname3 eq value3

  • columname1 eq value1 or columnname2 eq value2 and columnname3 eq value3