system.mes.oee.getStateRecordsFiltered

Description

Retrieves a filtered list of OEE state records for a specified location and time range, allowing for filtering by event type and minimum duration.

Permissions

This method requires the OEE.READ.GET permission.

Syntax

system.mes.oee.getStateRecordsFiltered(locationPath, startDate, endDate, eventTypes=None, microstopThreshold=None, microstopThresholdTimeUnits='SECONDS', modeCodes=None)

Parameters

Parameter	Type	Nullable	Description
locationPath	String	False	The location path to query.
startDate	Date	False	The start of the time range.
endDate	Date	False	The end of the time range.
availabilityReasonPath	String	True	The path to a availability reason to filter by.
eventTypes	String[]	True	A list of event types to include (e.g., DOWNTIME, RUNNING).
microstopThreshold	Integer	True	A duration to filter out records shorter than this value.
microstopThresholdTimeUnits	String	True	The time units for microstopThreshold (e.g., SECONDS, MINUTES).
modeCodes	Integer[]	True	Integer codes for OEE modes.

Returns

A list of JSON representations of OeeStateRecordDTO objects, each representing a recorded OEE state event.

Each object has the following properties:

Name	Type	Nullable	Description	Default Value
id	String	True	The id of the OEE State Record	null
code	Integer	False	Integer state number	null
locationId	String	False	Identifier of the associated location where this state record was recorded	null
locationName	String	True	Name of the associated location	null
locationPath	String	True	Path of the location where this state record was recorded	null
name	String	False	Name of the recorded state	null
calculationType	OeeStateCalculationType	False	Specifies how this state contributes to OEE calculations	DOWNTIME
color	String	False	Hex color code representing the state visually	"#000000"
status	Status	False	Status of the OEE record (e.g., running, faulted, canceled, complete)	UNKNOWN
startDate	Instant	False	Start date and time of the state record	Instant.now()
endDate	Instant	True	End date and time of the state record	null
duration	Double	False	Duration of the state record in seconds	0.0
availabilityReasonId	String	True	Identifier of the associated availability reason, if applicable	null
availabilityReason	String	True	Title of the availability reason. (Name - Code) For display purposes only	null
availabilityReasonPath	String	True	Path to the current availability reason	null
interruptionLocationId	String	True	Location id that caused the blocked/starved state on the machine	null
interruptionLocationName	String	True	Name of the interruption location that caused the blocked/starved state	null
interruptionLocationPath	String	True	Location path that caused the blocked/starved state on the machine	null
acknowledged	Boolean	False	Boolean indicating whether the state record has been acknowledged	false
acknowledgedBy	String	True	Acknowledged By. This is the user who acknowledged the state record	null
acknowledgedDate	Instant	True	Acknowledged Date. This is the date when the state record was acknowledged	null
modeRecordId	String	True	Identifier of the associated mode record	null
rootCauseStateRecordId	String	True	Identifier of the root cause state record, if applicable	null
primaryAlarmRecordId	String	True	Identifier of the associated OEE Alarm Record, if applicable	null
primaryAlarmName	String	True	Primary alarm name, if applicable	null
primaryAlarmDisplayPath	String	True	Primary alarm display path, if applicable	null
primaryAlarmLabel	String	True	Primary alarm display name, if applicable	null
notes	String	True	Notes associated with the OEE State Record	null
enabled	boolean	True	Indicates whether the OEE State Record is enabled	true
spare1	String	True	Extra field 1	null
spare2	String	True	Extra field 2	null
spare3	String	True	Extra field 3	null

Code Examples

from java.util import Date
from java.util.concurrent import TimeUnit

# Get all "Fault" state records longer than 5 minutes from the last day
location = "Enterprise/Site/Area/Line1"
endTime = Date()
startTime = Date(endTime.getTime() - TimeUnit.DAYS.toMillis(1))

filteredRecords = system.mes.oee.getStateRecordsFiltered(
    locationPath=location,
    startDate=startTime,
    endDate=endTime,
    eventTypes=["Downtime"], # Filter for downtime-related states
    microstopThreshold=5,
    microstopThresholdTimeUnits='MINUTES'
)

for record in filteredRecords:
    print "State:", record['name'], "Duration (min):", record['duration'] / 60.0