The following table shows field support for filters and sorting for the Query Variants method:
| Field | Supported Filters | Sortable |
|---|---|---|
id | $eq, $in, $ne, $nin | Sortable |
productData.productId | $eq, $in, $ne, $nin | Sortable |
The following table shows field support for filters and sorting for the Search Variants method:
| Field | Supported Filters | Sortable | Field Search |
|---|---|---|---|
productData.name | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | Searchable |
productData.slug | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | |
productData.productId | $eq, $in, $ne, $nin | Sortable | |
productData.productType | $eq, $ne, $in | Sortable | |
productData.visible | $eq, $ne, $exists, $in, $any | Sortable | |
productData.visibleInPos | $eq, $ne, $exists, $in, $any | Sortable | |
productData.directCategoryIds | $eq, $ne, $exists, $in, $any, $all | Sortable | |
sku | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | |
barcode | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | |
optionChoices.optionChoiceIds.optionId | $eq, $ne, $exists, $in, $any, $begins | Sortable | |
optionChoices.optionChoiceIds.choiceId | $eq, $ne, $exists, $in, $any, $begins | Sortable | |
price.actualPrice.amount | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | |
price.compareAtPrice.amount | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable | |
inventoryStatus.inStock | $eq, $ne, $exists, $in, $any | Sortable | |
inventoryStatus.preorderEnabled | $eq, $ne, $exists, $in, $any | Sortable | |
visible | $eq, $ne, $exists, $in, $any | Sortable |
Related content: API Query Language, Query Variants, Search Variants