The following table shows field support for filters and sorting for the Query Gift Cards method:
| Field | Supported Filters | Sortable |
|---|---|---|
_id | $eq, $ne, $exists, $in, $startsWith, $gt, $lt, $le, $ge | Sortable |
_createdDate | $eq, $ne, $exists, $in, $lt, $le, $gt, $ge | Sortable |
_updatedDate | $eq, $ne, $exists, $in, $lt, $le, $gt, $ge | Sortable |
code | $eq, $ne, $exists, $in, $startsWith, $gt, $lt, $le, $ge | Sortable |
codeSuffix | $eq, $ne, $exists, $in, $startsWith, $gt, $lt, $le, $ge | Sortable |
balance | $eq, $ne, $exists, $in | Sortable |
expirationDate | $eq, $ne, $exists, $in, $lt, $le, $gt, $ge | Sortable |
initialValue | $eq, $ne, $exists, $in | Sortable |
The following table shows field support for search, aggregation, sorting, and filtering for the Search Gift Cards method:
| Field | Capabilities | Filters | Sortable |
|---|---|---|---|
_id | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable |
_createdDate | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte | Sortable |
_updatedDate | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte | Sortable |
code | Search: ✓ Aggregate: ✗ | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable |
codeSuffix | Search: ✓ Aggregate: ✓ | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte | Sortable |
balance | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any | Sortable |
expirationDate | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte | Sortable |
initialValue | Search: ✗ Aggregate: ✓ | $eq, $ne, $exists, $in, $any | Sortable |
Related content: API Query Language, Query Gift Cards, Search Gift Cards