The following table shows field support for filters and sorting for the Account object:
| Field | Query Filter Operators | Sortable |
|---|---|---|
id | $eq, $ne, $hasSome, $startsWith, $in, $nin, $exists | Sortable |
contactId | $eq, $ne, $hasSome, $startsWith, $in, $nin, $exists | Sortable |
memberId | $eq, $ne, $hasSome, $startsWith, $in, $nin, $exists | Sortable |
tier.id | $eq, $ne, $hasSome, $startsWith, $in, $nin, $exists | Sortable |
points.balance | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
points.earned | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
points.adjusted | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
points.redeemed | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
points.expired | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
createdDate | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
lastActivityDate | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
pointsExpiration.expirationDate | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |
pointsExpiration.expiringPointsAmount | $eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gte | Sortable |