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.

Updated over a week ago

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?