Query Builder: Allow some nested And/Or clauses

[joe-crawford]

Description

Currently the query builder allows selecting And or Or conditions, for example (Person.Birth_Dt_Tm <= 2000 AND Diagnoses.Diagnosis in ('D1', 'D2')). However, nested conditions are not possible, for example:

(Person.Birth_Dt_Tm <= 2000 AND (Diagnoses.Diagnosis in ('D1', 'D2') OR Procedures.Procedure in ('P1', 'P2')))

Additional context

I'm anticipating that this sort of query could be needed in many common cohort queries, for example in a cohort similar to the query above, which is selecting adult patients, who have certain diagnoses OR procedures.

[NigelPalmer]

@joe-crawford, nested And/Or clauses are possible. You just need to add a Rule Set and then within that Rule Set write your nested logic.

Maybe what we really need is a task that provided some help for the query builder?