InventoryItemWhereInput

Input type for filtering InventoryItem objects with comprehensive query predicates

Input type used for filtering InventoryItem objects. It provides a comprehensive set of predicates for filtering items based on various criteria.

Fields

Field	Type	Description
not	InventoryItemWhereInput	Negates the provided conditions
and	[InventoryItemWhereInput!]	All conditions must match (logical AND)
or	[InventoryItemWhereInput!]	At least one condition must match (logical OR)
id	ID	Equal to ID
idNEQ	ID	Not equal to ID
idIn	[ID!]	ID in the provided list
idNotIn	[ID!]	ID not in the provided list
idGT	ID	ID greater than
idGTE	ID	ID greater than or equal
idLT	ID	ID less than
idLTE	ID	ID less than or equal
tenantID	UUID	Equal to tenant ID
tenantIDNEQ	UUID	Not equal to tenant ID
tenantIDIn	[UUID!]	Tenant ID in the provided list
tenantIDNotIn	[UUID!]	Tenant ID not in the provided list
createdAt	Time	Equal to creation timestamp
createdAtGT	Time	Creation timestamp greater than
createdAtGTE	Time	Creation timestamp greater than or equal
createdAtLT	Time	Creation timestamp less than
createdAtLTE	Time	Creation timestamp less than or equal
sku	String	Equal to SKU
skuNEQ	String	Not equal to SKU
skuIn	[String!]	SKU in the provided list
skuNotIn	[String!]	SKU not in the provided list
skuContains	String	SKU contains substring
skuHasPrefix	String	SKU starts with prefix
skuHasSuffix	String	SKU ends with suffix
skuEqualFold	String	SKU equals case-insensitive
skuContainsFold	String	SKU contains substring case-insensitive
dataTypeIDIsNil	Boolean	Data type ID is null
dataTypeIDNotNil	Boolean	Data type ID is not null
dataTypeSlug	String	Equal to data type slug
dataTypeSlugEqualFold	String	Data type slug equals case-insensitive
hasItemstock	Boolean	Has stock records
hasItemstockWith	[StockWhereInput!]	Has stock records matching conditions
hasItemmovementitem	Boolean	Has item movements
hasItemmovementitemWith	[ItemMovementWhereInput!]	Has item movements matching conditions
Data	[String!]	Match exact value at JSON path. Format: ["path", "value"]
DataHasKey	String	Check if key exists at JSON path
DataIn	[String!]	Value at path is in list. Format: ["path", "value1", "value2", ...]
DataContains	[String!]	String at path contains substring. Format: ["path", "substring"]

Usage Example

query {
  # Find items with SKU containing "PHONE" and created in the last month
  inventoryItems(
    where: {
      and: [
        { skuContainsFold: "PHONE" },
        { createdAtGTE: "2023-05-01T00:00:00Z" }
      ]
    }
  ) {
    edges {
      node {
        id
        sku
        data
      }
    }
  }
}

query {
  # Find items that have stock in a specific repository
  inventoryItems(
    where: {
      hasItemstockWith: [
        { repositoryID: "warehouse-main" }
      ]
    }
  ) {
    edges {
      node {
        id
        sku
        itemstock {
          repositoryID
          quantity
        }
      }
    }
  }
}

query {
  # Find items with specific data properties
  inventoryItems(
    where: {
      Data: ["color", "red"],
      DataHasKey: "size"
    }
  ) {
    edges {
      node {
        id
        sku
        data
      }
    }
  }
}

query {
  # Find items with nested JSON data
  inventoryItems(
    where: {
      and: [
        { Data: ["specifications.material", "aluminum"] },
        { DataIn: ["specifications.finish", "matte", "glossy", "brushed"] },
        { DataContains: ["description", "professional"] }
      ]
    }
  ) {
    edges {
      node {
        id
        sku
        data
      }
    }
  }
}

JSON Query Examples

For more comprehensive examples of JSON field queries, including complex path queries and performance tips, see JSON Field Queries.