Filters
How Did I Get Here?
To get to the Filters features set, click through Organization Filters (on the Organization page).
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.
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.
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 transactionitemsWon[item.number = '1']
participants with transactions in which the item number is 1HasAssignedTicket & MealChoice = ''
Tags = 'GOLF' & Tags = 'SPONSOR-GUEST'
orTags = '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'
ortags = '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 19ItemsWon[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