MQL (Magana Query Language)
On this page (1)
MQL is a simple query language that you can use to find a subset of participants based on the content of their forms, available in the participant list > Advanced search. The language has access to the question title/text and the data entered as well as participant status.

The search form features extensive online help – i.e. it will show available questions that match your input and all allowed operators for your search term. The shown suggestions are clickable so you can easily construct the terms by typing a few letters, selecting the desired term or operator and go on. While typing, the suggestions will keep narrowing down to those that match your input.


Searchable item types include single/multiple choice, text, number, date, slider, table (per cell), computed, upload and signature. Layout elements, identity, catalog questions, nested forms and image-maps items are not searchable at this point.
Basics
The most basic term will compare the content of a question to a given value. The comparison is defined by operators
- Numeric values, dates and times:
==, >=, <=, >, <, is - Text values:
is, is not, contains - Selections (multiple choice):
is checked, is not checked, is empty
logical operations
You can combine multiple terms using the logical operators and, or, not. You
can use parentheses ((, )) to group your expressions.
Specifying visits
If you want to refer to a question in a specific visit, append in Visitname to
the field description where Visitname is the name of the visit you want.
Otherwise, all occurrences in any visit will match.
Filtering by site
Using the center keyword you select a specific study site.
Examples
Participants younger than 30
Age < 30
Participants for whom the feedback question has been answered
General Feedback is not empty
Participants with status active
status is 'active'
Participants consented before January 2026
Date of Consent < '2026-01-01'
Female participants older than 20
Sex · Female is checked and Age > 20
Diabetics from site Munich
Previous condition · Diabetes is checked and center is 'Munich'
Participants who took a medication containing "olol" in the respective freetext field
Medication contains 'olol'
Finding items in tables works exactly the same way. E.g. Participants who rated Family to be very important in a table of items
Please rate... · Family very important is checked

Questions about Magana Trial Manager?
Try setting up your own eCRF in a free test account, or reach out to our team in Regensburg — we usually reply within one business day.