Use Predicates - Nextedy Documentation

Predicate Basics

Predicates are conditions placed in the where clause of a source query. The query engine evaluates predicates to determine which entities from Siemens Polarion ALM are included in the sheet. Simple predicates compare a property value to a target; composite predicates combine multiple conditions with AND/OR logic.

Use Equality Predicates

The simplest predicate matches a property to an exact value:

sources:
  - id: main
    model: rtm-model
    query:
      from: UserNeed
      where:
        severity: critical

This returns only UserNeed entities where severity equals critical.For explicit equality syntax:

where:
  severity:
    eq: critical

Use Comparison Operators

The following comparison operators are available for filtering:

Operator	Meaning	Example
`eq`	Equals	`severity: { eq: critical }`
`ne`	Not equals	`status: { ne: deleted }`
`gt`	Greater than	`priority: { gt: 3 }`
`ge`	Greater than or equal	`priority: { ge: 2 }`
`contains`	Substring match	`title: { contains: safety }`

where:
  priority:
    gt: 3

The gt and ge operators work with numeric properties (integer, float). They are not applicable to string or boolean properties.

Check for Null Values

Null value predicates (eq: null and ne: null) are not working in the current version. The syntax shown below is the intended usage once the limitation is resolved, but these predicates will not currently filter entities by null status. Use alternative filtering approaches until this is fixed.

To filter entities based on whether a property has a value:

# Entities where title IS NOT null (has a value)
where:
  title:
    ne: null

# Entities where title IS null (missing value)
where:
  title:
    eq: null

Once functional, null checks will be useful for finding incomplete work items or ensuring required fields are populated.

Combine Predicates with AND

Use the and operator to require all conditions to match:

where:
  and:
    - severity: critical
    - status: approved

This returns entities that are both critical severity AND approved status. AND arrays support any number of sub-predicates:

where:
  and:
    - severity: critical
    - status: approved
    - priority:
        ge: 2

Combine Predicates with OR

Use the or operator when any condition should match:

where:
  or:
    - severity: critical
    - severity: major

This returns entities where severity is either critical OR major.

Nest Composite Predicates

AND and OR predicates can be nested for complex filtering logic:

where:
  and:
    - status: approved
    - or:
        - severity: critical
        - severity: major

This returns approved entities with either critical or major severity.

Verification

After updating the where clause in your sheet configuration and reloading the document:

You should now see only entities that match your predicate conditions
The row count in the sheet should reflect the filtered result set
Verify that excluded entities are not displayed in the sheet

​Predicate Basics

​Verification

​See Also

Predicate Basics

Verification

See Also