Filters

How Did I Get Here?

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

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.

Your Filters

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

An example from a demonstration event.

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.

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.

Expression

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

Example Expressions

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