Accounts: Supported Filters and Sorting

The following table shows field support for filters and sorting for the Account object:

FieldQuery Filter OperatorsSortable
id$eq, $ne, $hasSome, $startsWith, $in, $nin, $existsSortable
contactId$eq, $ne, $hasSome, $startsWith, $in, $nin, $existsSortable
memberId$eq, $ne, $hasSome, $startsWith, $in, $nin, $existsSortable
tier.id$eq, $ne, $hasSome, $startsWith, $in, $nin, $existsSortable
points.balance$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
points.earned$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
points.adjusted$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
points.redeemed$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
points.expired$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
createdDate$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
lastActivityDate$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
pointsExpiration.expirationDate$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
pointsExpiration.expiringPointsAmount$eq, $ne, $hasSome, $in, $nin, $exists, $lt, $lte, $gt, $gteSortable
Did this help?