Supported event filters

Active between

You can query for events that were active within a specific time window. All supported datetime formats are valid. The format for the query is:

ActiveBetween[date_1, date_2]

Example

Query for retrieving events that are active between July 31, 2025, 12:01:19 AM (UTC), and August 1, 2025, 12:01:19 AM (UTC):

ActiveBetween[2025-07-30T20:01:19,2025-07-31T20:01:19]

Property filter

You can query for events through its various properties such as id, name, typeId, ad hoc and type properties. You can utilize the following operators:

The format of a property filter query is [property] [operator] '[value]'. To use single quotes or backslashes within a string value, they must be escaped with a backslash “\”. You can query basic event properties (such as id, name, modified date – see Modeling events), ad hoc properties, or properties defined on types.

If a property has a unit of measure, then a compatible unit of measure must be provided in the query condition. If no unit of measure is provided, then “None” is assumed and the result set may not match expectations. Similarly, if a property is defined by an enumeration set, then the ID of the enumeration set must be provided. See examples below.

Querying using a property name by itself will search both ad hoc and type properties matching that name. To query specifically for type properties, the query format is changed to prepend the property with the type ID:[type id]/[property] [operator] '[value]'. Specifying the type ID will return events only of that specific type and not types derived from that type. If the type property defines a unit of measure, then it can be omitted in the condition unless you want to query using a different but compatible unit of measure in which case the service will handle unit conversions. Likewise, the enumeration set ID can also be omitted for type properties.

Note: Filtering by the unknown unit of measure field is not supported.

Examples

• Querying for events whose id is "wind-turbine-maintenance-001".

  id eq 'wind-turbine-maintenance-001'

• Querying for events whose name ends with 'Maintenance'.

  name endsWith 'Maintenance'

• Querying for events that got modified after Nov 23, 2024, 9:00:00 AM (UTC).

  ModifiedDate gt 2024-11-23T04:00:00

• Querying for events whose type is 'TurbineMaintenanceEvent'.

  typeId eq 'TurbineMaintenanceEvent'

  Note: Only the eq operator can be used when querying by typeId.

• Querying for events whose power output is in a list of specific values in measured in kW. The query below will check for both ad hoc and type properties named "powerOutput" whose values are among the provided set.

  powerOutput in [6.8, 4, 5.2] uom:kW

  To perform the same query but for a property defined on a type, prepend the type id ('TurbineMaintenanceEvent') followed by a slash ‘/’. This will match only events of the TurbineMaintenanceEvent type and not any events using types derived from that type. The unit of measure can be omitted.

  TurbineMaintenanceEvent/powerOutput in [6.8, 4, 5.2]

• Querying for events with enumeration properties defined in the 'MaintenanceType' set.

  MaintenanceType eq 'Inspection' EnumerationSetId:MaintenanceType

• Querying for events with an enumeration property defined on the TurbineMaintenanceEvent type. The EnumerationSetId can be omitted.

  TurbineMaintenanceEvent/MaintenanceType in ['Corrective', 'Inspection']

Relationship filter

You can query for events based on their relationships with other events and entities. There are two different formats for this kind of query.

Querying with Relationship ID

The format for this query is:

[relationshipId]->['target_value_1', ‘target_value_2']

The following query example will search for events that have both an ad hoc AND type relationship id RequiredParts and whose targets consists of events/entities with ids 'gearbox-replacement-kit' or 'gearbox-assembly'

[RequiredParts]->['gearbox-replacement-kit', 'gearbox-assembly']

Querying with Type Relationship ID

The format for this query is:

[typeId/relationshipId]->['target_value_1', ‘target_value_2']

The following example query will query on type relationships whose id is PreviousMaintenanceEvent. You add the type id ('TurbineMaintenanceEvent') at the beginning followed by a slash ‘/’:

[TurbineMaintenanceEvent/PreviousMaintenanceEvent]->[ 'wind-turbine-maintenance-000', 'wind-turbine-maintenance-0000']

Querying with target IDs

The format for this query is:

[*]->['target_value_1', ‘target_value_2']

This example query will look for any relationship whose target id is 'gearbox-replacement-kit':

[*]->['gearbox-replacement-kit']

Combining filters

Multiple filters can be combined using the "and" keyword. "Or" is not supported. For optimal query performance, specify the most restrictive filter first.

Name eq 'Annual Turbine Maintenance' and [RequiredParts]->['gearbox-replacement-kit']