Filter events, orders, customers, invoices, and attendees

Use filters when an event , order , customer, invoice , or attendee list is too large to scan manually.

Steps

Open the relevant list: Events, Orders, Customers, Invoices, or Attendees.
Select Filter by or the filter button.
Choose the filter group, such as state, event, payment state, date, customer, tag, or location.
Select the filter value.
Close the filter panel or press Escape when the list updates.
Use Clear to remove filters when you are done.

Customer list filtered to similar records — Filters help staff narrow customer and sales lists before opening the correct record.

Filter events by bookings, reservations, and capacity

The event list provides three independent filter groups:

Filter group	Values	What the values mean
Bookings	Has bookings, No bookings	Includes or excludes events with an active booked order item or an active standalone booked attendee.
Reservations	Has reservations, No reservations	Includes or excludes events with an active reserved order item or an active standalone reserved attendee.
Capacity	Overbooked, Not overbooked	Compares booked and reserved capacity usage with the event's effective capacity.

Canceled, expired, and discarded order items and canceled standalone attendees do not count as bookings or reservations. A booked order item counts even when it does not create an attendee record.

Overbooked means that capacity-consuming bookings and reservations are strictly greater than the lower of the event's participant capacity and its available resource capacity. An event exactly at capacity is Not overbooked. Order-backed attendees are not counted again because their capacity is already represented by the order's event reservation.

Filter groups combine with AND. For example, selecting Has bookings and Has reservations returns only events that have both. Selecting both values inside one group does not restrict the list. Event filters also work in the archived event list and can be stored in a saved view.

How offer filters handle changed orders

Offer-based order filters use the order's current line items. If an event, admission, product, or voucher was removed from an order or replaced with another offer, the removed line no longer makes the order match that offer or its tag, date, time, or location. The change remains available in the order's history.

During the standard cancellation workflow, KORONA Event removes the order's active line items. The canceled order then stops matching offer, tag, date, time, and location filters. A canceled order matches these filters only in the exceptional case that it retains an active line item. Use an order-state filter when you need to include or exclude canceled orders.

Useful filter combinations

Job	Filters to start with
Find unpaid bookings	Order state, payment state, date range.
Find duplicate customers	Name or email text search, customer group, external reference where used.
Finance review	Invoice payment state, date range, location or POS.
Entrance issue	Event, attendee state, ticket number, customer name.
Find capacity problems	Event capacity: Overbooked; optionally add date, location, or resource.

Saved-view notification emails

When notifications are enabled for a saved view, KORONA Event emails subscribed back-office users when an order newly matches that view. The email names the saved view, identifies the order, and includes a link to open it.

The Matched at time in the email uses the timezone configured for the account, including daylight-saving time changes.

Expected result

The list shows only records that match the selected filters, and the active filters are visible enough for staff to understand why records are included.

Troubleshooting

Problem	What to check
Expected record is missing	Clear filters, expand date range, search by exact number, and check archived or canceled views.
Too many records remain	Add a date, state, event, or customer filter.
Filter seems stuck	Select Clear, reload the list, or remove saved URL filters.