Chapter 8User Manual · Release 2026.2.0Updated 2026-07-152 min read

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.

Magana Trial Manager: MQL (Magana Query Language) — MQL participant list

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.

Magana Trial Manager: MQL (Magana Query Language) — MQL help1
Magana Trial Manager: MQL (Magana Query Language) — MQL help2

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
Magana Trial Manager: Examples — MQL selection table

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.