The following table shows field support for filters and sorting for the item object:
| Field | Supported Filters | Sortable |
|---|---|---|
id | $eq, $ne, $in, $nin | Sortable |
createdDate | $eq, $ne, $gt, $lt, $gte, $lte | Sortable |
updatedDate | $eq, $ne, $gt, $lt, $gte, $lte | Sortable |
name | $eq, $ne, $in, $nin, $startsWith | Sortable |
description | $eq, $ne, $in, $nin, $empty, $startsWith | Sortable |
image | $exists | Sortable |
image.id | $eq, $ne | Sortable |
priceVariants.variants.price | $eq, $ne | Sortable |
priceVariants.variants | $exists | Sortable |
priceVariants.variants.variantId | $hasSome | Sortable |
orderSettings | $exists | Sortable |
orderSettings.inStock | $eq, $ne, $in, $nin, | Sortable |
orderSettings.acceptSpecialRequests | $eq, $ne, $in, $nin | Sortable |
labels | $exists | Sortable |
labels.Id | $hasSome | Sortable |
modifierGroups.id | $hasSome | Sortable |
Related content: API Query Language, Query Items.