ByQuery

Description: Defines the audience by uploading a file (e.g., a spreadsheet) containing a specific list of participant identifiers.

Use Case: Ideal for targeting a predefined, static list of individuals.

How to setup a rule ByQuery

1. General Settings

• Applicability type: A dropdown menu to select the method for determining applicability. The example shows ByQuery selected.

2. Query Configuration

• Query: A mandatory text area where the custom SQL query is written.

• Query result: A read-only field that displays the number of results returned by the query after processing.

3. Individual Testing

• Party to test: A search field to find a specific individual or party to test against the custom query.

• Test Result: A read-only field that displays the outcome of the test, indicating whether the searched party is included in the query's results.