Skip to main content

Query Strings: technical search

The Eventmaker participant list includes a powerful advanced search engine that allows using query strings directly in the search bar.

These commands allow applying complex filters, combining precise criteria, and accessing data that cannot be obtained through the standard interface.

⚠️ Warning: advanced searches appear in the URL.
A URL cannot exceed 2000 characters.
If your search contains too many criteria, split it into multiple queries.

1. Keywords & available operators

1.1 Check-in points

Keyword

Description

accepted_at / rejected_at

Filter on green/red access (green_access_control_ids and red_access_control_ids)

present_at

Same as accepted_at, but based on in_access_control_ids (more entries for entrances than exits)

checked_in_at

Returns check-ins regardless of status

👉 Access point names accept regex or IDs.

1.2 Thematics

Keyword

Function

thematics

Filters participants by thematic (thematic_ids). Supports AND.

prefixes_interest_in

Filters on interest levels (no, low, moderate, high, extreme). Supports AND / OR.

Examples:

thematics:innovation thematics:innovation thematics:design high_interest_in:marketing no_low_interest_in:ai

1.3 Engagement

Keyword

Description

engagement_levels

Returns participants according to their engagement_quartile

Possibilities:

engagement_levels:low,moderate

→ OR only

1.4 Expected access

Keyword

Description

expected_at

Filters by the access points a participant is authorized for

Supports AND:

expected_at:MainEntrance expected_at:VIP

1.5 Categories & populations

Keyword

Function

guest_category

Filters by category (name or ID). Only the last occurrence is considered.

population

Same as guest_category, but applied to the population

⚠️ No space between guest_category: and the value.

1.6 Technical IDs

  • *_id allows targeting an ID directly
    Example:

guest_category_id:56a8a359e8035...

1.7 Registration dates

Keyword

Function

registered_before

Participants registered before a date

registered_after

Participants registered after a date

Example:

registered_before:"2023-04-01 12:00 UTC" registered_after:"2023-03-01 00:00 UTC"

1.8 Registration statuses

Keyword

Function

status

Filter by registration status

payment_status

Filter on payment status

sso_status

Filter on SSO status

Possible SSO statuses:
​has_account, no_account, unconfirmed_account

Example:

status:registered,cancelled

→ OR

1.9 Labels

Can do AND or OR:

label:VIP label:VIP label:PREMIUM label:VIP,PREMIUM

1.10 Missing a field

no:field_name returns people who do not have this field.

Examples:

no:email no:last_name

⚠️ Only works on native fields.

1.11 Promo codes

promo_code:DISCOUNT10 promo_code:WELCOME,VIP

→ OR only

The text must match the promo code exactly.

1.12 Language

locale:fr locale:en

1.13 Attendance / check-in dates

Keyword

Description

first_attended_date

Date of the first check-in

attended_date

Filter on check-ins for a specific date

Accepted formats:
​YYYY-MM-DD, DD/MM/YYYY, DD-MM-YYYY…

1.14 Global email statistics

Keyword

Description

email_sent

Has received an email

email_opened

Has opened an email

email_clicked

Has clicked

email_bounced

Email bounced

email_spammed

Marked as spam

email_blocked

Blocked

Values: true, false, 1, 0

1.15 Opt-in & campaign capability

Keyword

Function

account_campaign_optin

Global opt-in

event_campaign_optin

Event-specific opt-in

campaign_optin

Indicates if Eventmaker can send emails (composite rule)

1.16 Participation type

attendance_type:virtual attendance_type:physical attendance_type:virtual_only attendance_type:physical_only

2. Exclusions

You can exclude participants from a search using the notation:

-field:value

Examples:

-country:france -country:france,uk -country:null -first_attended_date:"2024-01-10" -guest_category:"VIP"

Advanced examples:

checked_in_at:Entrance -checked_in_at:Exit

3. Classic search

  • my search → searches in searchable_keywords via regex

  • first_name:jean last_name:claude

  • Possibility to search directly for a participant ID

4. Multi-value fields

Some fields can contain multiple values.

Example:

products:"books,movies"

→ Returns participants having at least these two values in the products field.

5. Sort results

Use sort: to order your search by:

  • registered_at

  • created_at

  • last_name

  • company_name

  • rank

Examples:

sort:created-asc sort:lastname-asc sort:companyname-desc

6. Special cases – Quotes & regex

If a category name / access point contains quotes, they must be escaped:

guest_category:"Catégorie \"VIP\" Deluxe" accepted_at:"Entrée \"Grand Hall\""

Conclusion

The Eventmaker advanced search is an extremely powerful tool that allows:

  • to precisely query your participant database,

  • to cross complex criteria,

  • to filter by accessibility, attendance, engagement, campaigns, opt-in, labels, thematics, dates, statuses, etc.

When used correctly, it replaces many unnecessary exports and becomes a true real-time analysis tool.

Related Articles
Visibility Restrictions: Website & Email
Did this answer your question?