CaInt0004

entrydate=March 23, 2011

topic=CaIntegrator Usage

Qtext=
How to use the data search panel to perform a query that contains both "and" and "or" logical operators I want to run a query containing both "and" and "or" operators (see an example query below). However, I could not find the selection buttons to construct such a query. Is there any way around it?

Select:
all patients who are male  AND their tumor subtypes = "Classical" 
OR
all patients who are female

Related Forum Posting

Atext=
In current design, the radio buttons for logical operators are at the end of the entire query, therefore, users can only choose either "OR" or "AND" for the whole query. A more complex query as stated in the question requires the flexibility to select logical operator at the end of each SQL predicate. This feature was not present in the current version.
 
One way to get around this in current version of caIntegrator is to execute the query in multi-steps. See illustration below:
<gallery widths=500px heights=300px perrow=2">
Image:Step1a.png

Step 1: Execute a query to select all patients who are male AND their tumor subtypes = "Classical"; (Click on the picture to enlarge)
Image:Step2a.png

Step 2: Save the query results as a subject list; (Click on the picture to enlarge)
</gallery>