Picking Order Items

pickingOrderItems Query

Audience: Programmers

Returns a paginated list of PickingOrderItem objects, with optional filtering and ordering. This query allows you to retrieve individual line items from picking orders across the system.

Arguments

Name	Type	Description
after	Cursor	Returns the elements in the list that come after the specified cursor
first	Int	Returns the first n elements from the list
before	Cursor	Returns the elements in the list that come before the specified cursor
last	Int	Returns the last n elements from the list
orderBy	PickingOrderItemOrder	Ordering options for PickingOrderItems returned from the connection
where	PickingOrderItemWhereInput	Filtering options for PickingOrderItems returned from the connection

Return Type

PickingOrderItemConnection! - A connection to a list of PickingOrderItem objects with pagination information.

Fields Available

The PickingOrderItem type includes:

Field	Type	Description
id	ID!	Unique identifier for the order item
tenantID	UUID!	Tenant identifier
orderID	ID!	ID of the associated picking order
quantity	Int!	Quantity of the item to be picked
sku	String!	Stock keeping unit identifier
dataTypeID	UUID	Optional data type ID for custom validation
dataTypeSlug	String	Optional data type slug for custom validation
data	Map	Custom data associated with the order item as JSON
createdAt	Time!	When the order item was created
createdBy	UUID!	User who created the order item
updatedAt	Time	When the order item was last updated
updatedBy	UUID	User who last updated the order item
deletedAt	Time	Soft deletion timestamp
deletedBy	UUID	User who deleted the order item
order	PickingOrder!	The associated picking order

Notes

• The data field contains custom item attributes as JSON

• You can use the Data, DataHasKey, DataIn, and DataContains filters to query based on JSON content

• The sku field is federated and can be used to resolve inventory item details from other services

• Each order item is linked to exactly one picking order via the orderID field

Usage Example

Basic Query

query GetPickingOrderItems {
  pickingOrderItems(
    first: 10,
    orderBy: { direction: DESC, field: CREATED_AT },
    where: {
      sku: "PROD-12345"
    }
  ) {
    edges {
      node {
        id
        sku
        quantity
        orderID
        data
        order {
          id
          customerID
          createdAt
        }
        createdAt
        updatedAt
      }
      cursor
    }
    pageInfo {
      hasNextPage
      endCursor
    }
    totalCount
  }
}

Query with JSON Field Filtering

query FilterByCustomData {
  pickingOrderItems(
    first: 20,
    where: {
      DataHasKey: "priority",
      DataContains: ["high"]
    }
  ) {
    edges {
      node {
        id
        sku
        quantity
        data
      }
    }
    totalCount
  }
}

JavaScript Example

const getPickingOrderItemsQuery = `
  query GetPickingOrderItems($first: Int, $after: Cursor, $where: PickingOrderItemWhereInput) {
    pickingOrderItems(first: $first, after: $after, where: $where) {
      edges {
        node {
          id
          sku
          quantity
          orderID
          data
          order {
            id
            customerID
            createdAt
          }
          createdAt
          updatedAt
        }
        cursor
      }
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      totalCount
    }
  }
`;

const variables = {
  first: 10,
  where: {
    sku: "PROD-12345"
  }
};

// Using fetch or your preferred GraphQL client
const response = await fetch('/graphql', {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer YOUR_TOKEN'
  },
  body: JSON.stringify({
    query: getPickingOrderItemsQuery,
    variables: variables
  })
});

const result = await response.json();
console.log('Picking order items:', result.data.pickingOrderItems);

// Pagination example - fetching next page
if (result.data.pickingOrderItems.pageInfo.hasNextPage) {
  const nextPageVariables = {
    ...variables,
    after: result.data.pickingOrderItems.pageInfo.endCursor
  };
  // Make another request with nextPageVariables
}

Related Queries

• pickingOrders - Query complete picking orders

• nodePicking - Retrieve specific picking objects by ID

Related Mutations

• createPickingOrderItem - Create a new picking order item

• updatePickingOrderItem - Update an existing picking order item

• deletePickingOrderItem - Delete a picking order item