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 |