TorqueResult

One row per torque result captured from a connected torque tool (passive results). Correlate to traces via resultId.

type TorqueResult {
  actionIndex: Int
  angle: numeric
  createdAt: timestamptz
  deviceId: String
  deviceName: String
  formattedValue(
    path: String
  ): jsonb
  job: Int
  resultId: Int
  serialNumber: String
  stationId: String
  stationName: String
  toolSerial: String
  torque: numeric
  traces(
    distinctOn: [TorqueTraceSelectColumn!]
    limit: Int
    offset: Int
    orderBy: [TorqueTraceOrderBy!]
    where: TorqueTraceBoolExp
  ): [TorqueTrace!]!
}

Fields

TorqueResult.actionIndex ● Int scalar

Gang/spindle index from the device payload.

TorqueResult.angle ● numeric scalar

Final angle reported by the tool.

TorqueResult.createdAt ● timestamptz scalar

When the result was recorded.

TorqueResult.deviceId ● String scalar

Id of the device (torque tool) that produced the result.

TorqueResult.deviceName ● String scalar

Name of the device (torque tool) that produced the result.

TorqueResult.formattedValue ● jsonb scalar

Raw device result payload (JSON).

TorqueResult.formattedValue.path ● String scalar

JSON select path

TorqueResult.job ● Int scalar

Job/pset number from the device payload.

TorqueResult.resultId ● Int scalar

Unique id of the torque result. TorqueTrace.resultId is the foreign key back to this.

TorqueResult.serialNumber ● String scalar

Serial number the result was recorded against (from the device payload).

TorqueResult.stationId ● String scalar

Id of the station the device was assigned to.

TorqueResult.stationName ● String scalar

Name of the station the device was assigned to.

TorqueResult.toolSerial ● String scalar

Serial of the physical tool.

TorqueResult.torque ● numeric scalar

Final torque value reported by the tool.

TorqueResult.traces ● [TorqueTrace!]! non-null object

Torque/angle traces for this result, one per bolt.

TorqueResult.traces.distinctOn ● [TorqueTraceSelectColumn!] list enum

distinct select on columns

TorqueResult.traces.limit ● Int scalar

limit the number of rows returned

TorqueResult.traces.offset ● Int scalar

skip the first n rows; use only with orderBy

TorqueResult.traces.orderBy ● [TorqueTraceOrderBy!] list input

sort the rows by one or more columns

TorqueResult.traces.where ● TorqueTraceBoolExp input

filter the rows returned

Returned By

torqueResults query