API Documentation
GraphQL is a powerful query language that makes your data accessible through an API. It enables your applications to ask for specific fields on a filtered set of objects and returns only the data that is requested with minimal overhead. Read more about the benefites of GraphQL on our developer hub. There you will find tutorials, guides, tipps, and complex example queries.
API Endpoints
https://api.machinemetrics.com/graphql
Headers
Authorization: Bearer <YOUR API KEY>
Authentication
The MachineMetrics GraphQL API is read-only. To interact with the API, you must have credentials. You can find a detailed example of how to set up authentication in our Getting Started Section.
Global Limits
To provide the best service availability and performance for all of our customers, we enforce API usage limits:
- The maximum number of requests per minute and company is 1000.
- The maximum query time is 10 seconds.
- The returned JSON object cannot be more than three nesting levels deep (top level counting as level 1).
- The total number of nodes (= queries + subqueries) cannot exceed 5.
Queries
activities
Response
Returns [Activity!]!
Arguments
Name | Description |
---|---|
distinct_on - [Activity_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [Activity_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - Activity_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Activities(
$distinct_on: [Activity_select_column!],
$limit: Int,
$offset: Int,
$order_by: [Activity_order_by!],
$where: Activity_bool_exp
) {
activities(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activityRef
activitySet {
...ActivitySetFragment
}
activityType {
...ActivityTypeFragment
}
endAt
startAt
}
}
Variables
{
"distinct_on": ["activityRef"],
"limit": 123,
"offset": 123,
"order_by": [Activity_order_by],
"where": Activity_bool_exp
}
Response
{
"data": {
"activities": [
{
"activityRef": 982312,
"activitySet": ActivitySet,
"activityType": ActivityType,
"endAt": "2022-05-07T01:08:03.420Z",
"startAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
activitySet
Response
Returns an ActivitySet
Arguments
Name | Description |
---|---|
activitySetRef - bigint!
|
A unique, numeric identifier for the activitySet. |
Example
Query
query ActivitySet($activitySetRef: bigint!) {
activitySet(activitySetRef: $activitySetRef) {
activePartTimeMs
activeTimeMs
activities {
...ActivityFragment
}
activitySetRef
actualParts
closedAt
cycleTimeMs
expectedSetupTimeMs
expectedUnitDurationMs
machine {
...MachineTPFragment
}
operation {
...OperationFragment
}
optimalPartTimeMs
partCountMultiplier
partTimeMs
sampleCycleCount
samplePartCount
touchPartTimeMs
touchTimeMs
workOrderId
workOrderOperation {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{"activitySetRef": 982312}
Response
{
"data": {
"activitySet": {
"activePartTimeMs": 123,
"activeTimeMs": 987,
"activities": [Activity],
"activitySetRef": 982312,
"actualParts": 987.65,
"closedAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 123,
"expectedSetupTimeMs": 123,
"expectedUnitDurationMs": 987,
"machine": MachineTP,
"operation": Operation,
"optimalPartTimeMs": 123,
"partCountMultiplier": 123.45,
"partTimeMs": 123,
"sampleCycleCount": 123,
"samplePartCount": 123,
"touchPartTimeMs": 987,
"touchTimeMs": 123,
"workOrderId": "xyz789",
"workOrderOperation": erpWorkOrderOperations
}
}
}
activitySets
Response
Returns [ActivitySet!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [ActivitySet_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - ActivitySet_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ActivitySets(
$limit: Int,
$offset: Int,
$order_by: [ActivitySet_order_by!],
$where: ActivitySet_bool_exp
) {
activitySets(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activePartTimeMs
activeTimeMs
activities {
...ActivityFragment
}
activitySetRef
actualParts
closedAt
cycleTimeMs
expectedSetupTimeMs
expectedUnitDurationMs
machine {
...MachineTPFragment
}
operation {
...OperationFragment
}
optimalPartTimeMs
partCountMultiplier
partTimeMs
sampleCycleCount
samplePartCount
touchPartTimeMs
touchTimeMs
workOrderId
workOrderOperation {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{
"limit": 123,
"offset": 123,
"order_by": [ActivitySet_order_by],
"where": ActivitySet_bool_exp
}
Response
{
"data": {
"activitySets": [
{
"activePartTimeMs": 987,
"activeTimeMs": 987,
"activities": [Activity],
"activitySetRef": 982312,
"actualParts": 123.45,
"closedAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 123,
"expectedSetupTimeMs": 123,
"expectedUnitDurationMs": 987,
"machine": MachineTP,
"operation": Operation,
"optimalPartTimeMs": 987,
"partCountMultiplier": 987.65,
"partTimeMs": 123,
"sampleCycleCount": 987,
"samplePartCount": 123,
"touchPartTimeMs": 987,
"touchTimeMs": 987,
"workOrderId": "xyz789",
"workOrderOperation": erpWorkOrderOperations
}
]
}
}
activityType
Response
Returns an ActivityType
Arguments
Name | Description |
---|---|
activityTypeRef - bigint!
|
A unique, numeric identifier for the activityType. |
Example
Query
query ActivityType($activityTypeRef: bigint!) {
activityType(activityTypeRef: $activityTypeRef) {
activityMode
activityTypeRef
company {
...CompanyTPFragment
}
name
}
}
Variables
{"activityTypeRef": 982312}
Response
{
"data": {
"activityType": {
"activityMode": "production",
"activityTypeRef": 982312,
"company": {"name": "Cyberdyne"},
"name": "xyz789"
}
}
}
activityTypes
Response
Returns [ActivityType!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [ActivityType_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - ActivityType_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ActivityTypes(
$limit: Int,
$offset: Int,
$order_by: [ActivityType_order_by!],
$where: ActivityType_bool_exp
) {
activityTypes(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activityMode
activityTypeRef
company {
...CompanyTPFragment
}
name
}
}
Variables
{
"limit": 987,
"offset": 987,
"order_by": [ActivityType_order_by],
"where": ActivityType_bool_exp
}
Response
{
"data": {
"activityTypes": [
{
"activityMode": "production",
"activityTypeRef": 982312,
"company": {"name": "Cyberdyne"},
"name": "abc123"
}
]
}
}
aggregatedAlarms
Response
Returns [AggregatedAlarmsRT!]!
Arguments
Name | Description |
---|---|
args - aggregatedAlarms_args
|
A set of arguments passed to the function. |
distinct_on - [AggregatedAlarmsRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AggregatedAlarmsRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AggregatedAlarmsRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query AggregatedAlarms(
$args: aggregatedAlarms_args,
$distinct_on: [AggregatedAlarmsRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [AggregatedAlarmsRT_order_by!],
$where: AggregatedAlarmsRT_bool_exp
) {
aggregatedAlarms(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
bucketEndAt
bucketStartAt
description
durationMs
label
machineRef
maxEndAt
minStartAt
nativeCode
recordCount
status
}
}
Variables
{
"args": aggregatedAlarms_args,
"distinct_on": ["bucketEndAt"],
"limit": 987,
"offset": 123,
"order_by": [AggregatedAlarmsRT_order_by],
"where": AggregatedAlarmsRT_bool_exp
}
Response
{
"data": {
"aggregatedAlarms": [
{
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"description": "abc123",
"durationMs": numeric,
"label": "xyz789",
"machineRef": 987,
"maxEndAt": "2022-05-07T01:08:03.420Z",
"minStartAt": "2022-05-07T01:08:03.420Z",
"nativeCode": "abc123",
"recordCount": 987,
"status": "abc123"
}
]
}
}
aggregatedPartCounts
Response
Returns [AggregatedPartCountRT!]!
Arguments
Name | Description |
---|---|
args - aggregatedPartCounts_args!
|
A set of arguments passed to the function. |
distinct_on - [AggregatedPartCountRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AggregatedPartCountRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AggregatedPartCountRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query AggregatedPartCounts(
$args: aggregatedPartCounts_args!,
$distinct_on: [AggregatedPartCountRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [AggregatedPartCountRT_order_by!],
$where: AggregatedPartCountRT_bool_exp
) {
aggregatedPartCounts(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
avgValue
bucketEndAt
bucketStartAt
bucketWidth
eventCount
firstBucketEventTime
firstValue
lastBucketEventTime
lastValue
machine {
...MachineTPFragment
}
machineRef
maxValue
metricKey
minValue
sumOfValues
}
}
Variables
{
"args": aggregatedPartCounts_args,
"distinct_on": ["avgValue"],
"limit": 987,
"offset": 987,
"order_by": [AggregatedPartCountRT_order_by],
"where": AggregatedPartCountRT_bool_exp
}
Response
{
"data": {
"aggregatedPartCounts": [
{
"avgValue": 43.12,
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"bucketWidth": "1h",
"eventCount": 123,
"firstBucketEventTime": "2022-05-07T01:08:03.420Z",
"firstValue": 987,
"lastBucketEventTime": "2022-05-07T01:08:03.420Z",
"lastValue": 987,
"machine": MachineTP,
"machineRef": 123,
"maxValue": 987,
"metricKey": "xyz789",
"minValue": 123,
"sumOfValues": 987
}
]
}
}
aggregatedQuantities
Response
Returns [AggregatedQuantityRT!]!
Arguments
Name | Description |
---|---|
args - aggregatedQuantities_args!
|
A set of arguments passed to the function. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AggregatedQuantityRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AggregatedQuantityRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query AggregatedQuantities(
$args: aggregatedQuantities_args!,
$limit: Int,
$offset: Int,
$order_by: [AggregatedQuantityRT_order_by!],
$where: AggregatedQuantityRT_bool_exp
) {
aggregatedQuantities(
args: $args,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
avgValue
bucketEndAt
bucketStartAt
bucketWidth
eventCount
firstBucketEventTime
firstValue
lastBucketEventTime
lastValue
machine {
...MachineTPFragment
}
machineRef
maxValue
metricKey
minValue
sumOfValues
}
}
Variables
{
"args": aggregatedQuantities_args,
"limit": 987,
"offset": 123,
"order_by": [AggregatedQuantityRT_order_by],
"where": AggregatedQuantityRT_bool_exp
}
Response
{
"data": {
"aggregatedQuantities": [
{
"avgValue": 43.12,
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"bucketWidth": "1h",
"eventCount": 123,
"firstBucketEventTime": "2022-05-07T01:08:03.420Z",
"firstValue": 43.12,
"lastBucketEventTime": "2022-05-07T01:08:03.420Z",
"lastValue": 43.12,
"machine": MachineTP,
"machineRef": 987,
"maxValue": 43.12,
"metricKey": "abc123",
"minValue": 43.12,
"sumOfValues": 43.12
}
]
}
}
alarmIntervals
Response
Returns [AlarmIntervalRT!]!
Arguments
Name | Description |
---|---|
args - alarmIntervals_args!
|
A set of arguments passed to the function. |
distinct_on - [AlarmIntervalRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AlarmIntervalRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AlarmIntervalRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query AlarmIntervals(
$args: alarmIntervals_args!,
$distinct_on: [AlarmIntervalRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [AlarmIntervalRT_order_by!],
$where: AlarmIntervalRT_bool_exp
) {
alarmIntervals(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
description
endAt
label
machine {
...MachineTPFragment
}
machineRef
metricKey
nativeCode
sequence
startAt
}
}
Variables
{
"args": alarmIntervals_args,
"distinct_on": ["description"],
"limit": 123,
"offset": 987,
"order_by": [AlarmIntervalRT_order_by],
"where": AlarmIntervalRT_bool_exp
}
Response
{
"data": {
"alarmIntervals": [
{
"description": "xyz789",
"endAt": "2022-05-07T01:08:03.420Z",
"label": "abc123",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "abc123",
"nativeCode": "xyz789",
"sequence": 987,
"startAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
annotationTypes
Response
Returns [AnnotationTypeTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AnnotationTypeTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AnnotationTypeTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query AnnotationTypes(
$limit: Int,
$offset: Int,
$order_by: [AnnotationTypeTP_order_by!],
$where: AnnotationTypeTP_bool_exp
) {
annotationTypes(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
annotationTypeRef
annotations {
...AnnotationTPFragment
}
color
company {
...CompanyTPFragment
}
erpReason {
...erpReasonFragment
}
isArchived
name
}
}
Variables
{
"limit": 123,
"offset": 987,
"order_by": [AnnotationTypeTP_order_by],
"where": AnnotationTypeTP_bool_exp
}
Response
{
"data": {
"annotationTypes": [
{
"annotationTypeRef": 987,
"annotations": [AnnotationTP],
"color": "abc123",
"company": {"name": "Cyberdyne"},
"erpReason": erpReason,
"isArchived": false,
"name": "abc123"
}
]
}
}
annotations
Response
Returns [AnnotationTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [AnnotationTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - AnnotationTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Annotations(
$limit: Int,
$offset: Int,
$order_by: [AnnotationTP_order_by!],
$where: AnnotationTP_bool_exp
) {
annotations(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
annotationRef
annotationType {
...AnnotationTypeTPFragment
}
companyId
description
endAt
isPlanned
machine {
...MachineTPFragment
}
machineRef
startAt
}
}
Variables
{
"limit": 123,
"offset": 987,
"order_by": [AnnotationTP_order_by],
"where": AnnotationTP_bool_exp
}
Response
{
"data": {
"annotations": [
{
"annotationRef": 123,
"annotationType": AnnotationTypeTP,
"companyId": "abc123",
"description": "abc123",
"endAt": "2022-05-07T01:08:03.420Z",
"isPlanned": false,
"machine": MachineTP,
"machineRef": 987,
"startAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
companies
Description
Fetch all companies accessible by the role.
Response
Returns [CompanyTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [CompanyTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - CompanyTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Companies(
$limit: Int,
$offset: Int,
$order_by: [CompanyTP_order_by!],
$where: CompanyTP_bool_exp
) {
companies(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activityTypes {
...ActivityTypeFragment
}
addressText
annotationTypes {
...AnnotationTypeTPFragment
}
companyId
location {
...LocationFragment
}
machines {
...MachineTPFragment
}
name
operations {
...OperationFragment
}
operators {
...OperatorTPFragment
}
rejectReasons {
...RejectReasonFragment
}
timeZone
}
}
Variables
{
"limit": 987,
"offset": 987,
"order_by": [CompanyTP_order_by],
"where": CompanyTP_bool_exp
}
Response
{
"data": {
"companies": [
{
"activityTypes": [ActivityType],
"addressText": "120 Podmayer Lane, Amherst, MA 01002",
"annotationTypes": [AnnotationTypeTP],
"companyId": "abc123",
"location": Location,
"machines": [MachineTP],
"name": "abc123",
"operations": [Operation],
"operators": [OperatorTP],
"rejectReasons": [RejectReason],
"timeZone": "xyz789"
}
]
}
}
currentAlarmsByMachine
Response
Returns [CurrentAlarmRT!]!
Arguments
Name | Description |
---|---|
args - currentAlarmsByMachine_args
|
A set of arguments passed to the function. |
distinct_on - [CurrentAlarmRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [CurrentAlarmRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - CurrentAlarmRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query CurrentAlarmsByMachine(
$args: currentAlarmsByMachine_args,
$distinct_on: [CurrentAlarmRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [CurrentAlarmRT_order_by!],
$where: CurrentAlarmRT_bool_exp
) {
currentAlarmsByMachine(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
description
label
latestEventAt
machine {
...MachineTPFragment
}
machineRef
metricKey
nativeCode
startAt
}
}
Variables
{
"args": currentAlarmsByMachine_args,
"distinct_on": ["description"],
"limit": 123,
"offset": 987,
"order_by": [CurrentAlarmRT_order_by],
"where": CurrentAlarmRT_bool_exp
}
Response
{
"data": {
"currentAlarmsByMachine": [
{
"description": "abc123",
"label": "abc123",
"latestEventAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "xyz789",
"nativeCode": "xyz789",
"startAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
currentStatesByMachine
Response
Returns [CurrentStateRT!]!
Arguments
Name | Description |
---|---|
args - currentStatesByMachine_args
|
A set of arguments passed to the function. |
distinct_on - [CurrentStateRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [CurrentStateRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - CurrentStateRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query CurrentStatesByMachine(
$args: currentStatesByMachine_args,
$distinct_on: [CurrentStateRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [CurrentStateRT_order_by!],
$where: CurrentStateRT_bool_exp
) {
currentStatesByMachine(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
latestEventAt
machine {
...MachineTPFragment
}
machineRef
metricKey
startAt
value
}
}
Variables
{
"args": currentStatesByMachine_args,
"distinct_on": ["latestEventAt"],
"limit": 987,
"offset": 987,
"order_by": [CurrentStateRT_order_by],
"where": CurrentStateRT_bool_exp
}
Response
{
"data": {
"currentStatesByMachine": [
{
"latestEventAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "abc123",
"startAt": "2022-05-07T01:08:03.420Z",
"value": "abc123"
}
]
}
}
cycleTimeStats
Response
Returns [CycleTimeStatsRT!]!
Arguments
Name | Description |
---|---|
args - cycleTimeStats_args
|
A set of arguments passed to the function. |
distinct_on - [CycleTimeStatsRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [CycleTimeStatsRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - CycleTimeStatsRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query CycleTimeStats(
$args: cycleTimeStats_args,
$distinct_on: [CycleTimeStatsRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [CycleTimeStatsRT_order_by!],
$where: CycleTimeStatsRT_bool_exp
) {
cycleTimeStats(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
machine {
...MachineTPFragment
}
machineRef
medianCycleTime
operation {
...OperationFragment
}
operationId
partCount
}
}
Variables
{
"args": cycleTimeStats_args,
"distinct_on": ["machineRef"],
"limit": 123,
"offset": 987,
"order_by": [CycleTimeStatsRT_order_by],
"where": CycleTimeStatsRT_bool_exp
}
Response
{
"data": {
"cycleTimeStats": [
{
"machine": MachineTP,
"machineRef": 987,
"medianCycleTime": numeric,
"operation": Operation,
"operationId": "abc123",
"partCount": 987
}
]
}
}
erpLaborTicket
Response
Returns an erpLaborTickets
Arguments
Name | Description |
---|---|
laborTicketRef - bigint!
|
A unique, numeric identifier for the laborTicket. |
Example
Query
query ErpLaborTicket($laborTicketRef: bigint!) {
erpLaborTicket(laborTicketRef: $laborTicketRef) {
badParts
clockIn
clockOut
comment
createdAt
goodParts
laborTicketId
laborTicketRef
lot
person {
...erpPersonsFragment
}
personId
reasons {
...erpLaborTicketsReasonsFragment
}
resource {
...erpResourcesFragment
}
resourceId
sequenceNumber
split
state
sub
syncedAt
transactionDate
type
updatedAt
workOrderId
workOrderOperation {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{"laborTicketRef": 982312}
Response
{
"data": {
"erpLaborTicket": {
"badParts": 123.45,
"clockIn": "2022-05-07T01:08:03.420Z",
"clockOut": "2022-05-07T01:08:03.420Z",
"comment": "abc123",
"createdAt": "2022-05-07T01:08:03.420Z",
"goodParts": 123.45,
"laborTicketId": "abc123",
"laborTicketRef": 982312,
"lot": "abc123",
"person": erpPersons,
"personId": "abc123",
"reasons": [erpLaborTicketsReasons],
"resource": erpResources,
"resourceId": "xyz789",
"sequenceNumber": 123.45,
"split": "xyz789",
"state": "xyz789",
"sub": "xyz789",
"syncedAt": "2022-05-07T01:08:03.420Z",
"transactionDate": "2022-05-07T01:08:03.420Z",
"type": "abc123",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrderId": "abc123",
"workOrderOperation": erpWorkOrderOperations
}
}
}
erpLaborTickets
Response
Returns [erpLaborTickets!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpLaborTickets_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpLaborTickets_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpLaborTickets_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpLaborTickets(
$distinct_on: [erpLaborTickets_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpLaborTickets_order_by!],
$where: erpLaborTickets_bool_exp
) {
erpLaborTickets(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
badParts
clockIn
clockOut
comment
createdAt
goodParts
laborTicketId
laborTicketRef
lot
person {
...erpPersonsFragment
}
personId
reasons {
...erpLaborTicketsReasonsFragment
}
resource {
...erpResourcesFragment
}
resourceId
sequenceNumber
split
state
sub
syncedAt
transactionDate
type
updatedAt
workOrderId
workOrderOperation {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{
"distinct_on": ["badParts"],
"limit": 123,
"offset": 123,
"order_by": [erpLaborTickets_order_by],
"where": erpLaborTickets_bool_exp
}
Response
{
"data": {
"erpLaborTickets": [
{
"badParts": 123.45,
"clockIn": "2022-05-07T01:08:03.420Z",
"clockOut": "2022-05-07T01:08:03.420Z",
"comment": "xyz789",
"createdAt": "2022-05-07T01:08:03.420Z",
"goodParts": 987.65,
"laborTicketId": "xyz789",
"laborTicketRef": 982312,
"lot": "abc123",
"person": erpPersons,
"personId": "abc123",
"reasons": [erpLaborTicketsReasons],
"resource": erpResources,
"resourceId": "xyz789",
"sequenceNumber": 987.65,
"split": "abc123",
"state": "abc123",
"sub": "abc123",
"syncedAt": "2022-05-07T01:08:03.420Z",
"transactionDate": "2022-05-07T01:08:03.420Z",
"type": "abc123",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrderId": "abc123",
"workOrderOperation": erpWorkOrderOperations
}
]
}
}
erpLaborTicketsReason
Response
Returns an erpLaborTicketsReasons
Example
Query
query ErpLaborTicketsReason(
$laborTicketRef: bigint!,
$reasonRef: bigint!
) {
erpLaborTicketsReason(
laborTicketRef: $laborTicketRef,
reasonRef: $reasonRef
) {
companyId
laborTicket {
...erpLaborTicketsFragment
}
laborTicketRef
reason {
...erpReasonFragment
}
reasonRef
}
}
Variables
{"laborTicketRef": 982312, "reasonRef": 982312}
Response
{
"data": {
"erpLaborTicketsReason": {
"companyId": "abc123",
"laborTicket": erpLaborTickets,
"laborTicketRef": 982312,
"reason": erpReason,
"reasonRef": 982312
}
}
}
erpLaborTicketsReasons
Response
Returns [erpLaborTicketsReasons!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpLaborTicketsReasons_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpLaborTicketsReasons_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpLaborTicketsReasons_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpLaborTicketsReasons(
$distinct_on: [erpLaborTicketsReasons_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpLaborTicketsReasons_order_by!],
$where: erpLaborTicketsReasons_bool_exp
) {
erpLaborTicketsReasons(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
companyId
laborTicket {
...erpLaborTicketsFragment
}
laborTicketRef
reason {
...erpReasonFragment
}
reasonRef
}
}
Variables
{
"distinct_on": ["companyId"],
"limit": 123,
"offset": 987,
"order_by": [erpLaborTicketsReasons_order_by],
"where": erpLaborTicketsReasons_bool_exp
}
Response
{
"data": {
"erpLaborTicketsReasons": [
{
"companyId": "xyz789",
"laborTicket": erpLaborTickets,
"laborTicketRef": 982312,
"reason": erpReason,
"reasonRef": 982312
}
]
}
}
erpPartOperation
Description
Production standards are applied from the Operation selected when starting the first Activity in an Activity Set. This snapshot will not change when standards in the Job Template are updated so an accurate history of the standards as they existed in the moment the work was performed is maintained.
Response
Returns an erpPartOperations
Example
Query
query ErpPartOperation(
$companyId: String!,
$method: String!,
$partNumber: String!,
$partRevision: String!,
$sequenceNumber: Float!
) {
erpPartOperation(
companyId: $companyId,
method: $method,
partNumber: $partNumber,
partRevision: $partRevision,
sequenceNumber: $sequenceNumber
) {
companyId
createdAt
cycleTimeMs
description
method
part {
...erpPartsFragment
}
partName
partNumber
partOperationRef
partRevision
quantityPerPart
resource {
...erpResourcesFragment
}
resourceId
sequenceNumber
setupTimeMs
updatedAt
}
}
Variables
{
"companyId": "xyz789",
"method": "abc123",
"partNumber": "xyz789",
"partRevision": "abc123",
"sequenceNumber": 123.45
}
Response
{
"data": {
"erpPartOperation": {
"companyId": "xyz789",
"createdAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 123.45,
"description": "abc123",
"method": "xyz789",
"part": erpParts,
"partName": "abc123",
"partNumber": "xyz789",
"partOperationRef": 982312,
"partRevision": "xyz789",
"quantityPerPart": 123.45,
"resource": erpResources,
"resourceId": "xyz789",
"sequenceNumber": 123.45,
"setupTimeMs": 123.45,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
}
}
erpPartOperations
Response
Returns [erpPartOperations!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpPartOperations_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpPartOperations_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpPartOperations_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpPartOperations(
$distinct_on: [erpPartOperations_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpPartOperations_order_by!],
$where: erpPartOperations_bool_exp
) {
erpPartOperations(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
companyId
createdAt
cycleTimeMs
description
method
part {
...erpPartsFragment
}
partName
partNumber
partOperationRef
partRevision
quantityPerPart
resource {
...erpResourcesFragment
}
resourceId
sequenceNumber
setupTimeMs
updatedAt
}
}
Variables
{
"distinct_on": ["companyId"],
"limit": 987,
"offset": 123,
"order_by": [erpPartOperations_order_by],
"where": erpPartOperations_bool_exp
}
Response
{
"data": {
"erpPartOperations": [
{
"companyId": "abc123",
"createdAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 123.45,
"description": "xyz789",
"method": "xyz789",
"part": erpParts,
"partName": "abc123",
"partNumber": "abc123",
"partOperationRef": 982312,
"partRevision": "abc123",
"quantityPerPart": 987.65,
"resource": erpResources,
"resourceId": "abc123",
"sequenceNumber": 987.65,
"setupTimeMs": 987.65,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
erpParts
Response
Returns [erpParts!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpParts_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpParts_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpParts_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpParts(
$distinct_on: [erpParts_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpParts_order_by!],
$where: erpParts_bool_exp
) {
erpParts(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
createdAt
method
partNumber
partOperations {
...erpPartOperationsFragment
}
partRevision
updatedAt
workOrders {
...erpWorkOrderFragment
}
}
}
Variables
{
"distinct_on": ["createdAt"],
"limit": 987,
"offset": 123,
"order_by": [erpParts_order_by],
"where": erpParts_bool_exp
}
Response
{
"data": {
"erpParts": [
{
"createdAt": "2022-05-07T01:08:03.420Z",
"method": "xyz789",
"partNumber": "abc123",
"partOperations": [erpPartOperations],
"partRevision": "xyz789",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrders": [erpWorkOrder]
}
]
}
}
erpPersons
Response
Returns [erpPersons!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpPersons_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpPersons_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpPersons_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpPersons(
$distinct_on: [erpPersons_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpPersons_order_by!],
$where: erpPersons_bool_exp
) {
erpPersons(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
createdAt
firstName
isActive
laborTickets {
...erpLaborTicketsFragment
}
lastName
personId
updatedAt
}
}
Variables
{
"distinct_on": ["createdAt"],
"limit": 987,
"offset": 123,
"order_by": [erpPersons_order_by],
"where": erpPersons_bool_exp
}
Response
{
"data": {
"erpPersons": [
{
"createdAt": "2022-05-07T01:08:03.420Z",
"firstName": "abc123",
"isActive": true,
"laborTickets": [erpLaborTickets],
"lastName": "xyz789",
"personId": "xyz789",
"updatedAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
erpReason
Response
Returns an erpReason
Arguments
Name | Description |
---|---|
reasonRef - bigint!
|
A unique, numeric identifier for the reason. |
Example
Query
query ErpReason($reasonRef: bigint!) {
erpReason(reasonRef: $reasonRef) {
annotationType {
...AnnotationTypeTPFragment
}
annotationTypeRef
category
code
companyId
createdAt
description
entityType
laborTickets {
...erpLaborTicketsReasonsFragment
}
reasonId
reasonRef
rejectReason {
...RejectReasonFragment
}
rejectReasonRef
updatedAt
}
}
Variables
{"reasonRef": 982312}
Response
{
"data": {
"erpReason": {
"annotationType": AnnotationTypeTP,
"annotationTypeRef": 987,
"category": "abc123",
"code": "xyz789",
"companyId": "xyz789",
"createdAt": "2022-05-07T01:08:03.420Z",
"description": "abc123",
"entityType": "abc123",
"laborTickets": [erpLaborTicketsReasons],
"reasonId": "abc123",
"reasonRef": 982312,
"rejectReason": RejectReason,
"rejectReasonRef": 987,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
}
}
erpReasons
Response
Returns [erpReason!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpReason_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpReason_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpReason_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpReasons(
$distinct_on: [erpReason_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpReason_order_by!],
$where: erpReason_bool_exp
) {
erpReasons(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
annotationType {
...AnnotationTypeTPFragment
}
annotationTypeRef
category
code
companyId
createdAt
description
entityType
laborTickets {
...erpLaborTicketsReasonsFragment
}
reasonId
reasonRef
rejectReason {
...RejectReasonFragment
}
rejectReasonRef
updatedAt
}
}
Variables
{
"distinct_on": ["annotationTypeRef"],
"limit": 123,
"offset": 987,
"order_by": [erpReason_order_by],
"where": erpReason_bool_exp
}
Response
{
"data": {
"erpReasons": [
{
"annotationType": AnnotationTypeTP,
"annotationTypeRef": 123,
"category": "abc123",
"code": "xyz789",
"companyId": "abc123",
"createdAt": "2022-05-07T01:08:03.420Z",
"description": "xyz789",
"entityType": "abc123",
"laborTickets": [erpLaborTicketsReasons],
"reasonId": "abc123",
"reasonRef": 982312,
"rejectReason": RejectReason,
"rejectReasonRef": 123,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
erpResourceGroupMembersip
Response
Returns an erpResourceGroupMembersips
Arguments
Name | Description |
---|---|
hasMemberCompanyId - String!
|
A globally unique identifier (UUID) for the hasMemberCompany. |
hasMemberResourceId - String!
|
A globally unique identifier (UUID) for the hasMemberResource. |
memberOfCompanyId - String!
|
A globally unique identifier (UUID) for the memberOfCompany. |
memberOfResourceId - String!
|
A globally unique identifier (UUID) for the memberOfResource. |
Example
Query
query ErpResourceGroupMembersip(
$hasMemberCompanyId: String!,
$hasMemberResourceId: String!,
$memberOfCompanyId: String!,
$memberOfResourceId: String!
) {
erpResourceGroupMembersip(
hasMemberCompanyId: $hasMemberCompanyId,
hasMemberResourceId: $hasMemberResourceId,
memberOfCompanyId: $memberOfCompanyId,
memberOfResourceId: $memberOfResourceId
) {
createdAt
hasMemberCompanyId
hasMemberResourceId
memberOfCompanyId
memberOfResourceId
resourceGroup {
...erpResourcesFragment
}
resourceGroupMember {
...erpResourcesFragment
}
updatedAt
}
}
Variables
{
"hasMemberCompanyId": "abc123",
"hasMemberResourceId": "xyz789",
"memberOfCompanyId": "abc123",
"memberOfResourceId": "abc123"
}
Response
{
"data": {
"erpResourceGroupMembersip": {
"createdAt": "2022-05-07T01:08:03.420Z",
"hasMemberCompanyId": "xyz789",
"hasMemberResourceId": "xyz789",
"memberOfCompanyId": "xyz789",
"memberOfResourceId": "abc123",
"resourceGroup": erpResources,
"resourceGroupMember": erpResources,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
}
}
erpResourceGroupMembersips
Response
Returns [erpResourceGroupMembersips!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpResourceGroupMembersips_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpResourceGroupMembersips_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpResourceGroupMembersips_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpResourceGroupMembersips(
$distinct_on: [erpResourceGroupMembersips_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpResourceGroupMembersips_order_by!],
$where: erpResourceGroupMembersips_bool_exp
) {
erpResourceGroupMembersips(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
createdAt
hasMemberCompanyId
hasMemberResourceId
memberOfCompanyId
memberOfResourceId
resourceGroup {
...erpResourcesFragment
}
resourceGroupMember {
...erpResourcesFragment
}
updatedAt
}
}
Variables
{
"distinct_on": ["createdAt"],
"limit": 123,
"offset": 987,
"order_by": [erpResourceGroupMembersips_order_by],
"where": erpResourceGroupMembersips_bool_exp
}
Response
{
"data": {
"erpResourceGroupMembersips": [
{
"createdAt": "2022-05-07T01:08:03.420Z",
"hasMemberCompanyId": "xyz789",
"hasMemberResourceId": "xyz789",
"memberOfCompanyId": "abc123",
"memberOfResourceId": "xyz789",
"resourceGroup": erpResources,
"resourceGroupMember": erpResources,
"updatedAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
erpResources
Response
Returns [erpResources!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpResources_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpResources_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpResources_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpResources(
$distinct_on: [erpResources_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpResources_order_by!],
$where: erpResources_bool_exp
) {
erpResources(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
createdAt
description
isResourceGroup
laborTickets {
...erpLaborTicketsFragment
}
machineGroupId
machineRef
name
partOperations {
...erpPartOperationsFragment
}
productionBurdenRateHourly
resourceGroupMembers {
...erpResourceGroupMembersipsFragment
}
resourceGroups {
...erpResourceGroupMembersipsFragment
}
resourceId
setupBurdenRateHourly
type
updatedAt
workOrderOperations {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{
"distinct_on": ["createdAt"],
"limit": 987,
"offset": 123,
"order_by": [erpResources_order_by],
"where": erpResources_bool_exp
}
Response
{
"data": {
"erpResources": [
{
"createdAt": "2022-05-07T01:08:03.420Z",
"description": "xyz789",
"isResourceGroup": true,
"laborTickets": [erpLaborTickets],
"machineGroupId": "xyz789",
"machineRef": 987,
"name": "xyz789",
"partOperations": [erpPartOperations],
"productionBurdenRateHourly": 123.45,
"resourceGroupMembers": [
erpResourceGroupMembersips
],
"resourceGroups": [erpResourceGroupMembersips],
"resourceId": "abc123",
"setupBurdenRateHourly": 123.45,
"type": "xyz789",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrderOperations": [erpWorkOrderOperations]
}
]
}
}
erpWorkOrder
Response
Returns an erpWorkOrder
Example
Query
query ErpWorkOrder(
$companyId: String!,
$lot: String!,
$split: String!,
$sub: String!,
$workOrderId: String!
) {
erpWorkOrder(
companyId: $companyId,
lot: $lot,
split: $split,
sub: $sub,
workOrderId: $workOrderId
) {
closedDate
companyId
createdAt
description
dueDate
lot
method
part {
...erpPartsFragment
}
partNumber
partRevision
quantityRequired
scheduledEndDate
scheduledStartDate
split
status
sub
updatedAt
workOrderId
workOrderOperations {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{
"companyId": "xyz789",
"lot": "xyz789",
"split": "xyz789",
"sub": "xyz789",
"workOrderId": "xyz789"
}
Response
{
"data": {
"erpWorkOrder": {
"closedDate": "2022-05-07T01:08:03.420Z",
"companyId": "abc123",
"createdAt": "2022-05-07T01:08:03.420Z",
"description": "abc123",
"dueDate": "2022-05-07T01:08:03.420Z",
"lot": "abc123",
"method": "abc123",
"part": erpParts,
"partNumber": "abc123",
"partRevision": "xyz789",
"quantityRequired": 123.45,
"scheduledEndDate": "2022-05-07T01:08:03.420Z",
"scheduledStartDate": "2022-05-07T01:08:03.420Z",
"split": "abc123",
"status": "xyz789",
"sub": "xyz789",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrderId": "abc123",
"workOrderOperations": [erpWorkOrderOperations]
}
}
}
erpWorkOrderOperation
Description
Production standards are applied from the Operation selected when starting the first Activity in an Activity Set. This snapshot will not change when standards in the Job Template are updated so an accurate history of the standards as they existed in the moment the work was performed is maintained.
Response
Returns an erpWorkOrderOperations
Arguments
Name | Description |
---|---|
workOrderOperationRef - bigint!
|
A unique, numeric identifier for the workOrderOperation. |
Example
Query
query ErpWorkOrderOperation($workOrderOperationRef: bigint!) {
erpWorkOrderOperation(workOrderOperationRef: $workOrderOperationRef) {
activitySet {
...ActivitySetFragment
}
closedDate
companyId
createdAt
cycleTimeMs
expectedRejectRate
finishQuantity
laborTickets {
...erpLaborTicketsFragment
}
lot
matchingPartOperations {
...erpPartOperationsFragment
}
operationType
productionburdenRateHourly
quantityPerPart
resource {
...erpResourcesFragment
}
resourceId
scheduledFinishDate
scheduledStartDate
sequenceNumber
setupTimeMs
setupburdenRatehourly
split
startQuantity
status
sub
updatedAt
workOrder {
...erpWorkOrderFragment
}
workOrderId
workOrderOperationRef
}
}
Variables
{"workOrderOperationRef": 982312}
Response
{
"data": {
"erpWorkOrderOperation": {
"activitySet": ActivitySet,
"closedDate": "2022-05-07T01:08:03.420Z",
"companyId": "xyz789",
"createdAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 982312,
"expectedRejectRate": 123.45,
"finishQuantity": 123.45,
"laborTickets": [erpLaborTickets],
"lot": "xyz789",
"matchingPartOperations": [erpPartOperations],
"operationType": "xyz789",
"productionburdenRateHourly": 987.65,
"quantityPerPart": 982312,
"resource": erpResources,
"resourceId": "abc123",
"scheduledFinishDate": "2022-05-07T01:08:03.420Z",
"scheduledStartDate": "2022-05-07T01:08:03.420Z",
"sequenceNumber": 987.65,
"setupTimeMs": 982312,
"setupburdenRatehourly": 123.45,
"split": "xyz789",
"startQuantity": 987.65,
"status": "abc123",
"sub": "abc123",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrder": erpWorkOrder,
"workOrderId": "xyz789",
"workOrderOperationRef": 982312
}
}
}
erpWorkOrderOperations
Response
Returns [erpWorkOrderOperations!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpWorkOrderOperations_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpWorkOrderOperations_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpWorkOrderOperations_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpWorkOrderOperations(
$distinct_on: [erpWorkOrderOperations_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpWorkOrderOperations_order_by!],
$where: erpWorkOrderOperations_bool_exp
) {
erpWorkOrderOperations(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activitySet {
...ActivitySetFragment
}
closedDate
companyId
createdAt
cycleTimeMs
expectedRejectRate
finishQuantity
laborTickets {
...erpLaborTicketsFragment
}
lot
matchingPartOperations {
...erpPartOperationsFragment
}
operationType
productionburdenRateHourly
quantityPerPart
resource {
...erpResourcesFragment
}
resourceId
scheduledFinishDate
scheduledStartDate
sequenceNumber
setupTimeMs
setupburdenRatehourly
split
startQuantity
status
sub
updatedAt
workOrder {
...erpWorkOrderFragment
}
workOrderId
workOrderOperationRef
}
}
Variables
{
"distinct_on": ["closedDate"],
"limit": 123,
"offset": 987,
"order_by": [erpWorkOrderOperations_order_by],
"where": erpWorkOrderOperations_bool_exp
}
Response
{
"data": {
"erpWorkOrderOperations": [
{
"activitySet": ActivitySet,
"closedDate": "2022-05-07T01:08:03.420Z",
"companyId": "abc123",
"createdAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 982312,
"expectedRejectRate": 123.45,
"finishQuantity": 123.45,
"laborTickets": [erpLaborTickets],
"lot": "xyz789",
"matchingPartOperations": [erpPartOperations],
"operationType": "xyz789",
"productionburdenRateHourly": 123.45,
"quantityPerPart": 982312,
"resource": erpResources,
"resourceId": "abc123",
"scheduledFinishDate": "2022-05-07T01:08:03.420Z",
"scheduledStartDate": "2022-05-07T01:08:03.420Z",
"sequenceNumber": 123.45,
"setupTimeMs": 982312,
"setupburdenRatehourly": 987.65,
"split": "xyz789",
"startQuantity": 123.45,
"status": "abc123",
"sub": "xyz789",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrder": erpWorkOrder,
"workOrderId": "xyz789",
"workOrderOperationRef": 982312
}
]
}
}
erpWorkOrders
Response
Returns [erpWorkOrder!]!
Arguments
Name | Description |
---|---|
distinct_on - [erpWorkOrder_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [erpWorkOrder_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - erpWorkOrder_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query ErpWorkOrders(
$distinct_on: [erpWorkOrder_select_column!],
$limit: Int,
$offset: Int,
$order_by: [erpWorkOrder_order_by!],
$where: erpWorkOrder_bool_exp
) {
erpWorkOrders(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
closedDate
companyId
createdAt
description
dueDate
lot
method
part {
...erpPartsFragment
}
partNumber
partRevision
quantityRequired
scheduledEndDate
scheduledStartDate
split
status
sub
updatedAt
workOrderId
workOrderOperations {
...erpWorkOrderOperationsFragment
}
}
}
Variables
{
"distinct_on": ["closedDate"],
"limit": 987,
"offset": 987,
"order_by": [erpWorkOrder_order_by],
"where": erpWorkOrder_bool_exp
}
Response
{
"data": {
"erpWorkOrders": [
{
"closedDate": "2022-05-07T01:08:03.420Z",
"companyId": "xyz789",
"createdAt": "2022-05-07T01:08:03.420Z",
"description": "xyz789",
"dueDate": "2022-05-07T01:08:03.420Z",
"lot": "xyz789",
"method": "abc123",
"part": erpParts,
"partNumber": "xyz789",
"partRevision": "abc123",
"quantityRequired": 987.65,
"scheduledEndDate": "2022-05-07T01:08:03.420Z",
"scheduledStartDate": "2022-05-07T01:08:03.420Z",
"split": "xyz789",
"status": "abc123",
"sub": "abc123",
"updatedAt": "2022-05-07T01:08:03.420Z",
"workOrderId": "abc123",
"workOrderOperations": [erpWorkOrderOperations]
}
]
}
}
events
Response
Returns [Event!]!
Arguments
Name | Description |
---|---|
distinct_on - [Event_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [Event_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - Event_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Events(
$distinct_on: [Event_select_column!],
$limit: Int,
$offset: Int,
$order_by: [Event_order_by!],
$where: Event_bool_exp
) {
events(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
eventTime
machineRef
metricKey
sequence
value
}
}
Variables
{
"distinct_on": ["eventTime"],
"limit": 123,
"offset": 123,
"order_by": [Event_order_by],
"where": Event_bool_exp
}
Response
{
"data": {
"events": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machineRef": 123,
"metricKey": "xyz789",
"sequence": 123,
"value": jsonb
}
]
}
}
latestPositionsByMachine
Response
Returns [LatestPositionRT!]!
Arguments
Name | Description |
---|---|
args - latestPositionsByMachine_args
|
A set of arguments passed to the function. |
distinct_on - [LatestPositionRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [LatestPositionRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - LatestPositionRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query LatestPositionsByMachine(
$args: latestPositionsByMachine_args,
$distinct_on: [LatestPositionRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [LatestPositionRT_order_by!],
$where: LatestPositionRT_bool_exp
) {
latestPositionsByMachine(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
eventTime
machine {
...MachineTPFragment
}
machineRef
metricKey
x
y
z
}
}
Variables
{
"args": latestPositionsByMachine_args,
"distinct_on": ["eventTime"],
"limit": 123,
"offset": 123,
"order_by": [LatestPositionRT_order_by],
"where": LatestPositionRT_bool_exp
}
Response
{
"data": {
"latestPositionsByMachine": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "xyz789",
"x": 43.12,
"y": 43.12,
"z": 43.12
}
]
}
}
latestQuantitiesByMachine
Response
Returns [LatestQuantityRT!]!
Arguments
Name | Description |
---|---|
args - latestQuantitiesByMachine_args
|
A set of arguments passed to the function. |
distinct_on - [LatestQuantityRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
where - LatestQuantityRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query LatestQuantitiesByMachine(
$args: latestQuantitiesByMachine_args,
$distinct_on: [LatestQuantityRT_select_column!],
$limit: Int,
$offset: Int,
$where: LatestQuantityRT_bool_exp
) {
latestQuantitiesByMachine(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
where: $where
) {
eventTime
machine {
...MachineTPFragment
}
machineRef
metricKey
sequence
value
}
}
Variables
{
"args": latestQuantitiesByMachine_args,
"distinct_on": ["eventTime"],
"limit": 987,
"offset": 987,
"where": LatestQuantityRT_bool_exp
}
Response
{
"data": {
"latestQuantitiesByMachine": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "xyz789",
"sequence": 123,
"value": 43.12
}
]
}
}
location
Response
Returns a Location
Arguments
Name | Description |
---|---|
locationRef - Int!
|
A unique, numeric identifier for the location. |
Example
Query
query Location($locationRef: Int!) {
location(locationRef: $locationRef) {
company {
...CompanyTPFragment
}
companyId
locationRef
}
}
Variables
{"locationRef": 123}
Response
{
"data": {
"location": {
"company": {"name": "Cyberdyne"},
"companyId": "xyz789",
"locationRef": 123
}
}
}
locations
Response
Returns [Location!]!
Arguments
Name | Description |
---|---|
distinct_on - [Location_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [Location_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - Location_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Locations(
$distinct_on: [Location_select_column!],
$limit: Int,
$offset: Int,
$order_by: [Location_order_by!],
$where: Location_bool_exp
) {
locations(
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
company {
...CompanyTPFragment
}
companyId
locationRef
}
}
Variables
{
"distinct_on": ["companyId"],
"limit": 123,
"offset": 123,
"order_by": [Location_order_by],
"where": Location_bool_exp
}
Response
{
"data": {
"locations": [
{
"company": {"name": "Cyberdyne"},
"companyId": "abc123",
"locationRef": 123
}
]
}
}
machines
Response
Returns [MachineTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [MachineTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - MachineTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Machines(
$limit: Int,
$offset: Int,
$order_by: [MachineTP_order_by!],
$where: MachineTP_bool_exp
) {
machines(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activitySets {
...ActivitySetFragment
}
annotations {
...AnnotationTPFragment
}
company {
...CompanyTPFragment
}
companyId
currentAlarms {
...CurrentAlarmRTFragment
}
currentStates {
...CurrentStateRTFragment
}
decommissionedAt
erpResources {
...erpResourcesFragment
}
latestPositions {
...LatestPositionRTFragment
}
latestQuantities {
...LatestQuantityRTFragment
}
machineId
machineRef
make
metrics {
...MetricTPFragment
}
model
name
operatorRuns {
...OperatorRunTPFragment
}
partCountCorrections {
...PartCountCorrectionFragment
}
partCountMetricKey
rejects {
...RejectFragment
}
}
}
Variables
{
"limit": 123,
"offset": 123,
"order_by": [MachineTP_order_by],
"where": MachineTP_bool_exp
}
Response
{
"data": {
"machines": [
{
"activitySets": [ActivitySet],
"annotations": [AnnotationTP],
"company": {
"companyId": "01c08a38-f33d-4348-9918-e6957cab5c27",
"name": "Cyberdyne"
},
"companyId": "xyz789",
"currentAlarms": [CurrentAlarmRT],
"currentStates": [CurrentStateRT],
"decommissionedAt": "2022-05-07T01:08:03.420Z",
"erpResources": [erpResources],
"latestPositions": [LatestPositionRT],
"latestQuantities": [LatestQuantityRT],
"machineId": "xyz789",
"machineRef": 987,
"make": "Citizen",
"metrics": [MetricTP],
"model": "K16E",
"name": "Citizen B12",
"operatorRuns": [OperatorRunTP],
"partCountCorrections": [PartCountCorrection],
"partCountMetricKey": "abc123",
"rejects": [Reject]
}
]
}
}
metric
Response
Returns a MetricTP
Example
Query
query Metric(
$machineRef: Int!,
$metricKey: String!
) {
metric(
machineRef: $machineRef,
metricKey: $metricKey
) {
machineRef
metricKey
subtype
type
}
}
Variables
{"machineRef": 123, "metricKey": "xyz789"}
Response
{
"data": {
"metric": {
"machineRef": 987,
"metricKey": "xyz789",
"subtype": "xyz789",
"type": "xyz789"
}
}
}
metrics
Response
Returns [MetricTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [MetricTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - MetricTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Metrics(
$limit: Int,
$offset: Int,
$order_by: [MetricTP_order_by!],
$where: MetricTP_bool_exp
) {
metrics(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
machineRef
metricKey
subtype
type
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [MetricTP_order_by],
"where": MetricTP_bool_exp
}
Response
{
"data": {
"metrics": [
{
"machineRef": 123,
"metricKey": "xyz789",
"subtype": "abc123",
"type": "xyz789"
}
]
}
}
operations
Response
Returns [Operation!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [Operation_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - Operation_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Operations(
$limit: Int,
$offset: Int,
$order_by: [Operation_order_by!],
$where: Operation_bool_exp
) {
operations(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
activitySets {
...ActivitySetFragment
}
company {
...CompanyTPFragment
}
description
name
operationId
partNumber
sequenceNumber
}
}
Variables
{
"limit": 123,
"offset": 123,
"order_by": [Operation_order_by],
"where": Operation_bool_exp
}
Response
{
"data": {
"operations": [
{
"activitySets": [ActivitySet],
"company": {"name": "Cyberdyne"},
"description": "abc123",
"name": "abc123",
"operationId": "abc123",
"partNumber": "xyz789",
"sequenceNumber": "xyz789"
}
]
}
}
operatorRuns
Response
Returns [OperatorRunTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [OperatorRunTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - OperatorRunTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query OperatorRuns(
$limit: Int,
$offset: Int,
$order_by: [OperatorRunTP_order_by!],
$where: OperatorRunTP_bool_exp
) {
operatorRuns(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
endAt
machine {
...MachineTPFragment
}
operator {
...OperatorTPFragment
}
operatorRunRef
startAt
}
}
Variables
{
"limit": 123,
"offset": 987,
"order_by": [OperatorRunTP_order_by],
"where": OperatorRunTP_bool_exp
}
Response
{
"data": {
"operatorRuns": [
{
"endAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"operator": OperatorTP,
"operatorRunRef": 123,
"startAt": "2022-05-07T01:08:03.420Z"
}
]
}
}
operators
Description
Returns a collection of Operators
Response
Returns [OperatorTP!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [OperatorTP_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - OperatorTP_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Operators(
$limit: Int,
$offset: Int,
$order_by: [OperatorTP_order_by!],
$where: OperatorTP_bool_exp
) {
operators(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
company {
...CompanyTPFragment
}
isArchived
name
operatorRef
operatorRuns {
...OperatorRunTPFragment
}
}
}
Variables
{
"limit": 987,
"offset": 987,
"order_by": [OperatorTP_order_by],
"where": OperatorTP_bool_exp
}
Response
{
"data": {
"operators": [
{
"company": {"name": "Cyberdyne"},
"isArchived": false,
"name": "abc123",
"operatorRef": 987,
"operatorRuns": [OperatorRunTP]
}
]
}
}
partCountCorrections
Response
Returns [PartCountCorrection!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [PartCountCorrection_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - PartCountCorrection_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query PartCountCorrections(
$limit: Int,
$offset: Int,
$order_by: [PartCountCorrection_order_by!],
$where: PartCountCorrection_bool_exp
) {
partCountCorrections(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
effectiveAt
machine {
...MachineTPFragment
}
value
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [PartCountCorrection_order_by],
"where": PartCountCorrection_bool_exp
}
Response
{
"data": {
"partCountCorrections": [
{
"effectiveAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"value": 123
}
]
}
}
partCounts
Response
Returns [PartCountRT!]!
Arguments
Name | Description |
---|---|
args - partCounts_args!
|
A set of arguments passed to the function. |
distinct_on - [PartCountRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [PartCountRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - PartCountRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query PartCounts(
$args: partCounts_args!,
$distinct_on: [PartCountRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [PartCountRT_order_by!],
$where: PartCountRT_bool_exp
) {
partCounts(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
eventTime
machine {
...MachineTPFragment
}
machineRef
metricKey
sequence
value
}
}
Variables
{
"args": partCounts_args,
"distinct_on": ["eventTime"],
"limit": 987,
"offset": 123,
"order_by": [PartCountRT_order_by],
"where": PartCountRT_bool_exp
}
Response
{
"data": {
"partCounts": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "abc123",
"sequence": 987,
"value": 987
}
]
}
}
positions
Response
Returns [PositionRT!]!
Arguments
Name | Description |
---|---|
args - positions_args!
|
A set of arguments passed to the function. |
distinct_on - [PositionRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [PositionRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - PositionRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Positions(
$args: positions_args!,
$distinct_on: [PositionRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [PositionRT_order_by!],
$where: PositionRT_bool_exp
) {
positions(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
eventTime
machine {
...MachineTPFragment
}
machineRef
metricKey
x
y
z
}
}
Variables
{
"args": positions_args,
"distinct_on": ["eventTime"],
"limit": 123,
"offset": 123,
"order_by": [PositionRT_order_by],
"where": PositionRT_bool_exp
}
Response
{
"data": {
"positions": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "abc123",
"x": 43.12,
"y": 43.12,
"z": 43.12
}
]
}
}
quantities
Response
Returns [QuantityRT!]!
Arguments
Name | Description |
---|---|
args - quantities_args!
|
A set of arguments passed to the function. |
distinct_on - [QuantityRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [QuantityRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - QuantityRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Quantities(
$args: quantities_args!,
$distinct_on: [QuantityRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [QuantityRT_order_by!],
$where: QuantityRT_bool_exp
) {
quantities(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
eventTime
machine {
...MachineTPFragment
}
machineRef
metricKey
sequence
value
}
}
Variables
{
"args": quantities_args,
"distinct_on": ["eventTime"],
"limit": 123,
"offset": 987,
"order_by": [QuantityRT_order_by],
"where": QuantityRT_bool_exp
}
Response
{
"data": {
"quantities": [
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "xyz789",
"sequence": 987,
"value": 43.12
}
]
}
}
rejectReasons
Response
Returns [RejectReason!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [RejectReason_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - RejectReason_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query RejectReasons(
$limit: Int,
$offset: Int,
$order_by: [RejectReason_order_by!],
$where: RejectReason_bool_exp
) {
rejectReasons(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
color
company {
...CompanyTPFragment
}
erpReason {
...erpReasonFragment
}
isArchived
name
rejectReasonRef
rejects {
...RejectFragment
}
}
}
Variables
{
"limit": 123,
"offset": 123,
"order_by": [RejectReason_order_by],
"where": RejectReason_bool_exp
}
Response
{
"data": {
"rejectReasons": [
{
"color": "xyz789",
"company": {"name": "Cyberdyne"},
"erpReason": erpReason,
"isArchived": true,
"name": "xyz789",
"rejectReasonRef": 987,
"rejects": [Reject]
}
]
}
}
rejects
Response
Returns [Reject!]!
Arguments
Name | Description |
---|---|
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [Reject_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - Reject_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query Rejects(
$limit: Int,
$offset: Int,
$order_by: [Reject_order_by!],
$where: Reject_bool_exp
) {
rejects(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
machine {
...MachineTPFragment
}
rejectId
rejectReason {
...RejectReasonFragment
}
rejectType
rejectedAt
value
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [Reject_order_by],
"where": Reject_bool_exp
}
Response
{
"data": {
"rejects": [
{
"machine": MachineTP,
"rejectId": "xyz789",
"rejectReason": RejectReason,
"rejectType": "abc123",
"rejectedAt": "2022-05-07T01:08:03.420Z",
"value": 123
}
]
}
}
stateIntervals
Response
Returns [StateIntervalRT!]!
Arguments
Name | Description |
---|---|
args - stateIntervals_args!
|
A set of arguments passed to the function. |
distinct_on - [StateIntervalRT_select_column!]
|
Return a distinct set of entities, defined by the given fields. |
limit - Int
|
Limits the number of objects returned. |
offset - Int
|
Start a the specified, zero-based array index. This is only useful in combination with order_by . |
order_by - [StateIntervalRT_order_by!]
|
Sort the returned array by one or more fields of it's elements. |
where - StateIntervalRT_bool_exp
|
Filter the data by using a (nested) boolean expression. |
Example
Query
query StateIntervals(
$args: stateIntervals_args!,
$distinct_on: [StateIntervalRT_select_column!],
$limit: Int,
$offset: Int,
$order_by: [StateIntervalRT_order_by!],
$where: StateIntervalRT_bool_exp
) {
stateIntervals(
args: $args,
distinct_on: $distinct_on,
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
endAt
machine {
...MachineTPFragment
}
machineRef
metricKey
startAt
value
}
}
Variables
{
"args": stateIntervals_args,
"distinct_on": ["endAt"],
"limit": 123,
"offset": 123,
"order_by": [StateIntervalRT_order_by],
"where": StateIntervalRT_bool_exp
}
Response
{
"data": {
"stateIntervals": [
{
"endAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "abc123",
"startAt": "2022-05-07T01:08:03.420Z",
"value": "xyz789"
}
]
}
}
Types
Activity
Description
Activities are discrete periods of time that specific work is performed on a piece of equipment. They connect a start and end time to specific goals for a machine: the part being produced (optionally including workorder information and other data points) as well as the production and setup standards.
Fields
Field Name | Description |
---|---|
activityRef - bigint
|
A unique, numeric identifier for the activity. |
activitySet - ActivitySet
|
|
activityType - ActivityType
|
|
endAt - timestamptz
|
The end of an interval. Intervals are right-exclusive. |
startAt - timestamptz
|
The start of an interval. |
Example
{
"activityRef": 982312,
"activitySet": ActivitySet,
"activityType": ActivityType,
"endAt": "2022-05-07T01:08:03.420Z",
"startAt": "2022-05-07T01:08:03.420Z"
}
ActivitySet
Description
Each Activity is a distinct span of time, but they can be rolled up into a complete effort using Activity Sets. Activity Sets allow for work to be paused and resumed on a piece of equipment, or a transition from setup to production, while maintaining each Activity as step toward a greater goal. An Activity Set is the data model backing a Production Run.
Fields
Field Name | Description |
---|---|
activePartTimeMs - Int
|
|
activeTimeMs - Int
|
|
activities - [Activity!]!
|
|
Arguments
|
|
activitySetRef - bigint!
|
A unique, numeric identifier for the activitySet. |
actualParts - Float
|
|
closedAt - timestamp
|
|
cycleTimeMs - Int
|
|
expectedSetupTimeMs - Int
|
|
expectedUnitDurationMs - Int
|
|
machine - MachineTP
|
The machine the event originates from. |
operation - Operation
|
|
optimalPartTimeMs - Int
|
|
partCountMultiplier - Float
|
|
partTimeMs - Int
|
|
sampleCycleCount - Int!
|
|
samplePartCount - Int!
|
|
touchPartTimeMs - Int
|
|
touchTimeMs - Int
|
|
workOrderId - String
|
An identifier for the work order. The identifier is usually generated in a third party system (ERP). |
workOrderOperation - erpWorkOrderOperations
|
Production standards are applied from the Operation selected when starting the first Activity in an Activity Set. This snapshot will not change when standards in the Job Template are updated so an accurate history of the standards as they existed in the moment the work was performed is maintained. |
Example
{
"activePartTimeMs": 987,
"activeTimeMs": 987,
"activities": [Activity],
"activitySetRef": 982312,
"actualParts": 987.65,
"closedAt": "2022-05-07T01:08:03.420Z",
"cycleTimeMs": 987,
"expectedSetupTimeMs": 123,
"expectedUnitDurationMs": 123,
"machine": MachineTP,
"operation": Operation,
"optimalPartTimeMs": 987,
"partCountMultiplier": 123.45,
"partTimeMs": 987,
"sampleCycleCount": 123,
"samplePartCount": 123,
"touchPartTimeMs": 123,
"touchTimeMs": 987,
"workOrderId": "abc123",
"workOrderOperation": erpWorkOrderOperations
}
ActivitySet_bool_exp
Description
Boolean expressions to filter ActivitySet. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [ActivitySet_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - ActivitySet_bool_exp
|
Negates the result of the given expression. |
_or - [ActivitySet_bool_exp!]
|
Combines the given expressions using a logical OR. |
activePartTimeMs - Int_comparison_exp
|
|
activeTimeMs - Int_comparison_exp
|
|
activities - Activity_bool_exp
|
|
activitySetRef - bigint_comparison_exp
|
A unique, numeric identifier for the activitySet. |
actualParts - Float_comparison_exp
|
|
closedAt - timestamp_comparison_exp
|
|
cycleTimeMs - Int_comparison_exp
|
|
expectedSetupTimeMs - Int_comparison_exp
|
|
expectedUnitDurationMs - Int_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
operation - Operation_bool_exp
|
|
optimalPartTimeMs - Int_comparison_exp
|
|
partCountMultiplier - Float_comparison_exp
|
|
partTimeMs - Int_comparison_exp
|
|
sampleCycleCount - Int_comparison_exp
|
|
samplePartCount - Int_comparison_exp
|
|
touchPartTimeMs - Int_comparison_exp
|
|
touchTimeMs - Int_comparison_exp
|
|
workOrderId - String_comparison_exp
|
A globally unique identifier (UUID) for the workOrder. |
Example
{
"_and": [ActivitySet_bool_exp],
"_not": ActivitySet_bool_exp,
"_or": [ActivitySet_bool_exp],
"activePartTimeMs": Int_comparison_exp,
"activeTimeMs": Int_comparison_exp,
"activities": Activity_bool_exp,
"activitySetRef": bigint_comparison_exp,
"actualParts": Float_comparison_exp,
"closedAt": timestamp_comparison_exp,
"cycleTimeMs": Int_comparison_exp,
"expectedSetupTimeMs": Int_comparison_exp,
"expectedUnitDurationMs": Int_comparison_exp,
"machine": MachineTP_bool_exp,
"operation": Operation_bool_exp,
"optimalPartTimeMs": Int_comparison_exp,
"partCountMultiplier": Float_comparison_exp,
"partTimeMs": Int_comparison_exp,
"sampleCycleCount": Int_comparison_exp,
"samplePartCount": Int_comparison_exp,
"touchPartTimeMs": Int_comparison_exp,
"touchTimeMs": Int_comparison_exp,
"workOrderId": String_comparison_exp
}
ActivitySet_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
activePartTimeMs - order_by
|
|
activeTimeMs - order_by
|
|
activitySetRef - order_by
|
A unique, numeric identifier for the activitySet. |
actualParts - order_by
|
|
closedAt - order_by
|
|
cycleTimeMs - order_by
|
|
expectedSetupTimeMs - order_by
|
|
expectedUnitDurationMs - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
operation - Operation_order_by
|
|
optimalPartTimeMs - order_by
|
|
partCountMultiplier - order_by
|
|
partTimeMs - order_by
|
|
sampleCycleCount - order_by
|
|
samplePartCount - order_by
|
|
touchPartTimeMs - order_by
|
|
touchTimeMs - order_by
|
|
workOrderId - order_by
|
A globally unique identifier (UUID) for the workOrder. |
Example
{
"activePartTimeMs": "asc",
"activeTimeMs": "asc",
"activitySetRef": "asc",
"actualParts": "asc",
"closedAt": "asc",
"cycleTimeMs": "asc",
"expectedSetupTimeMs": "asc",
"expectedUnitDurationMs": "asc",
"machine": MachineTP_order_by,
"operation": Operation_order_by,
"optimalPartTimeMs": "asc",
"partCountMultiplier": "asc",
"partTimeMs": "asc",
"sampleCycleCount": "asc",
"samplePartCount": "asc",
"touchPartTimeMs": "asc",
"touchTimeMs": "asc",
"workOrderId": "asc"
}
ActivitySet_select_column
Values
Enum Value | Description |
---|---|
|
|
|
|
|
A unique, numeric identifier for the activitySet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A globally unique identifier (UUID) for the workOrder. |
Example
"activePartTimeMs"
ActivityType
Description
Throughout the lifespan of an Activity Set, multiple types of Activities can be performed. Activity Types are broken down into distinct modes that are uniquely supported by MachineMetrics and result in differing behavior within the user experience. The two modes that are supported by MachineMetrics at launch are Setup and Production. Activity Types allow for these modes to be broken down into differently labeled types. For example, the setup mode can be broken down into customer definable stages like Teardown, Tooling, and First Piece Inspection. Combined with Workflows, Activities can be used to notify key stakeholders in a process to take action when certain activities are started or work is projected to fail in achieving a goal.
Example
{
"activityMode": "production",
"activityTypeRef": 982312,
"company": {"name": "Cyberdyne"},
"name": "abc123"
}
ActivityType_bool_exp
Description
Boolean expressions to filter ActivityType. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [ActivityType_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - ActivityType_bool_exp
|
Negates the result of the given expression. |
_or - [ActivityType_bool_exp!]
|
Combines the given expressions using a logical OR. |
activityMode - String_comparison_exp
|
|
activityTypeRef - bigint_comparison_exp
|
A unique, numeric identifier for the activityType. |
company - CompanyTP_bool_exp
|
|
name - String_comparison_exp
|
A descriptive, human-readable name |
Example
{
"_and": [ActivityType_bool_exp],
"_not": ActivityType_bool_exp,
"_or": [ActivityType_bool_exp],
"activityMode": String_comparison_exp,
"activityTypeRef": bigint_comparison_exp,
"company": CompanyTP_bool_exp,
"name": String_comparison_exp
}
ActivityType_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
activityMode - order_by
|
|
activityTypeRef - order_by
|
A unique, numeric identifier for the activityType. |
company - CompanyTP_order_by
|
|
name - order_by
|
A descriptive, human-readable name |
Example
{
"activityMode": "asc",
"activityTypeRef": "asc",
"company": CompanyTP_order_by,
"name": "asc"
}
ActivityType_select_column
Values
Enum Value | Description |
---|---|
|
|
|
A unique, numeric identifier for the activityType. |
|
A descriptive, human-readable name |
Example
"activityMode"
Activity_bool_exp
Description
Boolean expressions to filter Activity. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [Activity_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - Activity_bool_exp
|
Negates the result of the given expression. |
_or - [Activity_bool_exp!]
|
Combines the given expressions using a logical OR. |
activityRef - bigint_comparison_exp
|
A unique, numeric identifier for the activity. |
activitySet - ActivitySet_bool_exp
|
|
activityType - ActivityType_bool_exp
|
|
endAt - timestamptz_comparison_exp
|
The end of an interval. Intervals are right-exclusive. |
startAt - timestamptz_comparison_exp
|
The start of an interval. |
Example
{
"_and": [Activity_bool_exp],
"_not": Activity_bool_exp,
"_or": [Activity_bool_exp],
"activityRef": bigint_comparison_exp,
"activitySet": ActivitySet_bool_exp,
"activityType": ActivityType_bool_exp,
"endAt": timestamptz_comparison_exp,
"startAt": timestamptz_comparison_exp
}
Activity_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
activityRef - order_by
|
A unique, numeric identifier for the activity. |
activitySet - ActivitySet_order_by
|
|
activityType - ActivityType_order_by
|
|
endAt - order_by
|
The end of an interval. Intervals are right-exclusive. |
startAt - order_by
|
The start of an interval. |
Example
{
"activityRef": "asc",
"activitySet": ActivitySet_order_by,
"activityType": ActivityType_order_by,
"endAt": "asc",
"startAt": "asc"
}
Activity_select_column
Values
Enum Value | Description |
---|---|
|
A unique, numeric identifier for the activity. |
|
The end of an interval. Intervals are right-exclusive. |
|
The start of an interval. |
Example
"activityRef"
AggregatedAlarmsRT
Fields
Field Name | Description |
---|---|
bucketEndAt - timestamptz
|
|
bucketStartAt - timestamptz
|
|
description - String
|
|
durationMs - numeric
|
|
label - String
|
|
machineRef - Int
|
A unique, numeric identifier for the machine. |
maxEndAt - timestamptz
|
|
minStartAt - timestamptz
|
|
nativeCode - String
|
|
recordCount - Int
|
|
status - String
|
Example
{
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"description": "xyz789",
"durationMs": numeric,
"label": "xyz789",
"machineRef": 987,
"maxEndAt": "2022-05-07T01:08:03.420Z",
"minStartAt": "2022-05-07T01:08:03.420Z",
"nativeCode": "xyz789",
"recordCount": 123,
"status": "abc123"
}
AggregatedAlarmsRT_bool_exp
Description
Boolean expressions to filter AggregatedAlarmsRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AggregatedAlarmsRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AggregatedAlarmsRT_bool_exp
|
Negates the result of the given expression. |
_or - [AggregatedAlarmsRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
bucketEndAt - timestamptz_comparison_exp
|
|
bucketStartAt - timestamptz_comparison_exp
|
|
description - String_comparison_exp
|
|
durationMs - numeric_comparison_exp
|
|
label - String_comparison_exp
|
|
machine - business_machine_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
maxEndAt - timestamptz_comparison_exp
|
|
minStartAt - timestamptz_comparison_exp
|
|
nativeCode - String_comparison_exp
|
|
recordCount - Int_comparison_exp
|
|
status - String_comparison_exp
|
Example
{
"_and": [AggregatedAlarmsRT_bool_exp],
"_not": AggregatedAlarmsRT_bool_exp,
"_or": [AggregatedAlarmsRT_bool_exp],
"bucketEndAt": timestamptz_comparison_exp,
"bucketStartAt": timestamptz_comparison_exp,
"description": String_comparison_exp,
"durationMs": numeric_comparison_exp,
"label": String_comparison_exp,
"machine": business_machine_bool_exp,
"machineRef": Int_comparison_exp,
"maxEndAt": timestamptz_comparison_exp,
"minStartAt": timestamptz_comparison_exp,
"nativeCode": String_comparison_exp,
"recordCount": Int_comparison_exp,
"status": String_comparison_exp
}
AggregatedAlarmsRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
bucketEndAt - order_by
|
|
bucketStartAt - order_by
|
|
description - order_by
|
|
durationMs - order_by
|
|
label - order_by
|
|
machine - business_machine_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
maxEndAt - order_by
|
|
minStartAt - order_by
|
|
nativeCode - order_by
|
|
recordCount - order_by
|
|
status - order_by
|
Example
{
"bucketEndAt": "asc",
"bucketStartAt": "asc",
"description": "asc",
"durationMs": "asc",
"label": "asc",
"machine": business_machine_order_by,
"machineRef": "asc",
"maxEndAt": "asc",
"minStartAt": "asc",
"nativeCode": "asc",
"recordCount": "asc",
"status": "asc"
}
AggregatedAlarmsRT_select_column
Values
Enum Value | Description |
---|---|
|
|
|
|
|
|
|
|
|
|
|
A unique, numeric identifier for the machine. |
|
|
|
|
|
|
|
|
|
Example
"bucketEndAt"
AggregatedPartCountRT
Fields
Field Name | Description |
---|---|
avgValue - float8!
|
|
bucketEndAt - timestamptz!
|
|
bucketStartAt - timestamptz!
|
|
bucketWidth - interval!
|
|
eventCount - Int!
|
|
firstBucketEventTime - timestamptz!
|
|
firstValue - Int
|
|
lastBucketEventTime - timestamptz!
|
|
lastValue - Int
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int!
|
A unique, numeric identifier for the machine. |
maxValue - Int
|
|
metricKey - String!
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - Int
|
|
sumOfValues - Int!
|
Example
{
"avgValue": 43.12,
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"bucketWidth": "1h",
"eventCount": 987,
"firstBucketEventTime": "2022-05-07T01:08:03.420Z",
"firstValue": 987,
"lastBucketEventTime": "2022-05-07T01:08:03.420Z",
"lastValue": 123,
"machine": MachineTP,
"machineRef": 987,
"maxValue": 123,
"metricKey": "xyz789",
"minValue": 987,
"sumOfValues": 123
}
AggregatedPartCountRT_bool_exp
Description
Boolean expressions to filter AggregatedPartCountRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AggregatedPartCountRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AggregatedPartCountRT_bool_exp
|
Negates the result of the given expression. |
_or - [AggregatedPartCountRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
avgValue - float8_comparison_exp
|
|
bucketEndAt - timestamptz_comparison_exp
|
|
bucketStartAt - timestamptz_comparison_exp
|
|
bucketWidth - interval_comparison_exp
|
|
eventCount - Int_comparison_exp
|
|
firstBucketEventTime - timestamptz_comparison_exp
|
|
firstValue - Int_comparison_exp
|
|
lastBucketEventTime - timestamptz_comparison_exp
|
|
lastValue - Int_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
maxValue - Int_comparison_exp
|
|
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - Int_comparison_exp
|
|
sumOfValues - Int_comparison_exp
|
Example
{
"_and": [AggregatedPartCountRT_bool_exp],
"_not": AggregatedPartCountRT_bool_exp,
"_or": [AggregatedPartCountRT_bool_exp],
"avgValue": float8_comparison_exp,
"bucketEndAt": timestamptz_comparison_exp,
"bucketStartAt": timestamptz_comparison_exp,
"bucketWidth": interval_comparison_exp,
"eventCount": Int_comparison_exp,
"firstBucketEventTime": timestamptz_comparison_exp,
"firstValue": Int_comparison_exp,
"lastBucketEventTime": timestamptz_comparison_exp,
"lastValue": Int_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"maxValue": Int_comparison_exp,
"metricKey": String_comparison_exp,
"minValue": Int_comparison_exp,
"sumOfValues": Int_comparison_exp
}
AggregatedPartCountRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avgValue - order_by
|
|
bucketEndAt - order_by
|
|
bucketStartAt - order_by
|
|
bucketWidth - order_by
|
|
eventCount - order_by
|
|
firstBucketEventTime - order_by
|
|
firstValue - order_by
|
|
lastBucketEventTime - order_by
|
|
lastValue - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
maxValue - order_by
|
|
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - order_by
|
|
sumOfValues - order_by
|
Example
{
"avgValue": "asc",
"bucketEndAt": "asc",
"bucketStartAt": "asc",
"bucketWidth": "asc",
"eventCount": "asc",
"firstBucketEventTime": "asc",
"firstValue": "asc",
"lastBucketEventTime": "asc",
"lastValue": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"maxValue": "asc",
"metricKey": "asc",
"minValue": "asc",
"sumOfValues": "asc"
}
AggregatedPartCountRT_select_column
Values
Enum Value | Description |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A unique, numeric identifier for the machine. |
|
|
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
|
|
Example
"avgValue"
AggregatedQuantityRT
Fields
Field Name | Description |
---|---|
avgValue - float8!
|
|
bucketEndAt - timestamptz!
|
|
bucketStartAt - timestamptz!
|
|
bucketWidth - interval!
|
|
eventCount - Int!
|
|
firstBucketEventTime - timestamptz!
|
|
firstValue - float8
|
|
lastBucketEventTime - timestamptz!
|
|
lastValue - float8
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int!
|
A unique, numeric identifier for the machine. |
maxValue - float8
|
|
metricKey - String!
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - float8
|
|
sumOfValues - float8!
|
Example
{
"avgValue": 43.12,
"bucketEndAt": "2022-05-07T01:08:03.420Z",
"bucketStartAt": "2022-05-07T01:08:03.420Z",
"bucketWidth": "1h",
"eventCount": 987,
"firstBucketEventTime": "2022-05-07T01:08:03.420Z",
"firstValue": 43.12,
"lastBucketEventTime": "2022-05-07T01:08:03.420Z",
"lastValue": 43.12,
"machine": MachineTP,
"machineRef": 987,
"maxValue": 43.12,
"metricKey": "xyz789",
"minValue": 43.12,
"sumOfValues": 43.12
}
AggregatedQuantityRT_bool_exp
Description
Boolean expressions to filter AggregatedQuantityRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AggregatedQuantityRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AggregatedQuantityRT_bool_exp
|
Negates the result of the given expression. |
_or - [AggregatedQuantityRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
avgValue - float8_comparison_exp
|
|
bucketEndAt - timestamptz_comparison_exp
|
|
bucketStartAt - timestamptz_comparison_exp
|
|
bucketWidth - interval_comparison_exp
|
|
eventCount - Int_comparison_exp
|
|
firstBucketEventTime - timestamptz_comparison_exp
|
|
firstValue - float8_comparison_exp
|
|
lastBucketEventTime - timestamptz_comparison_exp
|
|
lastValue - float8_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
maxValue - float8_comparison_exp
|
|
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - float8_comparison_exp
|
|
sumOfValues - float8_comparison_exp
|
Example
{
"_and": [AggregatedQuantityRT_bool_exp],
"_not": AggregatedQuantityRT_bool_exp,
"_or": [AggregatedQuantityRT_bool_exp],
"avgValue": float8_comparison_exp,
"bucketEndAt": timestamptz_comparison_exp,
"bucketStartAt": timestamptz_comparison_exp,
"bucketWidth": interval_comparison_exp,
"eventCount": Int_comparison_exp,
"firstBucketEventTime": timestamptz_comparison_exp,
"firstValue": float8_comparison_exp,
"lastBucketEventTime": timestamptz_comparison_exp,
"lastValue": float8_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"maxValue": float8_comparison_exp,
"metricKey": String_comparison_exp,
"minValue": float8_comparison_exp,
"sumOfValues": float8_comparison_exp
}
AggregatedQuantityRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avgValue - order_by
|
|
bucketEndAt - order_by
|
|
bucketStartAt - order_by
|
|
bucketWidth - order_by
|
|
eventCount - order_by
|
|
firstBucketEventTime - order_by
|
|
firstValue - order_by
|
|
lastBucketEventTime - order_by
|
|
lastValue - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
maxValue - order_by
|
|
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
minValue - order_by
|
|
sumOfValues - order_by
|
Example
{
"avgValue": "asc",
"bucketEndAt": "asc",
"bucketStartAt": "asc",
"bucketWidth": "asc",
"eventCount": "asc",
"firstBucketEventTime": "asc",
"firstValue": "asc",
"lastBucketEventTime": "asc",
"lastValue": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"maxValue": "asc",
"metricKey": "asc",
"minValue": "asc",
"sumOfValues": "asc"
}
AlarmIntervalRT
Fields
Field Name | Description |
---|---|
description - String
|
A short description of the alarm. |
endAt - timestamptz
|
The end of an interval. Intervals are right-exclusive. |
label - String
|
The label of the alarm (one of: NORMAL , WARNING , FAULT , UNAVAILABLE ) |
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int
|
A unique, numeric identifier for the machine. |
metricKey - String
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - String
|
The native code further specifies the alarm. The combination of machineRef , metricKey , and nativeCode uniquely identifies the alarm. |
sequence - Int
|
An integer value that determines the order of events with the same eventTime and metric. |
startAt - timestamptz
|
The start of an interval. |
Example
{
"description": "xyz789",
"endAt": "2022-05-07T01:08:03.420Z",
"label": "xyz789",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "abc123",
"nativeCode": "xyz789",
"sequence": 123,
"startAt": "2022-05-07T01:08:03.420Z"
}
AlarmIntervalRT_bool_exp
Description
Boolean expressions to filter AlarmIntervalRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AlarmIntervalRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AlarmIntervalRT_bool_exp
|
Negates the result of the given expression. |
_or - [AlarmIntervalRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
description - String_comparison_exp
|
A short description of the alarm. |
endAt - timestamptz_comparison_exp
|
The end of an interval. Intervals are right-exclusive. |
label - String_comparison_exp
|
The label of the alarm (one of: NORMAL , WARNING , FAULT , UNAVAILABLE ) |
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - String_comparison_exp
|
The native code further specifies the alarm. The combination of machineRef , metricKey , and nativeCode uniquely identifies the alarm. |
sequence - Int_comparison_exp
|
An integer value that determines the order of events with the same eventTime and metric. |
startAt - timestamptz_comparison_exp
|
The start of an interval. |
Example
{
"_and": [AlarmIntervalRT_bool_exp],
"_not": AlarmIntervalRT_bool_exp,
"_or": [AlarmIntervalRT_bool_exp],
"description": String_comparison_exp,
"endAt": timestamptz_comparison_exp,
"label": String_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"metricKey": String_comparison_exp,
"nativeCode": String_comparison_exp,
"sequence": Int_comparison_exp,
"startAt": timestamptz_comparison_exp
}
AlarmIntervalRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
description - order_by
|
A short description of the alarm. |
endAt - order_by
|
The end of an interval. Intervals are right-exclusive. |
label - order_by
|
The label of the alarm (one of: NORMAL , WARNING , FAULT , UNAVAILABLE ) |
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - order_by
|
The native code further specifies the alarm. The combination of machineRef , metricKey , and nativeCode uniquely identifies the alarm. |
sequence - order_by
|
An integer value that determines the order of events with the same eventTime and metric. |
startAt - order_by
|
The start of an interval. |
Example
{
"description": "asc",
"endAt": "asc",
"label": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"metricKey": "asc",
"nativeCode": "asc",
"sequence": "asc",
"startAt": "asc"
}
AlarmIntervalRT_select_column
Values
Enum Value | Description |
---|---|
|
A short description of the alarm. |
|
The end of an interval. Intervals are right-exclusive. |
|
The label of the alarm (one of: NORMAL , WARNING , FAULT , UNAVAILABLE ) |
|
A unique, numeric identifier for the machine. |
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
The native code further specifies the alarm. The combination of machineRef , metricKey , and nativeCode uniquely identifies the alarm. |
|
An integer value that determines the order of events with the same eventTime and metric. |
|
The start of an interval. |
Example
"description"
AnnotationTP
Description
Operators, automated processes, and other members of the organization may use the MachineMetrics Operator Dashboard or Timeline in product to identify periods of downtime, label it, and provide additional context through comments. A Annotation is the data model backing a Categorized Downtime.
Fields
Field Name | Description |
---|---|
annotationRef - Int
|
A unique, numeric identifier for the annotation. |
annotationType - AnnotationTypeTP
|
|
companyId - String
|
A globally unique identifier (UUID) for the company. |
description - String
|
|
endAt - timestamptz
|
The end of an interval. Intervals are right-exclusive. |
isPlanned - Boolean
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int
|
A unique, numeric identifier for the machine. |
startAt - timestamptz
|
The start of an interval. |
Example
{
"annotationRef": 123,
"annotationType": AnnotationTypeTP,
"companyId": "abc123",
"description": "abc123",
"endAt": "2022-05-07T01:08:03.420Z",
"isPlanned": true,
"machine": MachineTP,
"machineRef": 123,
"startAt": "2022-05-07T01:08:03.420Z"
}
AnnotationTP_aggregate_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avg - AnnotationTP_avg_order_by
|
|
count - order_by
|
|
max - AnnotationTP_max_order_by
|
|
min - AnnotationTP_min_order_by
|
|
stddev - AnnotationTP_stddev_order_by
|
|
stddev_pop - AnnotationTP_stddev_pop_order_by
|
|
stddev_samp - AnnotationTP_stddev_samp_order_by
|
|
sum - AnnotationTP_sum_order_by
|
|
var_pop - AnnotationTP_var_pop_order_by
|
|
var_samp - AnnotationTP_var_samp_order_by
|
|
variance - AnnotationTP_variance_order_by
|
Example
{
"avg": AnnotationTP_avg_order_by,
"count": "asc",
"max": AnnotationTP_max_order_by,
"min": AnnotationTP_min_order_by,
"stddev": AnnotationTP_stddev_order_by,
"stddev_pop": AnnotationTP_stddev_pop_order_by,
"stddev_samp": AnnotationTP_stddev_samp_order_by,
"sum": AnnotationTP_sum_order_by,
"var_pop": AnnotationTP_var_pop_order_by,
"var_samp": AnnotationTP_var_samp_order_by,
"variance": AnnotationTP_variance_order_by
}
AnnotationTP_avg_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_bool_exp
Description
Boolean expressions to filter AnnotationTP. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AnnotationTP_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AnnotationTP_bool_exp
|
Negates the result of the given expression. |
_or - [AnnotationTP_bool_exp!]
|
Combines the given expressions using a logical OR. |
annotationRef - Int_comparison_exp
|
A unique, numeric identifier for the annotation. |
annotationType - AnnotationTypeTP_bool_exp
|
|
companyId - String_comparison_exp
|
A globally unique identifier (UUID) for the company. |
description - String_comparison_exp
|
|
endAt - timestamptz_comparison_exp
|
The end of an interval. Intervals are right-exclusive. |
isPlanned - Boolean_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
startAt - timestamptz_comparison_exp
|
The start of an interval. |
Example
{
"_and": [AnnotationTP_bool_exp],
"_not": AnnotationTP_bool_exp,
"_or": [AnnotationTP_bool_exp],
"annotationRef": Int_comparison_exp,
"annotationType": AnnotationTypeTP_bool_exp,
"companyId": String_comparison_exp,
"description": String_comparison_exp,
"endAt": timestamptz_comparison_exp,
"isPlanned": Boolean_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"startAt": timestamptz_comparison_exp
}
AnnotationTP_max_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationRef - order_by
|
A unique, numeric identifier for the annotation. |
companyId - order_by
|
A globally unique identifier (UUID) for the company. |
description - order_by
|
|
endAt - order_by
|
The end of an interval. Intervals are right-exclusive. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
startAt - order_by
|
The start of an interval. |
Example
{
"annotationRef": "asc",
"companyId": "asc",
"description": "asc",
"endAt": "asc",
"machineRef": "asc",
"startAt": "asc"
}
AnnotationTP_min_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationRef - order_by
|
A unique, numeric identifier for the annotation. |
companyId - order_by
|
A globally unique identifier (UUID) for the company. |
description - order_by
|
|
endAt - order_by
|
The end of an interval. Intervals are right-exclusive. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
startAt - order_by
|
The start of an interval. |
Example
{
"annotationRef": "asc",
"companyId": "asc",
"description": "asc",
"endAt": "asc",
"machineRef": "asc",
"startAt": "asc"
}
AnnotationTP_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationRef - order_by
|
A unique, numeric identifier for the annotation. |
annotationType - AnnotationTypeTP_order_by
|
|
companyId - order_by
|
A globally unique identifier (UUID) for the company. |
description - order_by
|
|
endAt - order_by
|
The end of an interval. Intervals are right-exclusive. |
isPlanned - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
startAt - order_by
|
The start of an interval. |
Example
{
"annotationRef": "asc",
"annotationType": AnnotationTypeTP_order_by,
"companyId": "asc",
"description": "asc",
"endAt": "asc",
"isPlanned": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"startAt": "asc"
}
AnnotationTP_select_column
Values
Enum Value | Description |
---|---|
|
A unique, numeric identifier for the annotation. |
|
A globally unique identifier (UUID) for the company. |
|
|
|
The end of an interval. Intervals are right-exclusive. |
|
|
|
A unique, numeric identifier for the machine. |
|
The start of an interval. |
Example
"annotationRef"
AnnotationTP_stddev_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_stddev_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_stddev_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_sum_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_var_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_var_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTP_variance_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationRef": "asc", "machineRef": "asc"}
AnnotationTypeTP
Fields
Field Name | Description |
---|---|
annotationTypeRef - Int
|
A unique, numeric identifier for the annotationType. |
annotations - [AnnotationTP!]!
|
|
Arguments
|
|
color - String
|
The display color of the anntoation type. |
company - CompanyTP
|
|
erpReason - erpReason
|
|
isArchived - Boolean
|
A boolean flag indicating whether the annotation type is archived. This affects whether it is displayed in the UI. |
name - String
|
A descriptive, human-readable name |
Example
{
"annotationTypeRef": 987,
"annotations": [AnnotationTP],
"color": "abc123",
"company": {"name": "Cyberdyne"},
"erpReason": erpReason,
"isArchived": true,
"name": "xyz789"
}
AnnotationTypeTP_aggregate_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avg - AnnotationTypeTP_avg_order_by
|
|
count - order_by
|
|
max - AnnotationTypeTP_max_order_by
|
|
min - AnnotationTypeTP_min_order_by
|
|
stddev - AnnotationTypeTP_stddev_order_by
|
|
stddev_pop - AnnotationTypeTP_stddev_pop_order_by
|
|
stddev_samp - AnnotationTypeTP_stddev_samp_order_by
|
|
sum - AnnotationTypeTP_sum_order_by
|
|
var_pop - AnnotationTypeTP_var_pop_order_by
|
|
var_samp - AnnotationTypeTP_var_samp_order_by
|
|
variance - AnnotationTypeTP_variance_order_by
|
Example
{
"avg": AnnotationTypeTP_avg_order_by,
"count": "asc",
"max": AnnotationTypeTP_max_order_by,
"min": AnnotationTypeTP_min_order_by,
"stddev": AnnotationTypeTP_stddev_order_by,
"stddev_pop": AnnotationTypeTP_stddev_pop_order_by,
"stddev_samp": AnnotationTypeTP_stddev_samp_order_by,
"sum": AnnotationTypeTP_sum_order_by,
"var_pop": AnnotationTypeTP_var_pop_order_by,
"var_samp": AnnotationTypeTP_var_samp_order_by,
"variance": AnnotationTypeTP_variance_order_by
}
AnnotationTypeTP_avg_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_bool_exp
Description
Boolean expressions to filter AnnotationTypeTP. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [AnnotationTypeTP_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - AnnotationTypeTP_bool_exp
|
Negates the result of the given expression. |
_or - [AnnotationTypeTP_bool_exp!]
|
Combines the given expressions using a logical OR. |
annotationTypeRef - Int_comparison_exp
|
A unique, numeric identifier for the annotationType. |
annotations - AnnotationTP_bool_exp
|
|
color - String_comparison_exp
|
The display color of the anntoation type. |
company - CompanyTP_bool_exp
|
|
isArchived - Boolean_comparison_exp
|
A boolean flag indicating whether the annotation type is archived. This affects whether it is displayed in the UI. |
name - String_comparison_exp
|
A descriptive, human-readable name |
Example
{
"_and": [AnnotationTypeTP_bool_exp],
"_not": AnnotationTypeTP_bool_exp,
"_or": [AnnotationTypeTP_bool_exp],
"annotationTypeRef": Int_comparison_exp,
"annotations": AnnotationTP_bool_exp,
"color": String_comparison_exp,
"company": CompanyTP_bool_exp,
"isArchived": Boolean_comparison_exp,
"name": String_comparison_exp
}
AnnotationTypeTP_max_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationTypeRef": "asc", "color": "asc", "name": "asc"}
AnnotationTypeTP_min_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"annotationTypeRef": "asc", "color": "asc", "name": "asc"}
AnnotationTypeTP_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
annotations_aggregate - AnnotationTP_aggregate_order_by
|
|
color - order_by
|
The display color of the anntoation type. |
company - CompanyTP_order_by
|
|
isArchived - order_by
|
A boolean flag indicating whether the annotation type is archived. This affects whether it is displayed in the UI. |
name - order_by
|
A descriptive, human-readable name |
Example
{
"annotationTypeRef": "asc",
"annotations_aggregate": AnnotationTP_aggregate_order_by,
"color": "asc",
"company": CompanyTP_order_by,
"isArchived": "asc",
"name": "asc"
}
AnnotationTypeTP_select_column
Values
Enum Value | Description |
---|---|
|
A unique, numeric identifier for the annotationType. |
|
The display color of the anntoation type. |
|
A boolean flag indicating whether the annotation type is archived. This affects whether it is displayed in the UI. |
|
A descriptive, human-readable name |
Example
"annotationTypeRef"
AnnotationTypeTP_stddev_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_stddev_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_stddev_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_sum_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_var_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_var_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
AnnotationTypeTP_variance_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
annotationTypeRef - order_by
|
A unique, numeric identifier for the annotationType. |
Example
{"annotationTypeRef": "asc"}
Boolean
Boolean_comparison_exp
Fields
Input Field | Description |
---|---|
_eq - Boolean
|
Returns true if the event value is equal to the given value; false otherwise. |
_gt - Boolean
|
Returns true if the event value is greater than the given value; false otherwise. |
_gte - Boolean
|
Returns true if the event value is greater than the given value; false otherwise. |
_in - [Boolean!]
|
Returns true if the event value is equal to one of the given values in the collection; false otherwise. |
_is_null - Boolean
|
Checks whether the event value is or is not NULL . |
_lt - Boolean
|
Returns true if the event value is less than the given value; false otherwise. |
_lte - Boolean
|
Returns true if the event value is less than the given value; false otherwise. |
_neq - Boolean
|
Returns true if the event value is not equal to the given value; false otherwise. |
_nin - [Boolean!]
|
Returns true if the event value is not equal to any of the given values in the collection; false otherwise. |
Example
{
"_eq": true,
"_gt": false,
"_gte": true,
"_in": [true],
"_is_null": true,
"_lt": true,
"_lte": false,
"_neq": false,
"_nin": [false]
}
CompanyTP
Description
All data is isolated within a Company. The Machines, Annotation Types, Activity Types, Operators, and other data is scoped to this level. Information like the name, address, and timezone are available on a Company.
Fields
Field Name | Description |
---|---|
activityTypes - [ActivityType!]!
|
A set of activity types specific to the company. |
Arguments
|
|
addressText - String
|
The full address as as string. |
annotationTypes - [AnnotationTypeTP!]!
|
|
Arguments
|
|
companyId - String
|
A globally unique identifier (UUID) for the company. |
location - Location
|
|
machines - [MachineTP!]!
|
The set machines. |
Arguments
|
|
name - String
|
A descriptive, human-readable name |
operations - [Operation!]!
|
|
Arguments
|
|
operators - [OperatorTP!]!
|
Returns a collection of Operators |
Arguments
|
|
rejectReasons - [RejectReason!]!
|
A set of reject reasons specific to the company. |
Arguments
|
|
timeZone - String
|
The timezone the company is associated with. Must be an |
Example
{"name": "Cyberdyne"}
CompanyTP_bool_exp
Description
Boolean expressions to filter CompanyTP. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [CompanyTP_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - CompanyTP_bool_exp
|
Negates the result of the given expression. |
_or - [CompanyTP_bool_exp!]
|
Combines the given expressions using a logical OR. |
activityTypes - ActivityType_bool_exp
|
A set of activity types specific to the company. |
addressText - String_comparison_exp
|
The full address as as string. |
annotationTypes - AnnotationTypeTP_bool_exp
|
|
companyId - String_comparison_exp
|
A globally unique identifier (UUID) for the company. |
location - Location_bool_exp
|
|
machines - MachineTP_bool_exp
|
The set machines. |
name - String_comparison_exp
|
A descriptive, human-readable name |
operations - Operation_bool_exp
|
|
operators - OperatorTP_bool_exp
|
Returns a collection of Operators |
rejectReasons - RejectReason_bool_exp
|
A set of reject reasons specific to the company. |
timeZone - String_comparison_exp
|
The timezone the company is associated with. Must be an |
Example
{
"_and": [CompanyTP_bool_exp],
"_not": CompanyTP_bool_exp,
"_or": [CompanyTP_bool_exp],
"activityTypes": ActivityType_bool_exp,
"addressText": String_comparison_exp,
"annotationTypes": AnnotationTypeTP_bool_exp,
"companyId": String_comparison_exp,
"location": Location_bool_exp,
"machines": MachineTP_bool_exp,
"name": String_comparison_exp,
"operations": Operation_bool_exp,
"operators": OperatorTP_bool_exp,
"rejectReasons": RejectReason_bool_exp,
"timeZone": String_comparison_exp
}
CompanyTP_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
addressText - order_by
|
The full address as as string. |
annotationTypes_aggregate - AnnotationTypeTP_aggregate_order_by
|
|
companyId - order_by
|
A globally unique identifier (UUID) for the company. |
location - Location_order_by
|
|
name - order_by
|
A descriptive, human-readable name |
timeZone - order_by
|
The timezone the company is associated with. Must be an |
Example
{
"addressText": "asc",
"annotationTypes_aggregate": AnnotationTypeTP_aggregate_order_by,
"companyId": "asc",
"location": Location_order_by,
"name": "asc",
"timeZone": "asc"
}
CurrentAlarmRT
Fields
Field Name | Description |
---|---|
description - String
|
|
label - String
|
|
latestEventAt - timestamptz!
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int
|
A unique, numeric identifier for the machine. |
metricKey - String
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - String
|
|
startAt - timestamptz
|
The start of an interval. |
Example
{
"description": "xyz789",
"label": "abc123",
"latestEventAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 987,
"metricKey": "xyz789",
"nativeCode": "xyz789",
"startAt": "2022-05-07T01:08:03.420Z"
}
CurrentAlarmRT_aggregate_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avg - CurrentAlarmRT_avg_order_by
|
|
count - order_by
|
|
max - CurrentAlarmRT_max_order_by
|
|
min - CurrentAlarmRT_min_order_by
|
|
stddev - CurrentAlarmRT_stddev_order_by
|
|
stddev_pop - CurrentAlarmRT_stddev_pop_order_by
|
|
stddev_samp - CurrentAlarmRT_stddev_samp_order_by
|
|
sum - CurrentAlarmRT_sum_order_by
|
|
var_pop - CurrentAlarmRT_var_pop_order_by
|
|
var_samp - CurrentAlarmRT_var_samp_order_by
|
|
variance - CurrentAlarmRT_variance_order_by
|
Example
{
"avg": CurrentAlarmRT_avg_order_by,
"count": "asc",
"max": CurrentAlarmRT_max_order_by,
"min": CurrentAlarmRT_min_order_by,
"stddev": CurrentAlarmRT_stddev_order_by,
"stddev_pop": CurrentAlarmRT_stddev_pop_order_by,
"stddev_samp": CurrentAlarmRT_stddev_samp_order_by,
"sum": CurrentAlarmRT_sum_order_by,
"var_pop": CurrentAlarmRT_var_pop_order_by,
"var_samp": CurrentAlarmRT_var_samp_order_by,
"variance": CurrentAlarmRT_variance_order_by
}
CurrentAlarmRT_avg_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_bool_exp
Description
Boolean expressions to filter CurrentAlarmRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [CurrentAlarmRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - CurrentAlarmRT_bool_exp
|
Negates the result of the given expression. |
_or - [CurrentAlarmRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
description - String_comparison_exp
|
|
label - String_comparison_exp
|
|
latestEventAt - timestamptz_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - String_comparison_exp
|
|
startAt - timestamptz_comparison_exp
|
The start of an interval. |
Example
{
"_and": [CurrentAlarmRT_bool_exp],
"_not": CurrentAlarmRT_bool_exp,
"_or": [CurrentAlarmRT_bool_exp],
"description": String_comparison_exp,
"label": String_comparison_exp,
"latestEventAt": timestamptz_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"metricKey": String_comparison_exp,
"nativeCode": String_comparison_exp,
"startAt": timestamptz_comparison_exp
}
CurrentAlarmRT_max_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
description - order_by
|
|
label - order_by
|
|
latestEventAt - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - order_by
|
|
startAt - order_by
|
The start of an interval. |
Example
{
"description": "asc",
"label": "asc",
"latestEventAt": "asc",
"machineRef": "asc",
"metricKey": "asc",
"nativeCode": "asc",
"startAt": "asc"
}
CurrentAlarmRT_min_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
description - order_by
|
|
label - order_by
|
|
latestEventAt - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - order_by
|
|
startAt - order_by
|
The start of an interval. |
Example
{
"description": "asc",
"label": "asc",
"latestEventAt": "asc",
"machineRef": "asc",
"metricKey": "asc",
"nativeCode": "asc",
"startAt": "asc"
}
CurrentAlarmRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
description - order_by
|
|
label - order_by
|
|
latestEventAt - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
nativeCode - order_by
|
|
startAt - order_by
|
The start of an interval. |
Example
{
"description": "asc",
"label": "asc",
"latestEventAt": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"metricKey": "asc",
"nativeCode": "asc",
"startAt": "asc"
}
CurrentAlarmRT_select_column
Values
Enum Value | Description |
---|---|
|
|
|
|
|
|
|
A unique, numeric identifier for the machine. |
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
|
|
The start of an interval. |
Example
"description"
CurrentAlarmRT_stddev_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_stddev_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_stddev_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_sum_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_var_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_var_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentAlarmRT_variance_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT
Fields
Field Name | Description |
---|---|
latestEventAt - timestamptz!
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int
|
A unique, numeric identifier for the machine. |
metricKey - String
|
Each metric is globally identified by the combination of machineRef and metricKey . |
startAt - timestamptz
|
The start of an interval. |
value - String
|
The value observed at the eventTime . |
Example
{
"latestEventAt": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "abc123",
"startAt": "2022-05-07T01:08:03.420Z",
"value": "xyz789"
}
CurrentStateRT_aggregate_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avg - CurrentStateRT_avg_order_by
|
|
count - order_by
|
|
max - CurrentStateRT_max_order_by
|
|
min - CurrentStateRT_min_order_by
|
|
stddev - CurrentStateRT_stddev_order_by
|
|
stddev_pop - CurrentStateRT_stddev_pop_order_by
|
|
stddev_samp - CurrentStateRT_stddev_samp_order_by
|
|
sum - CurrentStateRT_sum_order_by
|
|
var_pop - CurrentStateRT_var_pop_order_by
|
|
var_samp - CurrentStateRT_var_samp_order_by
|
|
variance - CurrentStateRT_variance_order_by
|
Example
{
"avg": CurrentStateRT_avg_order_by,
"count": "asc",
"max": CurrentStateRT_max_order_by,
"min": CurrentStateRT_min_order_by,
"stddev": CurrentStateRT_stddev_order_by,
"stddev_pop": CurrentStateRT_stddev_pop_order_by,
"stddev_samp": CurrentStateRT_stddev_samp_order_by,
"sum": CurrentStateRT_sum_order_by,
"var_pop": CurrentStateRT_var_pop_order_by,
"var_samp": CurrentStateRT_var_samp_order_by,
"variance": CurrentStateRT_variance_order_by
}
CurrentStateRT_avg_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_bool_exp
Description
Boolean expressions to filter CurrentStateRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [CurrentStateRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - CurrentStateRT_bool_exp
|
Negates the result of the given expression. |
_or - [CurrentStateRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
latestEventAt - timestamptz_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
startAt - timestamptz_comparison_exp
|
The start of an interval. |
value - String_comparison_exp
|
The value observed at the eventTime . |
Example
{
"_and": [CurrentStateRT_bool_exp],
"_not": CurrentStateRT_bool_exp,
"_or": [CurrentStateRT_bool_exp],
"latestEventAt": timestamptz_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"metricKey": String_comparison_exp,
"startAt": timestamptz_comparison_exp,
"value": String_comparison_exp
}
CurrentStateRT_max_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
latestEventAt - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
startAt - order_by
|
The start of an interval. |
value - order_by
|
The value observed at the eventTime . |
Example
{
"latestEventAt": "asc",
"machineRef": "asc",
"metricKey": "asc",
"startAt": "asc",
"value": "asc"
}
CurrentStateRT_min_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
latestEventAt - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
startAt - order_by
|
The start of an interval. |
value - order_by
|
The value observed at the eventTime . |
Example
{
"latestEventAt": "asc",
"machineRef": "asc",
"metricKey": "asc",
"startAt": "asc",
"value": "asc"
}
CurrentStateRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
latestEventAt - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
startAt - order_by
|
The start of an interval. |
value - order_by
|
The value observed at the eventTime . |
Example
{
"latestEventAt": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"metricKey": "asc",
"startAt": "asc",
"value": "asc"
}
CurrentStateRT_select_column
Values
Enum Value | Description |
---|---|
|
|
|
A unique, numeric identifier for the machine. |
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
The start of an interval. |
|
The value observed at the eventTime . |
Example
"latestEventAt"
CurrentStateRT_stddev_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_stddev_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_stddev_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_sum_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_var_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_var_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CurrentStateRT_variance_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
Example
{"machineRef": "asc"}
CycleTimeStatsRT
Example
{
"machine": MachineTP,
"machineRef": 123,
"medianCycleTime": numeric,
"operation": Operation,
"operationId": "abc123",
"partCount": 987
}
CycleTimeStatsRT_bool_exp
Description
Boolean expressions to filter CycleTimeStatsRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [CycleTimeStatsRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - CycleTimeStatsRT_bool_exp
|
Negates the result of the given expression. |
_or - [CycleTimeStatsRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
medianCycleTime - numeric_comparison_exp
|
|
operation - Operation_bool_exp
|
|
operationId - String_comparison_exp
|
A globally unique identifier (UUID) for the operation. |
partCount - Int_comparison_exp
|
Example
{
"_and": [CycleTimeStatsRT_bool_exp],
"_not": CycleTimeStatsRT_bool_exp,
"_or": [CycleTimeStatsRT_bool_exp],
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"medianCycleTime": numeric_comparison_exp,
"operation": Operation_bool_exp,
"operationId": String_comparison_exp,
"partCount": Int_comparison_exp
}
CycleTimeStatsRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
medianCycleTime - order_by
|
|
operation - Operation_order_by
|
|
operationId - order_by
|
A globally unique identifier (UUID) for the operation. |
partCount - order_by
|
Example
{
"machine": MachineTP_order_by,
"machineRef": "asc",
"medianCycleTime": "asc",
"operation": Operation_order_by,
"operationId": "asc",
"partCount": "asc"
}
CycleTimeStatsRT_select_column
Values
Enum Value | Description |
---|---|
|
A unique, numeric identifier for the machine. |
|
|
|
A globally unique identifier (UUID) for the operation. |
|
Example
"machineRef"
Event
Fields
Field Name | Description |
---|---|
eventTime - timestamptz!
|
|
machineRef - Int!
|
A unique, numeric identifier for the machine. |
metricKey - String!
|
Each metric is globally identified by the combination of machineRef and metricKey . |
sequence - Int!
|
An integer value that determines the order of events with the same eventTime and metric. |
value - jsonb
|
The value observed at the eventTime . |
Arguments
|
Example
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machineRef": 987,
"metricKey": "abc123",
"sequence": 987,
"value": jsonb
}
Event_bool_exp
Description
Boolean expressions to filter Event. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [Event_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - Event_bool_exp
|
Negates the result of the given expression. |
_or - [Event_bool_exp!]
|
Combines the given expressions using a logical OR. |
eventTime - timestamptz_comparison_exp
|
|
machine - business_machine_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
sequence - Int_comparison_exp
|
An integer value that determines the order of events with the same eventTime and metric. |
value - jsonb_comparison_exp
|
The value observed at the eventTime . |
Example
{
"_and": [Event_bool_exp],
"_not": Event_bool_exp,
"_or": [Event_bool_exp],
"eventTime": timestamptz_comparison_exp,
"machine": business_machine_bool_exp,
"machineRef": Int_comparison_exp,
"metricKey": String_comparison_exp,
"sequence": Int_comparison_exp,
"value": jsonb_comparison_exp
}
Event_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
eventTime - order_by
|
|
machine - business_machine_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
sequence - order_by
|
An integer value that determines the order of events with the same eventTime and metric. |
value - order_by
|
The value observed at the eventTime . |
Example
{
"eventTime": "asc",
"machine": business_machine_order_by,
"machineRef": "asc",
"metricKey": "asc",
"sequence": "asc",
"value": "asc"
}
Event_select_column
Values
Enum Value | Description |
---|---|
|
|
|
A unique, numeric identifier for the machine. |
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
An integer value that determines the order of events with the same eventTime and metric. |
|
The value observed at the eventTime . |
Example
"eventTime"
Float
Example
987.65
Float_comparison_exp
Fields
Input Field | Description |
---|---|
_eq - Float
|
Returns true if the event value is equal to the given value; false otherwise. |
_gt - Float
|
Returns true if the event value is greater than the given value; false otherwise. |
_gte - Float
|
Returns true if the event value is greater than the given value; false otherwise. |
_in - [Float!]
|
Returns true if the event value is equal to one of the given values in the collection; false otherwise. |
_is_null - Boolean
|
Checks whether the event value is or is not NULL . |
_lt - Float
|
Returns true if the event value is less than the given value; false otherwise. |
_lte - Float
|
Returns true if the event value is less than the given value; false otherwise. |
_neq - Float
|
Returns true if the event value is not equal to the given value; false otherwise. |
_nin - [Float!]
|
Returns true if the event value is not equal to any of the given values in the collection; false otherwise. |
Example
{
"_eq": 987.65,
"_gt": 123.45,
"_gte": 123.45,
"_in": [123.45],
"_is_null": true,
"_lt": 987.65,
"_lte": 123.45,
"_neq": 123.45,
"_nin": [123.45]
}
Int
Example
987
Int_comparison_exp
Fields
Input Field | Description |
---|---|
_eq - Int
|
Returns true if the event value is equal to the given value; false otherwise. |
_gt - Int
|
Returns true if the event value is greater than the given value; false otherwise. |
_gte - Int
|
Returns true if the event value is greater than the given value; false otherwise. |
_in - [Int!]
|
Returns true if the event value is equal to one of the given values in the collection; false otherwise. |
_is_null - Boolean
|
Checks whether the event value is or is not NULL . |
_lt - Int
|
Returns true if the event value is less than the given value; false otherwise. |
_lte - Int
|
Returns true if the event value is less than the given value; false otherwise. |
_neq - Int
|
Returns true if the event value is not equal to the given value; false otherwise. |
_nin - [Int!]
|
Returns true if the event value is not equal to any of the given values in the collection; false otherwise. |
Example
{
"_eq": 987,
"_gt": 987,
"_gte": 123,
"_in": [987],
"_is_null": false,
"_lt": 987,
"_lte": 987,
"_neq": 123,
"_nin": [987]
}
LatestPositionRT
Fields
Field Name | Description |
---|---|
eventTime - timestamptz
|
|
machine - MachineTP
|
The machine the event originates from. |
machineRef - Int
|
A unique, numeric identifier for the machine. |
metricKey - String
|
Each metric is globally identified by the combination of machineRef and metricKey . |
x - float8
|
The x coordinate value. |
y - float8
|
The y coordinate value. |
z - float8
|
The z coordinate value. |
Example
{
"eventTime": "2022-05-07T01:08:03.420Z",
"machine": MachineTP,
"machineRef": 123,
"metricKey": "abc123",
"x": 43.12,
"y": 43.12,
"z": 43.12
}
LatestPositionRT_aggregate_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
avg - LatestPositionRT_avg_order_by
|
|
count - order_by
|
|
max - LatestPositionRT_max_order_by
|
|
min - LatestPositionRT_min_order_by
|
|
stddev - LatestPositionRT_stddev_order_by
|
|
stddev_pop - LatestPositionRT_stddev_pop_order_by
|
|
stddev_samp - LatestPositionRT_stddev_samp_order_by
|
|
sum - LatestPositionRT_sum_order_by
|
|
var_pop - LatestPositionRT_var_pop_order_by
|
|
var_samp - LatestPositionRT_var_samp_order_by
|
|
variance - LatestPositionRT_variance_order_by
|
Example
{
"avg": LatestPositionRT_avg_order_by,
"count": "asc",
"max": LatestPositionRT_max_order_by,
"min": LatestPositionRT_min_order_by,
"stddev": LatestPositionRT_stddev_order_by,
"stddev_pop": LatestPositionRT_stddev_pop_order_by,
"stddev_samp": LatestPositionRT_stddev_samp_order_by,
"sum": LatestPositionRT_sum_order_by,
"var_pop": LatestPositionRT_var_pop_order_by,
"var_samp": LatestPositionRT_var_samp_order_by,
"variance": LatestPositionRT_variance_order_by
}
LatestPositionRT_avg_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_bool_exp
Description
Boolean expressions to filter LatestPositionRT. All fields are combined with a logical AND.
Fields
Input Field | Description |
---|---|
_and - [LatestPositionRT_bool_exp!]
|
Combines the given expressions using a logical AND |
_not - LatestPositionRT_bool_exp
|
Negates the result of the given expression. |
_or - [LatestPositionRT_bool_exp!]
|
Combines the given expressions using a logical OR. |
eventTime - timestamptz_comparison_exp
|
|
machine - MachineTP_bool_exp
|
The machine the event originates from. |
machineRef - Int_comparison_exp
|
A unique, numeric identifier for the machine. |
metricKey - String_comparison_exp
|
Each metric is globally identified by the combination of machineRef and metricKey . |
x - float8_comparison_exp
|
The x coordinate value. |
y - float8_comparison_exp
|
The y coordinate value. |
z - float8_comparison_exp
|
The z coordinate value. |
Example
{
"_and": [LatestPositionRT_bool_exp],
"_not": LatestPositionRT_bool_exp,
"_or": [LatestPositionRT_bool_exp],
"eventTime": timestamptz_comparison_exp,
"machine": MachineTP_bool_exp,
"machineRef": Int_comparison_exp,
"metricKey": String_comparison_exp,
"x": float8_comparison_exp,
"y": float8_comparison_exp,
"z": float8_comparison_exp
}
LatestPositionRT_max_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
eventTime - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
x - order_by
|
The x coordinate value. |
y - order_by
|
The y coordinate value. |
z - order_by
|
The z coordinate value. |
Example
{
"eventTime": "asc",
"machineRef": "asc",
"metricKey": "asc",
"x": "asc",
"y": "asc",
"z": "asc"
}
LatestPositionRT_min_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
eventTime - order_by
|
|
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
x - order_by
|
The x coordinate value. |
y - order_by
|
The y coordinate value. |
z - order_by
|
The z coordinate value. |
Example
{
"eventTime": "asc",
"machineRef": "asc",
"metricKey": "asc",
"x": "asc",
"y": "asc",
"z": "asc"
}
LatestPositionRT_order_by
Description
Sort the returned array by one or more fields of it's elements.
Fields
Input Field | Description |
---|---|
eventTime - order_by
|
|
machine - MachineTP_order_by
|
The machine the event originates from. |
machineRef - order_by
|
A unique, numeric identifier for the machine. |
metricKey - order_by
|
Each metric is globally identified by the combination of machineRef and metricKey . |
x - order_by
|
The x coordinate value. |
y - order_by
|
The y coordinate value. |
z - order_by
|
The z coordinate value. |
Example
{
"eventTime": "asc",
"machine": MachineTP_order_by,
"machineRef": "asc",
"metricKey": "asc",
"x": "asc",
"y": "asc",
"z": "asc"
}
LatestPositionRT_select_column
Values
Enum Value | Description |
---|---|
|
|
|
A unique, numeric identifier for the machine. |
|
Each metric is globally identified by the combination of machineRef and metricKey . |
|
The x coordinate value. |
|
The y coordinate value. |
|
The z coordinate value. |
Example
"eventTime"
LatestPositionRT_stddev_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_stddev_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_stddev_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_sum_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_var_pop_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_var_samp_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}
LatestPositionRT_variance_order_by
Description
Sort the returned array by one or more fields of it's elements.
Example
{"machineRef": "asc", "x": "asc", "y": "asc", "z": "asc"}