Serial numbers in line items

`SerialNumberLineItem` — Returns a single serial number line item based on the IDs provided

query GetSerialNumberLineItem($line_item_id: ID, $serial_number_id: ID) {
  SerialNumberLineItem(line_item_id: $line_item_id, serial_number_id: $serial_number_id) {
    serial_number_id
    line_item_id
    serial_number {
      id
      label
      status
    }
    line_item {
      id
      label
    }
  }
}

{
  "data": {
    "SerialNumberLineItem": {
      "serial_number_id": 50001,
      "line_item_id": 100001,
      "serial_number": {
        "id": 50001,
        "label": "SN-001",
        "status": "active"
      },
      "line_item": {
        "id": 100001,
        "label": "Product A"
      }
    }
  }
}

`SerialNumberLineItems` — Returns a list of serial number line items with grouping, filters, and ordering

query SerialNumberLineItems(
  $where: QuerySerialNumberLineItemsWhereWhereConditions,
  $orderBy: [QuerySerialNumberLineItemsOrderByOrderByClause!]
) {
  SerialNumberLineItems(
    where: $where
    orderBy: $orderBy
  ) {
    serial_number_id
    line_item_id
    serial_number {
      id
      label
      status
    }
    line_item {
      id
      label
    }
  }
}

{
  "where": {
    "AND": [
      { "column": "LINE_ITEM_ID", "operator": "EQ", "value": 100001 }
    ]
  },
  "orderBy": [
    { "column": "SERIAL_NUMBER_ID", "order": "ASC" }
  ]
}

Available fields

Field	Type	Description
`serial_number_id`	Int	ID of the linked serial number.
`line_item_id`	Int	ID of the linked line item.
`serial_number`	Object	Associated serial number entity.
`line_item`	Object	Associated line item entity.

Filters

Field	Example
`serial_number_id`	`{ "column": "SERIAL_NUMBER_ID", "operator": "EQ", "value": 50001 }`
`line_item_id`	`{ "column": "LINE_ITEM_ID", "operator": "EQ", "value": 100001 }`
`serial_number_label`	`{ "column": "SERIAL_NUMBER_LABEL", "operator": "LIKE", "value": "%SN-%" }`

Sorting

You can sort data based on following fields: serial_number_id, line_item_id

query SortSerialNumberLineItems {
  SerialNumberLineItems(
    orderBy: [{ column: SERIAL_NUMBER_ID, order: ASC }]
  ) {
    serial_number_id
    line_item_id
    serial_number {
      id
      label
    }
  }
}

Example of data returned

{
  "data": {
    "SerialNumberLineItems": [
      {
        "serial_number_id": 50001,
        "line_item_id": 100001,
        "serial_number": { "id": 50001, "label": "SN-001", "status": "active" },
        "line_item": { "id": 100001, "label": "Product A" }
      },
      {
        "serial_number_id": 50002,
        "line_item_id": 100001,
        "serial_number": { "id": 50002, "label": "SN-002", "status": "active" },
        "line_item": { "id": 100001, "label": "Product A" }
      }
    ]
  }
}