Skip to content
Saleor
Esc
↑↓navigate↵open⌘Jpreview

Schema: Saleor 3.23.43Download SDLUpgrade guides

On this page

OrderWhereInput Input Type

input OrderWhereInput {
  metadata: MetadataFilterInput
  ids: [ID!]
  number: IntFilterInput
  channelId: GlobalIDFilterInput
  createdAt: DateTimeRangeInput
  updatedAt: DateTimeRangeInput
  user: GlobalIDFilterInput
  userEmail: StringFilterInput
  authorizeStatus: OrderAuthorizeStatusEnumFilterInput
  chargeStatus: OrderChargeStatusEnumFilterInput
  status: OrderStatusEnumFilterInput
  checkoutToken: UUIDFilterInput
  checkoutId: GlobalIDFilterInput
  isClickAndCollect: Boolean
  isGiftCardUsed: Boolean
  isGiftCardBought: Boolean
  voucherCode: StringFilterInput
  hasInvoices: Boolean
  invoices: [InvoiceFilterInput!]
  hasFulfillments: Boolean
  fulfillments: [FulfillmentFilterInput!]
  lines: [LinesFilterInput!]
  linesCount: IntFilterInput
  transactions: [TransactionFilterInput!]
  totalGross: PriceFilterInput
  totalNet: PriceFilterInput
  productTypeId: GlobalIDFilterInput
  events: [OrderEventFilterInput!]
  billingAddress: AddressFilterInput
  shippingAddress: AddressFilterInput
  AND: [OrderWhereInput!]
  OR: [OrderWhereInput!]
}

Fields

metadata

metadata · MetadataFilterInput

Filter by metadata fields.

ids

ids · [ID!]

number

number · IntFilterInput

Filter by order number.

channelId

channelId · GlobalIDFilterInput

Filter by channel.

createdAt

createdAt · DateTimeRangeInput

Filter order by created at date.

updatedAt

updatedAt · DateTimeRangeInput

Filter order by updated at date.

user

user · GlobalIDFilterInput

Filter by user.

userEmail

userEmail · StringFilterInput

Filter by user email.

authorizeStatus

authorizeStatus · OrderAuthorizeStatusEnumFilterInput

Filter by authorize status.

chargeStatus

chargeStatus · OrderChargeStatusEnumFilterInput

Filter by charge status.

status

status · OrderStatusEnumFilterInput

Filter by order status.

checkoutToken

checkoutToken · UUIDFilterInput

Filter by checkout token.

checkoutId

checkoutId · GlobalIDFilterInput

Filter by checkout id.

isClickAndCollect

isClickAndCollect · Boolean

Filter by whether the order uses the click and collect delivery method.

isGiftCardUsed

isGiftCardUsed · Boolean

Filter based on whether a gift card was used in the order.

isGiftCardBought

isGiftCardBought · Boolean

Filter based on whether the order includes a gift card purchase.

voucherCode

voucherCode · StringFilterInput

Filter by voucher code used in the order.

hasInvoices

hasInvoices · Boolean

Filter by whether the order has any invoices.

invoices

invoices · [InvoiceFilterInput!]

Filter by invoice data associated with the order. Each list item represents conditions that must be satisfied by a single object. The filter matches orders that have related objects meeting all specified groups of conditions.

hasFulfillments

hasFulfillments · Boolean

Filter by whether the order has any fulfillments.

fulfillments

fulfillments · [FulfillmentFilterInput!]

Filter by fulfillment data associated with the order. Each list item represents conditions that must be satisfied by a single object. The filter matches orders that have related objects meeting all specified groups of conditions.

lines

lines · [LinesFilterInput!]

Filter by line items associated with the order. Each list item represents conditions that must be satisfied by a single object. The filter matches orders that have related objects meeting all specified groups of conditions.

linesCount

linesCount · IntFilterInput

Filter by number of lines in the order.

transactions

transactions · [TransactionFilterInput!]

Filter by transaction data associated with the order. Each list item represents conditions that must be satisfied by a single object. The filter matches orders that have related objects meeting all specified groups of conditions.

totalGross

totalGross · PriceFilterInput

Filter by total gross amount of the order.

totalNet

totalNet · PriceFilterInput

Filter by total net amount of the order.

productTypeId

productTypeId · GlobalIDFilterInput

Filter by the product type of related order lines.

events

events · [OrderEventFilterInput!]

Filter by order events. Each list item represents conditions that must be satisfied by a single object. The filter matches orders that have related objects meeting all specified groups of conditions.

billingAddress

billingAddress · AddressFilterInput

Filter by billing address of the order.

shippingAddress

shippingAddress · AddressFilterInput

Filter by shipping address of the order.

AND

AND · [OrderWhereInput!]

List of conditions that must be met.

OR

OR · [OrderWhereInput!]

A list of conditions of which at least one must be met.

Used by


Schema: Saleor 3.23.43. Download SDL.

Last updated on April 13, 2026

Was this page helpful?