Filters

Work In Progress - Information May Not Be Complete.
Advanced Feature - Support May Be Limited
How Did I Get Here?

To get to the Filters features set, click through Organization Filters (on the Organization page).

img

All examples taken from a demonstration event.

This will open the Filters page.

Filters Page

The main Filters page provides a list of your current filters and allows you to create more.

img

Your Filters

Once you have created Your Filters, they will be listed on the Filters page.

img

An example from a demonstration event.

Create New Filter

The Filters page is the default location to Create New Filters for use with your organization. These apply to all of your events. Clicking the Create New Filter button will open the Add Filter popup.

img


Name

Give your Filter a name that allows you to quickly identify it.

Table

You will select a table from the drop-down selector to which the Filter will be applied.

img

Expression

The expression is the condition the Filter will compare to when it is used for selections, etc.

Example Expressions

Please Note: “Participant" is interchangeable with “Bidder" for the following.

Filters are implicitly run in the context of a specific table, for example participants, items, … .

Operators

Logical operators: or, || and | can be used for 'or', and, && and & for 'and' and not and ! for negation.
Comparison operators: =, >, <, >= and <=.

Items:

  • title = 'Best Seat in the House!'
  • value > 1250
  • value >= 1250
  • value > 100 and value < 400
  • title = 'buy-in-party 1'
  • title = 'buy-in-party 1' and value > 600
  • type = 'Online’
  • type = 'Online' or type = 'forSale’
  • receiptRequired
  • receiptRequired or not receiptRequired
  • description = ''

Participants:

  • outstandingBalance > 0
  • itemsWon participants that have at least one transaction
  • itemsWon[item.number = '1'] participants with transactions in which the item number is 1
  • HasAssignedTicket & MealChoice = ''
  • Tags = 'GOLF' & Tags = 'SPONSOR-GUEST' or Tags = 'GOLF SPONSOR-GUEST
  • purchasedTickets[not isSpecifiedGuest] (in participants) gives all the records of participants who have purchased ticket but not specified the guest.

Inherited Tags:

  • tags = 'VIP' or tags = 'VIP | CSTest' matches on any of ABC or DEF via Advanced Tagging.

Filter through a set (a list of results):

Participants:

  • itemsWon[item.number = '19'] participants with transactions in which the item number is 19
  • ItemsWon[Item.Number = 'GOLD']
  • ItemsWon[Item.TicketType = 'Admission']
  • ItemsWon[Item.isEvent]

WARNING

We don't implement a full expression language (i.e., no support for arithmetic operators), you can’t say: startingBid + bidIncrement > 1000.


Last reviewed: June 2024
Filters
/organizations/reference_organizations/filters/
organizations
reference_organizations
filters
Filters