Batch numbers in line items

`BatchNumberLineItem` — Returns a single batch number line item based on the `id` provided

query GetBatchNumberLineItem($id: ID) {
  BatchNumberLineItem(id: $id) {
    id
    quantity
    line_item { id }
    batch_number { id }
  }
}

{
  "id": 100012
}

`BatchNumberLineItems` — Returns a list of batch number line items with grouping, filters, and ordering

query BatchNumberLineItems(
  $groupBy: QueryBatchNumberLineItemsGroupByGroupByClause,
  $where: QueryBatchNumberLineItemsWhereWhereConditions,
  $orderBy: [QueryBatchNumberLineItemsOrderByOrderByClause!]
) {
  BatchNumberLineItems(
    groupBy: $groupBy
    where: $where
    orderBy: $orderBy
  ) {
    id
    quantity
    line_item { id }
    batch_number { id }
  }
}

{
  "groupBy": {
    "HAVING": [
      { "column": "ID", "value": 100012 }
    ]
  },
  "where": {
    "AND": [
      { "column": "BATCH_NUMBER_ID", "operator": "EQ", "value": 100010 }
    ]
  },
  "orderBy": [
    { "column": "QUANTITY", "order": "DESC" }
  ]
}

Available fields

Field	Type	Description
`id`	Int	Unique identifier of the batch number line item.
`quantity`	Float	Quantity of the batch number in the line item.
`line_item`	Object	Linked line item entity.
`batch_number`	Object	Linked batch number entity.

Filters

You can create filters based on following fields

id - Int
Example: `{ "column": "ID", "operator": "EQ", "value": 100012 }`

quantity - Float
Example: `{ "column": "QUANTITY", "operator": "GT", "value": 10 }`

line_item_id - ID
Example: `{ "column": "LINE_ITEM_ID", "operator": "EQ", "value": 100001 }`

batch_number_id - ID
Example: `{ "column": "BATCH_NUMBER_ID", "operator": "EQ", "value": 100010 }`

Sorting

You can sort data based on following fields: id, quantity, line_item_id, batch_number_id

query SortBatchNumberLineItems(
  $where: QueryBatchNumberLineItemsWhereWhereConditions
) {
  BatchNumberLineItems(
    where: $where
    orderBy: [{ column: QUANTITY, order: DESC }]
  ) {
    id
    quantity
    line_item { id }
    batch_number { id }
  }
}

Example of data returned

{
  "data": {
    "BatchNumberLineItems": [
      {
        "id": 100001,
        "quantity": 25.5,
        "line_item": { "id": 100001 },
        "batch_number": { "id": 100010 }
      },
      {
        "id": 100002,
        "quantity": 15.0,
        "line_item": { "id": 100002 },
        "batch_number": { "id": 100011 }
      }
    ]
  }
}