The subquery feature enables users to build complex queries. Users can use the results of one saved query as input to another query. The operators 'Is One Of' and 'Is Not One Of' can be used to achieve this.

Use Case: User wants to distribute Plasma specimens to a Distribution Protocol (DP) but wants to exclude any participants from whom specimens are already distributed to the same DP.

Query 1: Create a query for “Search for participants whose specimens are distributed to the DP”

Query 2: Search for participants whose specimens aren’t distributed to Researcher II

Query 3: Search for participants with Plasma available and who haven’t been distributed to Researcher II

Parameterized subqueries

When including results of another query as a filter in a query, you can now specify a parameterized filter.

Consider, for example, finding patients having breast disorders but not thyroid cancer. A user might want to choose from multiple diagnoses related to breast disorders while running the query.

Step 1: Create a saved query with clinical diagnosis as a parameterized filter Step 2: Use saved query as input filter in the final query. Step 3: This way, the clinical diagnosis will appear as filter in the results view for users to choose filter values at run time. Select required diagnosis which will be replaced for filtering participants with and without specific diagnoses

Subquery

Parameterized subqueries

Subqueries: FAQ