Filters

Learn how to create saved filters that select groups of records, such as participants or items, across your organization.

A filter is a saved condition that selects records from one table, such as "participants with an outstanding balance" or "items valued between $100 and $500". Filters belong to your organization, so you can use them in any of its events.

Saved filters can be used in reports and anywhere the dashboard offers a filtered view.


Opening the Filters Page

  1. Click Organization in the left sidebar.
  2. Click Filters in the organization sidebar.

Filters page with filters grouped into tables by record type

An example Filters page from a demonstration event.

Filters are grouped into one table per record type, such as Bidder Filters. Each table has these columns:

ColumnDescription
NameThe filter's name.
DescriptionAn optional note about what the filter selects.
ExpressionThe condition the filter checks.

Each filter also has edit and delete buttons.

If you haven't created any filters yet, the page shows No filters defined and a Create your first filter button.


Creating a Filter

Steps

  1. Click Create New Filter in the Filters page sidebar. If you don't have any filters yet, you can also click Create your first filter.
  2. Fill in the Add Filter window (see the fields below).
  3. Click Create Filter.

Add Filter window with the Name, Table, Description, and filter builder fields

The Add Filter window.

Add Filter Fields

FieldDescription
NameRequired. Use only letters, digits, and spaces. Each name must be unique. Choose a name that makes the filter easy to recognize, such as High Value Items or VIP Ticket Holders.
TableThe type of record the filter selects: Bidder, Item, Donor, Bid History, or Ticket. You can't change the table after the filter is saved.
DescriptionOptional. A note about what the filter selects.
Visual builderWhere you define the condition. It opens in text mode, where you type the expression. Use the switch to change to the visual builder.

Editing a Filter

Click the edit button on a filter's row to open it. Make your changes, then click Save Filter.

Renaming a Filter

"Any slide, filter or report that references this filter by name will stop working." Update anything that uses the old name after you rename a filter.


Deleting a Filter

Click the delete button on a filter's row, then confirm in the Delete Filter box.

Deleting a Filter Can't Be Undone

Once you confirm, the filter is permanently deleted.


Writing Filter Expressions

In text mode, you type the expression that decides which records match the filter. Think of it as a question: "Which records meet this condition?" For example, value > 100 means "which items have a value greater than 100?"

Comparison Operators

OperatorMeaning
=Equals
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to

Logical Operators

  • and, &&, or &: both conditions must be true.
  • or, ||, or |: at least one condition must be true.
  • not or !: the opposite of the condition.

Item Examples

To FindExpression
A specific item by titletitle = 'Best Seat in the House!'
High-value itemsvalue > 1250
Items in a price rangevalue > 100 and value < 400
A specific item typetype = 'Online'
More than one item typetype = 'Online' or type = 'forSale'
Items that require receiptsreceiptRequired
Items with no descriptiondescription = ''

Participant Examples

To FindExpression
Participants with a balance dueoutstandingBalance > 0
Participants who won at least one itemitemsWon
Participants with tickets but no meal choiceHasAssignedTicket & MealChoice = ''
Participants with a specific tagtags = 'VIP'
Participants with two specific tagsTags = 'GOLF' & Tags = 'SPONSOR-GUEST'
Participants who bid but didn't winItemsBidOn and no Transactions

Invite Participants Who Didn't Win to Donate

Use the bid but didn't win filter to send a custom email to participants who bid but didn't win an item or make a donation, inviting them to donate.

Use square brackets ([ ]) to check records related to the one you're filtering:

To FindExpression
Participants who won item number 19itemsWon[item.number = '19']
Participants who won an item with a specific ticket typeItemsWon[Item.TicketType = 'Admission']
Participants who won event itemsItemsWon[Item.isEvent]
Ticket purchasers who haven't specified guestspurchasedTickets[not isSpecifiedGuest]

No Arithmetic

Filters don't support calculations. An expression such as startingBid + bidIncrement > 1000 won't work. Compare fields directly to values instead.


Tips for Effective Filters

Start simple. Begin with basic filters and build up to more complex ones as you get comfortable with the syntax.

Test your filters. After creating a filter, check that it returns the records you expect.

Use descriptive names. Names like Items Over 500 are easier for your team to find than Filter 3.

Combine conditions carefully. When you use and and or together, the order matters. Think through your logic before you save a complex filter.


Last reviewed: November 2026
Filters
/organizations/filters/
organizations
filters
Filters
Learn how to create saved filters that select groups of records, such as participants or items, across your organization.
© Auctria 2013-2026