Query (Find) Registrations

Query (Find) Registrations

The Query Registrations page enables you to quickly find one or more registrants, using potentially very detailed searches.

How to Use the Query Registrations Page

1. Build your query using the options included in the Filters section below. The defaults columns to query are First Name, Last Name, Email, Reg Cod e, Organization, and Username. Change and/or add columns as necessary. 2. Click Search to display a Report Results window listing the registrations that match your query. 3. As for any Report Results, you can then perform Actions (such as Compose Email or Manage Itineraries), or run Mass Actions such as setting properties or changing status), or click a result number link in the first column to open that registrant's record.

Video: Finding a Registration (1 min.)

Filters

Use this section to find registrants based on profile and/or registration information.

Columns

There five columns pre-selected, joined by "and": First Name, Last Name, Email, Reg Cod e and Organization. To change any of them, select a data field from the drop-down list. The fields available are under several sub-headings.

Operator

Select the operator to use in assessing the Value you enter or select.

OperatorUse for
=Equals
>Greater than (numeric values only)
<Less than (numeric values only)
>=Greater than or equal to (numeric values only)
<=Less than or equal to (numeric values only)
<>Does not equal
is one ofA list of items against which the field will be evaluated. The field value must be found in the list for the condition to be met. Note: Each item must be separated by a comma from the next, with no intervening space, as in: value 1,value 2,value 3.
is not one ofA list of items against which the value will be evaluated. The field value cannot be in the list for the condition to be met. Note: Each item must be separated from the next one by a comma, with no intervening space, as in: value 1,value 2,value 3.
containsString of characters that appears anywhere within the field.
does not containString of characters that should not be found anywhere within the field.
begins withString of characters at the beginning of the field.
does not begin withString of characters that should not be found at the beginning of the field.
ends withString of characters at the end of the field.
does not end withString of characters that is not found at the end of the field.
is blankThe field has nothing in it.
is not blankThe field has any value in it.

Value

Enter the value on which to search.

To add additional search criteria, first select an appropriate value in the drop-down list of conjunctions at the beginning of the next row: and, or, )and(, )or(.

Another set of Columns / Operator / Value fields is displayed. Select or enter values as you did for the first five.

You can repeat that for additional sets as necessary, combining the conjunctions to make your logic as complex as required.

Standard Filters

Use this section to find registrants based on any combination of these four filters:

Date Filters

Use this section is to find registrants based on when various registration-related actions occurred.

For each of and Interval #2:

Source:

Keywords: Query (Find) Registrations, registrants, filters, registration status