Subquery is a powerful type of query that enables users to build complex queries. Users can use the results of another saved query as input to the current query. The operators 'Is One Of' and 'Is Not One Of' can be used to achieve this.

Use Case: User wants to distribute Plasma samples to a researcher(Researcher I), but wants to exclude the samples distributed to a particular researcher(Researcher II)

Query 1: Search for participants whose specimens are distributed to Researcher II

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

To limit your query to a specific protocol, include the CP Short Title in the filters. The CP/CPG chosen in the ‘Choose Collection Protocol / Group’ section does not automatically transfer to subquery results, providing greater flexibility and reusability for your queries.

Parameterized subqueries

While including results of another query as a filter in a query, it can now be specified a parameterized filter.

Consider for example, find patients having breast disorders but not thyroid cancer. User might want to choose from multiple diagnosis 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